Re: [SQL] please help

[Loïc Bourgeois]

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:

[EMAIL PROTECTED]">

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.