Postgres Pro
Downloads
Home   >   mailing lists

Re: Good name for new lock type for VACUUM? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Good name for new lock type for VACUUM?
Date
Msg-id 7776.993311502@sss.pgh.pa.us
Whole thread Raw
In response to RE: Good name for new lock type for VACUUM?  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses RE: Good name for new lock type for VACUUM?  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-hackers
Tree view 
"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

pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: Good name for new lock type for VACUUM?
Next
From: Alex Pilosov
Date:
Subject: Re: [PATCH] by request: base64 for bytea