Horton

Re: Good name for new lock type for VACUUM?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Hiroshi Inoue" <Inoue@tpf.co.jp>
Cc: "Peter Eisentraut" <peter_e@gmx.net>, pgsql-hackers@postgresql.org
Date: 2001-06-23T15:51:42Z
Lists: pgsql-hackers 
"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> Isn't it a better idea to have a separate 'SELF EXCLUSIVE' lock
> which conflicts with only itself ?

*Only* itself?  What would that be useful for?  Not for locking
tables, anyway --- if you don't conflict with AccessExclusiveLock
then it's possible for someone to drop the table while you're
working on it.

			regards, tom lane