When you create a view it doesn't create any migration code in the schema. If you rolback/reset you need to delete your schema.
Using the rails_sql_view gem fixes this as it dumps the schema correctly.
I used my fork of the rails_sql_view gem
s.add_dependency('rails_sql_views') #needs the 'rails_sql_views', :git => 'git://github.com/morgz/rails_sql_views.git' fork. Set this in your apps bundle
Don't know how to properly add :git => to the s.add_dependency line...
When you create a view it doesn't create any migration code in the schema. If you rolback/reset you need to delete your schema.
Using the rails_sql_view gem fixes this as it dumps the schema correctly.
I used my fork of the rails_sql_view gem
s.add_dependency('rails_sql_views') #needs the 'rails_sql_views', :git => 'git://github.com/morgz/rails_sql_views.git' fork. Set this in your apps bundle
Don't know how to properly add :git => to the s.add_dependency line...
My fork has this.