Re: nested transaction

Am Dienstag, 10. August 2004 15:17 schrieb Csaba Nagy:
> > ... but, how can pA detect that there is an open transaction?
>
> If I'm not mistaken, there alwasy must be a transaction in process, even
> if it is an implicit one, so you can alwys count on a transaction being
> opened.

Correct.

The only variation is that the top-level query processor will start a
transaction implicitly and commit it after the statement if you don't start
one explicitly.  But functions are always in some transaction, and need not
care whether it was explicit or not.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/