| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: nested transaction |
| Date: | 2004-08-10 14:35:20 |
| Message-ID: | 200408101635.20690.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2004-08-10 14:58:57 | Re: Listing views |
| Previous Message | Thomas Hallgren | 2004-08-10 14:31:45 | User Defined Types and SQL2003 |