Thomas Lockhart wrote: > ... > > I think if we special case autocommit we have to force it to start a > > transaction. > > Be aware that "SET AUTOCOMMIT" does *not* start a transaction in other > systems (at least in Ingres, where I first ran into the feature). > > This case is illustrating a general issue with trying to bracket > variables within transactions; the "special case" is that if a > transaction is not open then the change should be global across > transactions. > > Any counterexamples would argue for two separate behaviors, not for > shoehorning everything into one, uh, shoe.
I am fine with special casing autocommit. Is that what you are suggesting? -- 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 4: Don't 'kill -9' the postmaster
