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
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
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) for de
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 broadcast)-
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
