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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])