Received: from mail.mobileway.com ([212.155.187.171]) by postgresql.org (8.11.3/8.11.1) with SMTP id f367Ju875896 for ; Fri, 6 Apr 2001 03:20:02 -0400 (EDT) (envelope-from loic.bourgeois@mobileway.com) Received: (qmail 20876 invoked from network); 6 Apr 2001 07:19:40 -0000 Received: from chablis.local (HELO mobileway.com) (192.168.1.65) by mailadmin.local with SMTP; 6 Apr 2001 07:19:40 -0000 Message-ID: <3ACD6E0B.4040207@mobileway.com> Date: Fri, 06 Apr 2001 09:19:39 +0200 From: =?ISO-8859-1?Q?Lo=EFc?= Bourgeois 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: Peter Eisentraut CC: pgsql-sql Subject: Re: please help References: Content-Type: multipart/alternative; boundary="------------000505090607090705010806" X-Archive-Number: 200104/93 X-Sequence-Number: 2433 --------------000505090607090705010806 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Yes but the option NOWAIT say to the instruction SELECT ... FOR UPDATE to not wait the unlock but to return the information the lines can't be lock. (Must retry late). Peter Eisentraut wrote: > Loïc Bourgeois writes: > >> What is the equivalent of the oracle request: SELECT ... FOR UPDATE >> NOWAIT, under PostGreSQL > > > I don't know Oracle, but there doesn't seem to be such a command in > PostgreSQL. If the table is already locked, the SELECT FOR UPDATE has to > wait. > --------------000505090607090705010806 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Yes but the option NOWAIT say to the instruction SELECT ... FOR UPDATE to not wait the unlock but to return the information the lines can't be lock.
(Must retry late).


Peter Eisentraut wrote:
Loïc Bourgeois writes:

What is the equivalent of the oracle request: SELECT ... FOR UPDATE
NOWAIT, under PostGreSQL

I don't know Oracle, but there doesn't seem to be such a command in
PostgreSQL. If the table is already locked, the SELECT FOR UPDATE has to
wait.


--------------000505090607090705010806--