SELECT FOR UPDATE - release lock?

Поиск
Список
Период
Сортировка
От Christian Hofmann
Тема SELECT FOR UPDATE - release lock?
Дата
Msg-id 00e801c66fb6$7b91edd0$7b00a8c0@taschenrechner
обсуждение исходный текст
Ответы Re: SELECT FOR UPDATE - release lock?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-novice
Hello,

for some tables I am using a "select a,b,c from mytable where x='abc' FOR
UPDATE" query to prevent other servers also modify this data while I am
reading the data and decide to modify the data.

Now sometimes I don't want to make an update. Is there a way to release the
lock. Or is the lock released by simply call commit?

The problem is, that we are using collection pooling. So these datasets
(where x='xyz') would be blocked forever.
How would you solve this? What can i do?

Thank you,

Christian



В списке pgsql-novice по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: SQL Order Question
Следующее
От:
Дата:
Сообщение: Re: SQL Order Question