On Monday 20 April 2009, Tim Uckun wrote: > > http://github.com/aeden/rails_sql_views/tree/master > > > > and my heavily hacked version > > > > http://github.com/mschuerig/rails_sql_views/tree/master > > > > My version works with Rails 2.3.2, loads only the adapters that are > > really needed, and adds ActiveRecord::View as an abstract > > superclass for views that are mostly based on another model. > > AR::View can clone association definitions from the model to the > > view, although I haven't implemented all kinds yet. The existing > > functionality works on PostgreSQL, regarding the others, I'm not > > sure right now. > > Michael I have downloaded your code and it does work a lot better. > > Although it fixed the original problem now it presents another > problem Either the rails framework or the postgres adapter attempts > to change the triggers in the "table" using ALTER TABLE which causes > an error.
The only code I can see that affects triggers is in the original PostgreSQLAdapter#disable_referential_integrity method. It disables triggers during a block and re-enables them afterwards. As far as I remember, this is used to load fixtures while temporarily suspending the triggers. As fixture files are loaded one by one without regard for foreign keys, the temporarily violated constraints would cause an exception. I don't think the behavior you're seeing is related to views > Do I have to make my models which derive from view inherit from > AR:View? No, that's just for convenience if you like to re-use associations from other models. Michael -- Michael Schuerig mailto:[email protected] http://www.schuerig.de/michael/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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-talk?hl=en -~----------~----~----~----~------~----~------~--~---
