Re: transactions in plpgsql

From: Richard Huxton <dev(at)archonet(dot)com>
To: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>, pgsql-general(at)postgresql(dot)org
Subject: Re: transactions in plpgsql
Date: 2004-03-19 15:49:27
Message-ID: 200403191549.27999.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 19 March 2004 13:01, Martin Marques wrote:
> I'm building some functions in plpgsql, and I got to a point where I
> thought: How are transactions used in the function? Is it posible to
> rollback the modifications that were made to the tables at some point in
> the plpgsql function?

You can abort the entire transaction by raising an exception. Nothing more
sophisticated is available at the moment.

There might well be nested transactions in 7.5

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Krall 2004-03-19 15:51:14 Re: pg_dump on older version of postgres eating huge
Previous Message Tom Lane 2004-03-19 15:40:43 Re: Index selection (and partial index) for BYTEA field