Re: transactions in plpgsql - Mailing list pgsql-general

From Richard Huxton
Subject Re: transactions in plpgsql
Date
Msg-id 200403191549.27999.dev@archonet.com
Whole thread Raw
In response to transactions in plpgsql  (Martin Marques <martin@bugs.unl.edu.ar>)
Responses Re: transactions in plpgsql
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index selection (and partial index) for BYTEA field
Next
From: Steve Krall
Date:
Subject: Re: pg_dump on older version of postgres eating huge