Barry Lind wrote: > Did anything come of this discussion on whether SET initiates a > transaction or not?
SET does not start a multi-statement transaction when autocommit is off. > In summary what is the right way to deal with setting autocommit in clients? I guess just 'set autocommit to on' will do it. -- 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]