Re: [HACKERS] disallow LOCK on a view - the Tom Lane remix - Mailing list pgsql-patches

From Alfred Perlstein
Subject Re: [HACKERS] disallow LOCK on a view - the Tom Lane remix
Date
Msg-id 20000829114659.Z18862@fw.wintelcom.net
Whole thread Raw
In response to disallow LOCK on a view - the Tom Lane remix  (Mark Hollomon <mhh@mindspring.com>)
List pgsql-patches
* Mark Hollomon <mhh@mindspring.com> [000829 11:26] wrote:
> Here is a patch against CVS (without my earlier patch)
> to disallow
>
> LOCK x
>
> if x is a view.
>
> It does not use the SPI interface.

Waitasec, why??  This can be very useful if you want to atomically lock
something that sits "in front" of several other tables that you need to
do something atomically with.

Does it cause corruption if allowed?

thanks,
-Alfred

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Important 7.0.* fix to ensure buffers are released
Next
From: Alfred Perlstein
Date:
Subject: Re: [HACKERS] disallow LOCK on a view - the Tom Lane remix