X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 15F30D1B4E9
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Mon, 13 Oct 2003 10:37:07 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 74937-03
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Mon, 13 Oct 2003 07:36:19 -0300 (ADT)
Received: from darmachakra.axelero.hu (fe03.axelero.hu [195.228.240.91])
	by svr1.postgresql.org (Postfix) with ESMTP id 0C607D1B4E1
	for <pgsql-admin@postgresql.org>; Mon, 13 Oct 2003 07:36:16 -0300 (ADT)
Received: from localhost (localhost-02 [127.0.2.1])
	by darmachakra.axelero.hu (8.12.10/8.12.10) with SMTP id h9DAaCKH035064
	for <pgsql-admin@postgresql.org>; Mon, 13 Oct 2003 12:36:12 +0200 (CEST)
Received: from fe03.axelero.hu [127.0.2.1] via SMTP gateway
	by darmachakra.axelero.hu [195.228.240.91]; id A088B65268C
	at Mon, 13 Oct 2003 12:36:11 +0200
Received: from pter (202.1-182-adsl-pool.axelero.hu [81.182.1.202])
	by fe03.axelero.hu (8.12.10/8.12.10) with SMTP id h9DAa94t034923
	for <pgsql-admin@postgresql.org>; Mon, 13 Oct 2003 12:36:10 +0200 (CEST)
Message-ID: <004c01c39175$0f0b3620$2702a8c0@WorkGroup>
From: "=?iso-8859-2?B?U3phYvMgUOl0ZXI=?=" <matyee@westel900.net>
To: <pgsql-admin@postgresql.org>
Subject: Lock!
Date: Mon, 13 Oct 2003 12:30:43 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0049_01C39185.D1F55520"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=HTML_40_50
X-Spam-Level: 
X-Archive-Number: 200310/138
X-Sequence-Number: 10699

This is a multi-part message in MIME format.

------=_NextPart_000_0049_01C39185.D1F55520
Content-Type: text/plain;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

Hi!

I have a lock problem. If i lock a record with SELECT FOR UPDATE, than i tr=
y to lock again, the process just wait until the record free. But i have to=
 send a message to the user like 'The record is locked, try later.'. But i =
can't. How can i do this?

Matyee

------=_NextPart_000_0049_01C39185.D1F55520
Content-Type: text/html;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-2">
<META content=3D"MSHTML 6.00.2715.400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I have a lock problem. If i lock a record =
with=20
SELECT FOR UPDATE, than i try to lock again, the process just wait until th=
e=20
record free. But i have to send a message to the user like 'The record is=
=20
locked, try later.'. But i can't. How can i do this?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Matyee</FONT></DIV></BODY></HTML>

------=_NextPart_000_0049_01C39185.D1F55520--