Re: Help with SET TRANSACTION in a function

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: OtisUsenet <otis_usenet(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help with SET TRANSACTION in a function
Date: 2002-03-04 20:45:57
Message-ID: 20020304124237.R80169-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 28 Feb 2002, OtisUsenet wrote:

> Hello,
>
> I was wondering if anyone here can help. I could not get any help on
> pgsql-sql nor pgsql-general mailing lists.
>
> I'm having trouble getting functions with SET TRANSACTION ISOLATION
> ... to parse.

Without nested transactions, you're not going to have any luck I think.
First of all the extra begin/end in the function are not allowed and
IIRC, set transaction isolation level must be the first statement of the
transaction which it won't be since the enclosing transaction will have
started the select simple_fun().

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mdb 2002-03-04 20:48:58 Temp Tables
Previous Message Fran Fabrizio 2002-03-04 20:39:51 Re: storing intermediate results in recursive plpgsql functions