On Wed, 4 Dec 2002 pgsql-bugs@postgresql.org wrote:
> Alexander Kirpa (postgres@bilteks.com) reports a bug with a severity of 1
> The lower the number the more severe it is.
>
> Short Description
> Deadlock during insert w/o autocommit
>
> Long Description
> Deadlock during insert w/o autocommit in 2 tables with check to
> table3. Environment Postgres 7.2.3(cygwin) & 7.3(freebsd) Perl.
> Testing local (freebsd) and over lan in both direction (freebsd
> client, w2k server and w2k client, freeBSD server). Result - freeze
> client, server don't make (psql) some operation related used tables.
Are you sure you're getting deadlock and not simply the second session
waiting on the first? The latter is guaranteed to happen in current
versions with a structure like the one you have as the second is waiting
for the first to complete. If you want details on why and what's being
done, there'll be a bunch of messages in the archives about the subject.