Re: pgsql functions and transactions?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Betsy Barker <betsy(dot)barker(at)supportservicesinc(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pgsql functions and transactions?
Date: 2004-08-27 19:28:33
Message-ID: 200408271228.33681.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Betsy,

> Can I ask you what you mean by "are you touching a whole lot of different
> tables in one transaction? " Do I have a transaction? Where is it? Does it
> start when I am at the top of the first function and end when I complete
> that main function? Or do I have separate transactions at the beginning and
> end of each subfunction?

The whole thing ... the entire function chain ... is one big transaction.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-08-27 19:34:13 Re: pgsql functions and transactions?
Previous Message Bruno Wolff III 2004-08-27 19:16:22 Re: Foreign keys