Re: please help

From: Loïc Bourgeois <loic(dot)bourgeois(at)mobileway(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: please help
Date: 2001-04-06 07:19:39
Message-ID: 3ACD6E0B.4040207@mobileway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Loïc Bourgeois 2001-04-06 07:49:46 help
Previous Message guard 2001-04-06 02:52:30 get all online user?