libpg.so.2 is missing in 7.3.1

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?

http://archives.postgresql.org

Browse pgsql-admin by date

  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