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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html