| From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
|---|---|
| To: | Mark Hollomon <mhh(at)mindspring(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] disallow LOCK on a view - the Tom Lane remix |
| Date: | 2000-08-29 18:46:59 |
| Message-ID: | 20000829114659.Z18862@fw.wintelcom.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
* Mark Hollomon <mhh(at)mindspring(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Hollomon | 2000-08-29 19:16:12 | disallow LOCK on a view - the Tom Lane remix |
| Previous Message | Ross J. Reedstrom | 2000-08-29 17:46:46 | Re: when does CREATE VIEW not create a view? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Hollomon | 2000-08-29 19:16:12 | disallow LOCK on a view - the Tom Lane remix |
| Previous Message | Ross J. Reedstrom | 2000-08-29 17:46:46 | Re: when does CREATE VIEW not create a view? |