SELECT FOR UPDATE
| От | jose |
|---|---|
| Тема | SELECT FOR UPDATE |
| Дата | |
| Msg-id | 3B83B1ED.9050406@sferacarta.com обсуждение исходный текст |
| Ответ на | Re: Sort by foreign date column (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
| Ответы |
Re: SELECT FOR UPDATE
|
| Список | pgsql-general |
Hi all, I'm trying SELECT FOR UPDATE but I have a problem with locks. example: I have two users accessing to the same records, say... user1: DELECT * FROM table WHERE field=value FOR UPDATE --------------------------------------------------------------------------- user2: DELECT * FROM table WHERE field=value FOR UPDATE at this point user2 can't do nothing except waiting for user1 unlock recors. My question is: - Is it possible to know in advance if the records of a given query are locked, to prevent to be locked for ever? Thank for any help, Jose Soares
В списке pgsql-general по дате отправления: