My production environment is actually Oracle, in which case if I say:
It will treat it as a readonly table.
However, doing the same under MySQL throws an
ActiveRecord::StatementInvalid error, saying that the table db.view
doesn't exist. Is there a way to get around this? I am using MySQL to
test some new code I am working on, and wouldn't mind making the code
compatible across products.
Wow that's embarrassing, seconds after posting this it boiled down to a
Everything works now. Sorry for the list spam.
In case you need it, I've implemented a plugin for Rails which
supports views in migrations and schema dumps. You can find out more
It currently supports MySQL and PostgreSQL in the latest release and
SQL Server in the trunk.