[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] locking a table
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2002-12-23 19:31:47
[Download RAW message or body]

Andreas Schmitz <a.schmitz@cityweb.de> 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
[prev in list] [next in list] [prev in thread] [next in thread]