Re: Lock up, but not deadlock? - Mailing list pgsql-general

=?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