Postgres Pro
Downloads
Home   >   mailing lists

Re: More about deadlock - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: More about deadlock
Date
Msg-id 4800.1133888877@sss.pgh.pa.us
Whole thread Raw
In response to More about deadlock  ("Vit Timchishin" <tivv@gtech-ua.com>)
List pgsql-jdbc
Tree view 
"Vit Timchishin" <tivv@gtech-ua.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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Advise on mapping JTable to large PostgreSQL table
Next
From: Heikki Linnakangas
Date:
Subject: Re: pgsql XA with weblogic 8.1?