Exception handling in plperl

From: "Jasbinder Singh Bali" <jsbali(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Exception handling in plperl
Date: 2007-03-14 03:23:03
Message-ID: a47902760703132023r709ce431ve10a359b34eb6ce@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a stored procedure written in plperl.
This procedure has series of inserts at various levels. A few inserts on
certain tables invoke triggers
that launch tools outside the domain of the database.

How can I make everything as one single transaction and simply roll back
everything whenever an exception occurs.

Thanks,
Jas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stuart Cooper 2007-03-14 04:19:24 Re: Multiple atributes with -P switch to psql
Previous Message Harvey, Allan AC 2007-03-14 02:59:30 Multiple atributes with -P switch to psql