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
