Tom Lane wrote:
>
> BTW, this seems to be a counterexample for my prior suggestion that
> pg_class should have a "relviewrule" OID column. If it did, you'd
> have to update that field when doing something like the above.
> Pain-in-the-neck factor looms large...
>
I was already considering the possiblity of a 'ALTER VIEW' command that
would effectively allow you do that.
CREATE VIEW bar as select * from foo1;
ALTER VIEW bar as select * from foo2;
It would update the "relviewrule" field.
--
Mark Hollomon
mhh@nortelnetworks.com
ESN 451-9008 (302)454-9008