Rails not respecting primary keys

There is some issue with Ruby on Rails not respecting primary key and other settings on columns when it does a schema dump of the db. It does this when you use a non-standard id column e.g. tablename_id and not just id.

There is a patch floating about that fixes this but a simpler way is to uncomment config.active_record.schema_format = :sql in your environment.rb. It then uses SQL and not Ruby for your schema and it respects your databases.

This entry was posted on Wednesday, April 18th, 2007 at 2:24 pm and is filed under Post, Ruby on Rails, config.active_record.schema_format, dump, key, mysql, primary key, rake, schema, test. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Viewing 1 Comment

Brendan Lally 1 year ago 1 point
Please login to rate.

Do you already have an account? Log in and claim this comment.

Paul,

I havn't seen that but then I normally map RoR into my already created db scheme (do don't normally have "id") on its own.
Normally dabble with Postgres but will checkout on MySql next time.

Is this just a 'recent' issue u've spotted?

Lal

reply edit reblog flag record video comment

http://lallylogic.startitup.net

Trackbacks

(Trackback URL)

Life is grand

Rails not respecting primary keys

Add New Comment

Viewing 1 Comment

Add New Comment

Trackbacks