Re: [INTERFACES] Roadmap for FE/BE protocol redesign

Peter Eisentraut wrote:
> Tom Lane writes:
> 
> > * Backend's ReadyForQuery message (Z message) should carry an indication
> > of current transaction status (idle/in transaction/in aborted transaction)
> > so that frontend need not guess at state.  Perhaps also indicate
> > autocommit status.
> 
> If we do this, could we get rid of the messy autocommit GUC option and
> handle autocommit in the client?  Before sending a command, the client
> could check the transaction status and automatically choose to start a new
> transaction.  That way we could get rid of the current mess that every
> client needs to send a SET autocommit command before it can safely do
> anything.

What if folks want all their connections autocommit off.  Seems it is
best in the server.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610) 359-1001 +  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073