X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id DBE75310E8B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  2 Jul 2003 03:17:38 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 48094-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  2 Jul 2003 00:17:28 -0300 (ADT)
Received: from imsm031.netvigator.com (imsm031.netvigator.com
 [218.102.48.149])
	by svr1.postgresql.org (Postfix) with SMTP id CFDAA310D85
	for <pgsql-sql@postgresql.org>; Wed,  2 Jul 2003 00:17:26 -0300 (ADT)
Received: (qmail 27203 invoked from network); 2 Jul 2003 03:17:23 -0000
Received: from aworklan032048.netvigator.com (HELO pc32) (218.103.38.48)
	by imsm031.netvigator.com with SMTP; 2 Jul 2003 03:17:23 -0000
Message-ID: <000801c34048$748fccf0$8401a8c0@equity.com>
From: "Jonathan Man" <jman@equityunderwriters.com.hk>
To: <pgsql-sql@postgresql.org>
Subject: Timeout for lock table
Date: Wed, 2 Jul 2003 11:17:22 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01C3408B.8218A1B0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Archive-Number: 200307/32
X-Sequence-Number: 14146

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C3408B.8218A1B0
Content-Type: text/plain;
	charset="big5"
Content-Transfer-Encoding: quoted-printable

Dear All,

I begin a transaction. I then execute a SQL command "SELECT FOR UPDATE" to =
lock some records on the first session. Besides, I also lock some rows usin=
g the same method on the second session. Is it possible to return an error =
message to indicate that some records were locked by another user when I lo=
ck it on the second session?

Please help me, THX!!


JMAN


------=_NextPart_000_0005_01C3408B.8218A1B0
Content-Type: text/html;
	charset="big5"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dbig5" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Dear All,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I begin a transaction. I then&nbsp;execute=
 a SQL=20
command "SELECT FOR UPDATE" to lock some records on the first session. Besi=
des,=20
I also lock some rows using the same method on the second session. Is it=20
possible to return an error message to indicate that some records were lock=
ed by=20
another user when I lock it on the second session?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Please help me, THX!!</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>JMAN</FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0005_01C3408B.8218A1B0--