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