Re: nested transaction - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: nested transaction
Date
Msg-id 200408101635.20690.peter_e@gmx.net
Whole thread Raw
In response to Re: nested transaction  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: Thomas Hallgren
Date:
Subject: User Defined Types and SQL2003
Next
From: Tom Lane
Date:
Subject: Re: nested transaction