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 DDCDFD1B503
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Mon, 13 Oct 2003 10:39:37 +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 65656-07
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Mon, 13 Oct 2003 07:38:50 -0300 (ADT)
Received: from fe05.axelero.hu (fe05.axelero.hu [195.228.240.93])
	by svr1.postgresql.org (Postfix) with ESMTP id E3503D1B517
	for <pgsql-admin@postgresql.org>; Mon, 13 Oct 2003 07:38:46 -0300 (ADT)
Received: from localhost (localhost-02 [127.0.2.1])
	by fe05.axelero.hu (8.12.10/8.12.10) with SMTP id h9DAcnfN002484
	for <pgsql-admin@postgresql.org>; Mon, 13 Oct 2003 12:38:49 +0200 (CEST)
Received: from fe05.axelero.hu [127.0.2.1] via SMTP gateway
	by fe05 [195.228.240.93]; id A009ACF3201
	at Mon, 13 Oct 2003 12:38:48 +0200
Received: from pter (202.1-182-adsl-pool.axelero.hu [81.182.1.202])
	by fe05.axelero.hu (8.12.10/8.12.10) with SMTP id h9DAcmnP002466
	for <pgsql-admin@postgresql.org>; Mon, 13 Oct 2003 12:38:48 +0200 (CEST)
Message-ID: <006001c39175$6d8771a0$2702a8c0@WorkGroup>
From: "=?iso-8859-2?B?U3phYvMgUOl0ZXI=?=" <matyee@mail.alba.hu>
To: <pgsql-admin@postgresql.org>
Subject: Lock!
Date: Mon, 13 Oct 2003 12:33:22 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_005D_01C39186.30DDE700"
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/130
X-Sequence-Number: 10691

This is a multi-part message in MIME format.

------=_NextPart_000_005D_01C39186.30DDE700
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_005D_01C39186.30DDE700
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_005D_01C39186.30DDE700--