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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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