Re: A bad behavior under autocommit off mode - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A bad behavior under autocommit off mode
Date
Msg-id 10397.1048227003@sss.pgh.pa.us
Whole thread Raw
In response to Re: A bad behavior under autocommit off mode  (Barry Lind <blind@xythos.com>)
List pgsql-hackers
Barry Lind <blind@xythos.com> writes:
> Of these two limitations the first is more significant since users do 
> issue 'commit' statements directly sometimes, whereas users would likely 
> never change the GUC parameter in their SQL.

Well, we could fix either or both of these in the planned protocol
change.  It would be reasonable for the Z message to convey not only
the current transaction state (not in xact/in xact/in failed xact,
I believe are the three interesting states) but also the current
autocommit boolean.  So assuming that visibility of state is not the
determining issue, which way do you actually like?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: [GENERAL] Extracting time from timestamp
Next
From: Bruce Momjian
Date:
Subject: Re: A bad behavior under autocommit off mode