Re: Access to transaction status

From: "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>
To: Christian Plattner <postgresql(at)sioux(dot)ch>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Access to transaction status
Date: 2003-06-20 08:04:18
Message-ID: 20030620080418.GB20167@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jun 20, 2003 at 09:35:08AM +0200, Christian Plattner wrote:
>
> I see a race condition in this approach: if you reconnect too fast, and the
> backend which actually should commit is still in progress (assume it takes a
> while to commit for whatever reasons) you get the impression that it did not
> commit - and a short time later the backend will commit... (before noticing
> that the client connection was lost).

Good point. So far I assumed that a broken connection would take a while
to repair. OTOH by the time TCP gives up due to a bad network connection,
wouldn't the server reach the same conclusion?

Jeroen

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christian Plattner 2003-06-20 08:20:14 Re: Access to transaction status
Previous Message Ivar 2003-06-20 07:59:34 Re: Is there any way to make post to newsgroups faster ?