locking problems

From: "Jonathan Ellis" <jbe(at)familyellis(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: locking problems
Date: 2002-03-16 19:42:57
Message-ID: 001b01c1cd22$c62cee20$0200000a@Jonathan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian von Kietzell 2002-03-16 19:46:12 Re: How to get the name of a table's primary key?
Previous Message Pirtea Calin 2002-03-16 17:09:56 Re: limit /offset