Re: please help - Mailing list pgsql-sql

From Loïc Bourgeois
Subject Re: please help
Date
Msg-id 3ACD6E0B.4040207@mobileway.com
Whole thread Raw
In response to Re: please help  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: please help
List pgsql-sql
Yes but the option NOWAIT say to the instruction SELECT ... FOR UPDATE to not wait the unlock but to return the
informationthe lines can't be lock.<br /> (Must retry late).<br /><br /><br /> Peter Eisentraut wrote:<br /><blockquote
cite="mid:Pine.LNX.4.30.0104052139300.1084-100000@peter.localdomain"type="cite"><pre wrap="">Loïc Bourgeois writes:<br
/><br/></pre><blockquote type="cite"><pre wrap="">What is the equivalent of the oracle request: SELECT ... FOR
UPDATE<br/>NOWAIT, under PostGreSQL<br /></pre></blockquote><pre wrap=""><br />I don't know Oracle, but there doesn't
seemto be such a command in<br />PostgreSQL.  If the table is already locked, the SELECT FOR UPDATE has to<br
/>wait.<br/><br /></pre></blockquote><br /> 

pgsql-sql by date:

Previous
From: "guard"
Date:
Subject: get all online user?
Next
From: "Richard Huxton"
Date:
Subject: Re: Index on View ?