Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f382gY854753
	for <pgsql-sql@postgresql.org>; Sat, 7 Apr 2001 22:42:35 -0400 (EDT)
	(envelope-from pgsql-sql-owner@postgresql.org)
Received: from mail.mobileway.com ([212.155.187.171])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f367o0880095
	for <pgsql-sql@postgresql.org>; Fri, 6 Apr 2001 03:50:00 -0400 (EDT)
	(envelope-from loic.bourgeois@mobileway.com)
Received: (qmail 26993 invoked from network); 6 Apr 2001 07:49:47 -0000
Received: from chablis.local (HELO mobileway.com) (192.168.1.65)
	by mailadmin.local with SMTP; 6 Apr 2001 07:49:47 -0000
Message-ID: <3ACD751A.2030309@mobileway.com>
Date: Fri, 06 Apr 2001 09:49:46 +0200
From: =?ISO-8859-1?Q?Lo=EFc?= Bourgeois <loic.bourgeois@mobileway.com>
Organization: MobileWay
User-Agent: Mozilla/5.0 (X11; U; Linux 2.2.12-32 i686; en-US;
	m18) Gecko/20010131 Netscape6/6.01
X-Accept-Language: en, fr
MIME-Version: 1.0
To: rmello@fslc.usu.edu
CC: pgsql-sql <pgsql-sql@postgresql.org>
Subject: help
References: <Pine.LNX.4.30.0104052139300.1084-100000@peter.localdomain>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200104/109
X-Sequence-Number: 2451

I read your document about the porting from Oracle to PgSql and I would 
like to know if
you can say to me if there is an equivalent on an the option NOWAIT for 
a request
SELECT ... FOR UPDATE (for Oracle) under PgSql.

This option don't wait a previus unlock and return the information like 
the line can't be lock.

Oracle:
SELECT * FROM toto WHERE id =4 and value = 'hello' FOR UPDATE NOWAIT;

PsSql:
????????????????????????


Tanks a lot....