Issue on recreating schema from a dump with a view depending on another view

activewarehouse / rails_sql_views

Rails SQL Views project extracted from ActiveWarehouse

http://activewarehouse.rubyforge.org/rails_sql_views

MIT License

140 stars 127 forks source link

Issue on recreating schema from a dump with a view depending on another view #1

Open ghost opened 15 years ago

ghost commented 15 years ago

SchemaDumper orders views alphabetically. If we have a view named 'a' in which definition view 'b' is used, then schema loading will abort with PGError: ERROR: relation 'b' does not exist

robertwahler commented 15 years ago

I think this is addressed in this commit:

http://github.com/robertwahler/rails_sql_views/commit/3e70425950e96c116f2de5c7d396208965f15919