My production environment is actually Oracle, in which case if I say: set_table_name "v_table" 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. Brian J.
on 2007-01-26 20:24
on 2007-01-26 20:26
Wow that's embarrassing, seconds after posting this it boiled down to a spelling mistake. Everything works now. Sorry for the list spam. Carry on. Brian J.
on 2007-01-26 20:40
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 at: http://activewarehouse.rubyforge.org/rails_sql_views/ It currently supports MySQL and PostgreSQL in the latest release and SQL Server in the trunk. V/r Anthony On 1/26/07, Brian J. <email@example.com> wrote: > > > > > -- Cell: 808 782-5046 Current Location: Melbourne, FL