Tom Lane wrote: > Dennis Bjorklund <[EMAIL PROTECTED]> writes: >> Could we make BEGIN fail when we already are in a transaction? > > We could, but it'd probably break about as many apps as it fixed.
I'd say that a program that issues BEGIN inside a transaction is already broken, if only by design. I think that the benefit of forced consistency in your transaction handling and standard compliance outweighs the disadvantage of breaking compatibility. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend