Skip site navigation (1) Skip section navigation (2)

Re: More about deadlock

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vit Timchishin" <tivv(at)gtech-ua(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: More about deadlock
Date: 2005-12-06 17:07:57
Message-ID: 4800.1133888877@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
"Vit Timchishin" <tivv(at)gtech-ua(dot)com> writes:
> Can anyone tell me what are this "transaction" locks, when they are taken and why do I have a deadlock 
> here.

Foreign-key update deadlock maybe?  If so, updating to 8.1 is probably
a good solution.  Previous versions took exclusive row locks on
referenced rows, and so you could easily get a deadlock on those row
locks.

			regards, tom lane

In response to

pgsql-jdbc by date

Next:From: Heikki LinnakangasDate: 2005-12-06 20:45:33
Subject: Re: pgsql XA with weblogic 8.1?
Previous:From: Kris JurkaDate: 2005-12-06 15:57:21
Subject: Re: Advise on mapping JTable to large PostgreSQL table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group