Re: pgsql functions and transactions? - Mailing list pgsql-novice

From Josh Berkus
Subject Re: pgsql functions and transactions?
Date
Msg-id 200408271228.33681.josh@agliodbs.com
Whole thread Raw
In response to Re: pgsql functions and transactions?  (Betsy Barker <betsy.barker@supportservicesinc.com>)
List 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

pgsql-novice by date:

Previous
From: Betsy Barker
Date:
Subject: Re: pgsql functions and transactions?
Next
From: Tom Lane
Date:
Subject: Re: pgsql functions and transactions?