Re: please help
От | Loïc Bourgeois |
---|---|
Тема | Re: please help |
Дата | |
Msg-id | 3ACD6E0B.4040207@mobileway.com обсуждение исходный текст |
Ответ на | Re: please help (Peter Eisentraut <peter_e@gmx.net>) |
Ответы |
Re: please help
|
Список | 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 по дате отправления: