Bruce Momjian wrote:
>>most useful approach. The analogy to SET hadn't occurred to me.
>
>
> Yea, the SET behavior appeared pretty queer to me, but now that I have
> used it, I am getting used to it.
>
So does that mean:
set autocommit to off; begin; insert into foo values('a'); insert into bar values('b'); truncate table foobar;
will automatically commit the two inserts?
Joe