Re: RESET SESSION v3 - Mailing list pgsql-patches

From Neil Conway
Subject Re: RESET SESSION v3
Date
Msg-id 1176361062.6593.14.camel@localhost.localdomain
Whole thread Raw
In response to RESET SESSION v3  ("Marko Kreen" <markokr@gmail.com>)
Responses Re: RESET SESSION v3  ("Marko Kreen" <markokr@gmail.com>)
List pgsql-patches
On Sun, 2007-04-08 at 11:08 +0300, Marko Kreen wrote:
> I think implicit ABORT would annoy various tools that
> partially parse user sql and expect to know what transaction
> state currently is.  For them a new tranaction control statement
> would be nuisance.

That's not the only alternative: we could also either disallow all of
the "ALL" variants in a transaction block, or allow RESET SESSION inside
a transaction block.

I've committed the patch basically as-is: thanks for the patch. I don't
feel strongly about the above, but if there's a consensus, we can change
the behavior later.

-Neil



pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: autovacuum multiworkers, patch 5
Next
From: Heikki Linnakangas
Date:
Subject: Re: [HACKERS] Fix mdsync never-ending loop problem