transactions -- avoid hanging due to locks

Поиск
Список
Период
Сортировка
От mixo
Тема transactions -- avoid hanging due to locks
Дата
Msg-id 3EA8E0E0.6060602@beth.uniforum.org.za
обсуждение исходный текст
Ответы Re: transactions -- avoid hanging due to locks  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Is it possible to make an update query return immediately with
the result that current update query cannot be performed due to
a transaction that  has locked the entry or entries? For instance,
suppose there is a transction in progress the has locked the row
the with id1, then any other query that the tries to update the
row it would fail, instead of waiting for the transaction
commit (end).





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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Returning with a userd defined type (PL/pgSQL)
Следующее
От: "jose antonio leo"
Дата:
Сообщение: Help with a query