We use 7.1.3,
an upgrade is due next thing in the morning :-)
thanks.
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Daniel Åkerud" <zilch@home.se>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, March 07, 2002 9:29 PM
Subject: Re: [GENERAL] Lock up, but not deadlock?
> =?iso-8859-1?Q?Daniel_=C5kerud?= <zilch@home.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
>
