rails/rails — pull request #6238 by pwnall (2012-05-10 03:47:31+00:00)
Title: Postgresql doesn't accept limits on binary (bytea) columns.

PostgreSQL doesn't take a limit for binary columns so developers must choose between removing :limit from their binary column definitions, and not being able to target pgsql.

This change drops :limit specifications, when migrations are applied against a pgsql database. It's not ideal, because the limit information is lost. However, the mysql adapters do something similar to :text columns, so I hope the approach is OK.

This is a pain point for other developers:
http://stackoverflow.com/questions/4976368/heroku-migration-type-modifier-is-not-allowed-for-type-bytea
http://forums.xkcd.com/viewtopic.php?f=11&t=19087

The schema change in my commit makes the AcitiveRecord test suite fail on pgsql. After the adapter change, the tests pass again.