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

Re: UPDATE fails on large table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kostis <pgsql(at)pobox(dot)gr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: UPDATE fails on large table
Date: 2001-11-23 16:42:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Kostis <pgsql(at)pobox(dot)gr> writes:
> ERROR:  Deadlock detected.
>         See the lock(l) manual page for a possible cause.

Hard to see how you could be getting that with only one process
accessing the database.  What else is going on?

Also, you've been pretty incomplete about your description of the
table schema.  I am wondering what the index declarations are,
whether there are any foreign key relationships, rules, triggers,

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Raimund JakobsmeyerDate: 2001-11-26 10:49:43
Subject: postgresql-7.2b3+jdbc+DatabaseMetaData
Previous:From: Tom LaneDate: 2001-11-23 16:29:31
Subject: Re: Bug #519: Bug in order by clausule

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