SELECT FOR UPDATE NOWAIT
От | Mathias Laurent |
---|---|
Тема | SELECT FOR UPDATE NOWAIT |
Дата | |
Msg-id | BAY112-F69231CB85D5278395F9F19A1B0@phx.gbl обсуждение исходный текст |
Ответ на | Table Truncate and Locks ("Chris Hoover" <revoohc@gmail.com>) |
Ответы |
Re: SELECT FOR UPDATE NOWAIT
|
Список | pgsql-admin |
If I do : Session 1: decibel=# begin; BEGIN decibel=# select * from i where i=1 for update nowait; i --- 1 (1 row) decibel=# begin; BEGIN decibel=# select * from i where i=2 for update nowait; i --- 2 (1 row) Session 2 : decibel=# select * from i where i=1 for update nowait; ERROR: could not obtain lock on row in relation "i" decibel=# select * from i where i=3 for update nowait; ERROR: current transaction is aborted, commands ignored until end of transaction block decibel=# ==> Why ? :'( Why i can't do any "Select for update" (current transaction aborted) after having receive a not obtain lock ??? Thank you for your answer ! _________________________________________________________________ Windows Live Messenger sur i-mode : dialoguez avec vos amis depuis votre mobile comme sur PC ! http://mobile.live.fr/messenger/bouygues/
В списке pgsql-admin по дате отправления: