Re: locking problems - Mailing list pgsql-general

From Jonathan Ellis
Subject Re: locking problems
Date
Msg-id 015b01c1cfa1$d7e26fb0$4a050a0a@jellispc
Whole thread Raw
In response to locking problems  ("Jonathan Ellis" <jbe@familyellis.org>)
List pgsql-general
> Jonathan's problem evidently is a genuine deadlock, and as such
> twiddling deadlock_timeout isn't gonna help him.  But he hasn't given
> enough detail about what he's doing to let anyone understand why he's
> hitting a deadlock.

uhm.  I don't know what to tell you besides what I already have, which is, a
simple "update mytable set field1=field2" is deadlocking, even when I lock
the table first.  to my simple mind this sounds like a bug; if it's not,
what am I misunderstanding?

-Jonathan


pgsql-general by date:

Previous
From: "Jonathan Ellis"
Date:
Subject: Re: locking problems
Next
From: Stephan Szabo
Date:
Subject: Re: Yet another indexing issue.