One thing that I have recently found myself desiring is the ability to augment schema.rb with snippets of SQL.

For example, I use Postgres, and need to declare some case-insensitive indexes. This is not currently possible using Rails directly.

I don't want to switch to use the SQL schema dump format, because that's highly dependent on the database version. E.g. I am using Postgres 9, and another developer is using 8.4. We will probably end up overwriting each other's schema.sql files if we went this route.

But it would be nice to have, say, a db/schema_extra.sql where we could manually place additional stuff like our case-insensitive indexes or whatever.

Or views...

--
http://jonathanleighton.com/


--
You received this message because you are subscribed to the Google Groups "Ruby on 
Rails: Core" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-core?hl=en.

Reply via email to