Re: commit/rollback in postgre 8.2 - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: commit/rollback in postgre 8.2
Date
Msg-id 2f4958ff0903090414x522dcd03reb170d74709482b8@mail.gmail.com
Whole thread Raw
In response to commit/rollback in postgre 8.2  (IPS <sethi@nic.in>)
List pgsql-general
On Mon, Mar 9, 2009 at 8:25 AM, IPS <sethi@nic.in> wrote:
>  Is it possible to use begin, commit and rollback commands within a
> transaction block in  SQL function in postgre ver 8.2

if you want to break plpgsql function, use exceptions. That will cause
transaction (which in it self is the whole procedure) to be rolled
back.

--
GJ

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: commit/rollback in postgre 8.2
Next
From: Christian Schröder
Date:
Subject: Re: Performance of subselects