Re: A question about functions and transactions.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Peticolas <dave(at)krondo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: A question about functions and transactions.
Date: 2002-02-26 02:51:57
Message-ID: 26571.1014691917@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dave Peticolas <dave(at)krondo(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-02-26 03:25:11 Can't use PGAccess with KDE 2.2
Previous Message Dave Peticolas 2002-02-26 02:34:47 A question about functions and transactions.