Re: Lock up, but not deadlock?

We use 7.1.3,
an upgrade is due next thing in the morning :-)

thanks.

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Daniel Åkerud" <zilch(at)home(dot)se>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, March 07, 2002 9:29 PM
Subject: Re: [GENERAL] Lock up, but not deadlock?

> =?iso-8859-1?Q?Daniel_=C5kerud?= <zilch(at)home(dot)se> writes:
> > Is there a possibility that there will be a lock in a transaction, but
it i=
> > s not a deadlock?
> > I have N functions (about 20-25) interacting in a system. They are like:
se=
> > tUserOnline(...) setUserOffline(...) setServerOnline(...) and so forth.
We =
> > have found out that there are sometimes deadlocks.
>
> What PG version?
>
> There used to be some bugs in the deadlock detector, but there are no
> known bugs there as of 7.2.
>
> regards, tom lane
>