Bug #2783
closed
db:convert:prod2dev fails on table 'architectures_operatingsystems'
Added by Scuba Floyd over 11 years ago.
Updated over 6 years ago.
Description
When converting MySQL to Postgres on Foreman1.2, I get the following error (full trace attached):
Converting architectures_operatingsystems...rake aborted!
PG::Error: ERROR: column "id" does not exist
LINE 1: ...re_id", "operatingsystem_id") VALUES ($1, $2) RETURNING "id"
^
: INSERT INTO "architectures_operatingsystems" ("architecture_id", "operatingsystem_id") VALUES ($1, $2) RETURNING "id"
The schemas are consistent on both DBs.
Files
I also got this bug about a month ago and was not successful to fix it quickly. I ended up using the taps gem to manually migrate my database from MySQL to Postgres. Not the best method. I hope someone volunteers to look at this bug. If not, I will look at it again.
My knowledge about Ruby and Rails is quite limited, but there's a boolean switch 'insert_returning' in ActiveRecord::ConnectionAdapters::PostgreSQLAdapter which defaults true. Maybe that is causing the trouble.
I'm also experiencing this issue, however I'm migrating from sqlite3 to pgsql.
- Related to Bug #3268: defer postgresql foreign key constraints for rake db:convert:prod2dev added
- Description updated (diff)
- Status changed from New to Ready For Testing
- Translation missing: en.field_release set to 3
- Assignee set to Greg Sutcliffe
- Target version set to 1.10.0
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
Updated by 
Updated by