Home > mailing lists

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

From	John DeSoi
Subject	Re: function transaction scope question
Date	January 15, 2009 06:37:15
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
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:

From: "Wright, George"
Date: 14 January 2009, 18:56:41
Subject: another transaction question

From: Raphael Bauduin
Date: 15 January 2009, 10:29:36
Subject: order by differences: locale problem?

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

Previous

Next