Andreas Schmitz <[EMAIL PROTECTED]> writes: > Maybe I have a different idea of exclusive.
Locks are held till the end of the current transaction ... so you need something like begin; lock ...; do whatever ...; commit; to do anything useful with an explicit lock. A standalone LOCK command will drop the lock as soon as it's acquired. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org