transaction in function

From: Marian POPESCU <softexpert(at)libertysurf(dot)fr>
To: pgsql-sql(at)postgresql(dot)org
Subject: transaction in function
Date: 2006-12-05 15:25:31
Message-ID: el431c$9mt$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 !

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2006-12-05 16:23:19 Re: transaction in function
Previous Message Michael Glaesemann 2006-12-05 04:05:22 Re: null values in non-nullable column