Re: Catch of ERROR in PLPGSQL - Mailing list pgsql-general

From Shaun Clements
Subject Re: Catch of ERROR in PLPGSQL
Date
Msg-id 100F78F2B203444BB161BBA7077FF6131CD9BF@srldbexc003.relyant.co.za
Whole thread Raw
In response to Catch of ERROR in PLPGSQL  (Shaun Clements <ShaunC@relyant.co.za>)
List pgsql-general

Begin
Exception
of a basic Function.
is provided for.
What I was thinking then, it to create separate functions for the INSERT and UPDATE
which take parameters, for the table, column, and values.
Which I can then make use of the EXCEPTION.

Kind Regards,
Shaun Clements

-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.com]
Sent: 31 March 2005 09:10 AM
To: Shaun Clements; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Catch of ERROR in PLPGSQL

Shaun Clements wrote:
> Thanks for your response.
> I unfortunately have to use 7.3.
> Will try the Exception wrap. It does appear in the manual.

No it doesn't. Version 7.3 doesn't have any programmatic exception
handling. Perhaps you are reading the wrong version of the manuals?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "GIROIRE Nicolas (COFRAMI)"
Date:
Subject: Re: plperl doesn't release memory
Next
From: Harald Fuchs
Date:
Subject: Re: plperl doesn't release memory