Re: commit/rollback in postgre 8.2

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: IPS <sethi(at)nic(dot)in>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: commit/rollback in postgre 8.2
Date: 2009-03-09 11:14:57
Message-ID: 2f4958ff0903090414x522dcd03reb170d74709482b8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Mar 9, 2009 at 8:25 AM, IPS <sethi(at)nic(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-03-09 11:24:25 Re: Performance of subselects
Previous Message Raymond O'Donnell 2009-03-09 11:14:38 Re: commit/rollback in postgre 8.2