Re: transactions in plpgsql

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