Re: A question about functions and transactions. - Mailing list pgsql-novice

From Tom Lane
Subject Re: A question about functions and transactions.
Date
Msg-id 26571.1014691917@sss.pgh.pa.us
Whole thread Raw
In response to A question about functions and transactions.  (Dave Peticolas <dave@krondo.com>)
List pgsql-novice
Dave Peticolas <dave@krondo.com> writes:
> Do stored functions (say, in plpgsql) run in their own transaction?

Nope, they are part of the transaction of the query that invokes them.

Postgres doesn't have nested transactions (not yet, anyway).

            regards, tom lane

pgsql-novice by date:

Previous
From: Dave Peticolas
Date:
Subject: A question about functions and transactions.
Next
From: "Josh Berkus"
Date:
Subject: Can't use PGAccess with KDE 2.2