locking problems

Поиск
Список
Период
Сортировка
Искать
От
Jonathan Ellis
Тема
locking problems
Дата
Msg-id
001b01c1cd22$c62cee20$0200000a@Jonathan
Список
Дерево обсуждения
Re: locking problems "Jonathan Ellis" <jbe@familyellis.org>
I guess I don't understand locking in PG...  I have a simple statement that
is deadlocking:

update minions set hp = hp_max

there are no triggers or rules on this table.  Even when I try

lock table minions in row share mode

it still deadlocks.  How can a statement like this deadlock?  Doesn't it
acquire all necessary locks atomically?

-Jonathan

В списке pgsql-general по дате отправления
От: Pirtea Calin
Дата:
Сообщение: Re: limit /offset
От: Christian von Kietzell
Дата:
FAQ