Ben Trewern wrote:
All,
I've just been trying to setup some updateable views using standard views
and associated rules. Is there any possibility of when you open a view in
the SQL editor the SQL for the associated rules also show up. It would seem
to make sense. When a view is dropped the rules are silently dropped also
so if you're not careful you loose them. (Happened once! :-()
Thanks for your attention.
Hi Ben,
I intend to look at handling updateable views, but for the moment want
to hold off until we see some real code (hopefully) in 8.3-dev. I'm not
keen to have to do the work twice if PostgreSQL's view implementation
ends up changing drastically from what we currently have.
Regards, Dave.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster