Re: "Idle in Transaction" revisited. - Mailing list pgsql-jdbc

From Markus Schaber
Subject Re: "Idle in Transaction" revisited.
Date
Msg-id 20040921095922.145bf883@kingfisher.intern.logi-track.com
Whole thread Raw
In response to Re: "Idle in Transaction" revisited.  ("John R Pierce" <pierce@hogranch.com>)
List pgsql-jdbc
Hi,

On Mon, 20 Sep 2004 08:52:29 -0700
"John R Pierce" <pierce@hogranch.com> wrote:

> > Regarding cooperative locking and the fact that after a crash the lock
> > stays: I'm not sure how your application is designed, but in ours after
> > a crash we definitely want it to stay there, so we can manually check
> > the consistency of the data before releasing the lock for further
> > processing. I have bad experience with automatic recovery after crashes.
>
> in this particular case, the lock is to simply indicate there is an active
> 'subscriber' to a messaging 'subject', if the app has exited any which ways,
> by definition that 'subscriber' is no longer active, so yes, we want the
> lock to go away.

Have you ever thought at using LISTEN/NOTIFY for this purpose?

Markus

--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com

pgsql-jdbc by date:

Previous
From: "John R Pierce"
Date:
Subject: Re: "Idle in Transaction" revisited.
Next
From: Markus Schaber
Date:
Subject: Re: raising the default prepareTheshold