Re: ExclusiveLock without a relation in pg_locks

On Thu, Feb 23, 2006 at 11:08:07AM -0500, Carlos Oliva wrote:
> Thank you very much for your answer.  I think that I am seeing those self
> transaction id locks as "ExclusiveLocks"
>
> Would you expect to see an "ExclusiveLock" with a query of type Select (not
> Select Update or Update or Insert)?

Not in general, unless perhaps the select called a function that
acquired such a lock.  The Concurrency Control chapter in the
documentation has a section on lock types and the commands that
acquire them:

http://www.postgresql.org/docs/8.1/interactive/explicit-locking.html

Are you just curious or are you seeing such a situation?

--
Michael Fuhr