Postgres Pro
Downloads
Home   >   mailing lists

transaction in function - Mailing list pgsql-sql

From Marian POPESCU
Subject transaction in function
Date
Msg-id el431c$9mt$1@sea.gmane.org
Whole thread Raw
Responses Re: transaction in function
Re: transaction in function
Re: transaction in function
List pgsql-sql
Tree view 
Hi,

I want to write a function that updates several tables; if there is an
exception while updating, it should rollback the transaction and raise an
error.

How can this be done in pgPLSQL in PostgreSQL 8.1 ?

Thank you for helping me out on this one !

pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: null values in non-nullable column
Next
From: "A. Kretschmer"
Date:
Subject: Re: transaction in function