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 по дате отправления: