From: | Jie Liang <jie(at)stbernard(dot)com> |
---|---|
To: | 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | libpg.so.2 is missing in 7.3.1 |
Date: | 2002-12-24 03:10:27 |
Message-ID: | E7E213858379814A9AE48CA6754F5ECB1E196A@mail01.stbernard.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, December 23, 2002 11:32 AM
To: a(dot)schmitz(at)cityweb(dot)de
Cc: Simone Tellini; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] locking a table
Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2002-12-24 03:19:51 | libpg.so.2 is missing in 7.3.1 |
Previous Message | Tom Lane | 2002-12-23 22:49:56 | Re: SSL Mode |