Re: Transactions within a function - Mailing list pgsql-general

From Alex Pilosov
Subject Re: Transactions within a function
Date
Msg-id Pine.BSO.4.10.10107060946250.7004-100000@spider.pilosoft.com
Whole thread Raw
In response to Transactions within a function  (Daniel Åkerud <zilch@home.se>)
List pgsql-general
On Fri, 6 Jul 2001, [iso-8859-1] Daniel �kerud wrote:

> Do the BEGIN and END in a function also indicate that it is done in a
> transaction? Or can you put another BEGIN TRANSACTION; END
> TRANSACTION; in there?

No. Functions cannot start/stop transactions, as postgresql does not
currently support nested transactions. BEGIN/END are pascalish/adaish
things identical to { and } in C.

-alex


pgsql-general by date:

Previous
From: Morgan Curley
Date:
Subject: Cross database foreign keys
Next
From: Mithun Bhattacharya
Date:
Subject: Another DBD::Pg question