Postgres Pro
Downloads
Home   >   mailing lists

Re: function transaction scope question - Mailing list pgsql-novice

From John DeSoi
Subject Re: function transaction scope question
Date
Msg-id FF8529EE-AF9F-4277-8468-8A1451893576@pgedit.com
Whole thread Raw
In response to function transaction scope question  ("Wright, George" <George.Wright@infimatic.com>)
Responses Re: function transaction scope question  ("Wright, George" <George.Wright@infimatic.com>)
List pgsql-novice
Tree view 
On Jan 14, 2009, at 9:41 AM, Wright, George wrote:

> If a function in PL/pgSQL is wrapped by a transaction, does that
> same single transaction encompass other functions defined elsewhere
> that this function calls?

Yes, they all share the same transaction scope. And PL/pgSQL functions
cannot change the transaction state (i.e. call commit or start a new
transaction).


John DeSoi, Ph.D.

pgsql-novice by date:

Previous
From: "Wright, George"
Date:
Subject: another transaction question
Next
From: Raphael Bauduin
Date:
Subject: order by differences: locale problem?