Title: RE: [GENERAL] Catch of ERROR in PLPGSQL
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
Hi
All
Does
anyone know if Postgres supports Catching of errors, from an EXECUTE, for
Procedural Language Postgres.
Thanks in advance
Kind Regards,Shaun
Clements
Shaun Clements wrote:
Hi All
Does anyone know if Postgres supports Catching of errors, from an EXECUTE,
for Procedural Language Postgres.
In version 8, yes. See the manuals (35.7.5. Trapping Errors) for details.
--
Richard Huxton
Archonet Ltd
---(end of
@postgresql.org
Sent: Wednesday, March 30, 2005 11:44 AM
Subject: Re: [GENERAL] Catch of ERROR in PLPGSQL
Shaun Clements wrote:
Hi All
Does anyone know if Postgres supports Catching of errors, from an
EXECUTE,
for Procedural Language Postgres.
In version 8, yes. See the manuals (35.7.5. Trapping Errors
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