Re: disallow LOCK on a view - the Tom Lane remix

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(at)nortelnetworks(dot)com
ESN 451-9008 (302)454-9008