Josh on Rails
2006-Apr-07 16:26 UTC
[Rails] Migrations & Postgres: Change column not functional?
I''ve got a MySQL app, which I''m moving to a new server which is using Postgres. This seems like the perfect application of migrations. (Note: I don''t mean "using migrations to switch from MySQL to Postgres" so much as "Hey, I''ve _been_ using migrations all along, and this is where I cash in".) There were some odd bugs when working with the site, and I traced it to two columns which had the "wrong" data types. Actually, they had *earlier* data types: Types that had changed in earlier migrations. It appears that Postgres didn''t execute a number of "change_column" instructions. It''s not clear to me, at this point, whether that was a Postgres error, or something else. Has anyone else seen this behavior? I''m also wondering if this might be version-dependent: I''ve got Postgres 7.4.7and Rails 1.0... -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060407/d194283f/attachment-0001.html
Maybe Matching Threads
- Changing column to NOT NULL with migration silently failing.
- Postgres + tsearch2, migrations, and unit testing
- migration error, mysql, change column limit
- Quoting column names, postgres and legacy databases
- How to use Postgres schemas in Rails app to separate data