Re: Transactions inside plpgsql?

Basically, answer is: you can't do it, no matter how you slice it, for a
simple reason: postgres doesn't support nested transactions [yet?].

On Sun, 28 Jan 2001, Alan Turner wrote:

> Hi
>
> I've been searching the web/mailing lists/web boards for the answer to a
> question I have regarding postgresql. So far, I haven't found a conclusive
> answer. My apologies in advance if this is a FAQ/stupid question.
>
> My problem is that I would like to write a plpgsql procedure that starts and
> ends transactions. This requires use of the postgres keyword 'begin'. From
> what I can see, the plpgsql parser is wrongly interpreting the begin as a
> plpgsql keyword.
>
> I considered the idea of creating an 'sql' language stored procedure, called
> say begin_work() which in turn makes the 'begin work' statement. While this
> does seem to work, it seems a bit rediculous.
>
> I'm hoping that I've been stupid and missed something obvious :-)
>
> If someone could point me in the direction of the correct documentation,
> I'd be most grateful.
>
> Thanks!
>
> Cheers,
> Alan
>
>
>
>