Catch of ERROR in PLPGSQL
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
Try a
Begin
... block to watch ...
Exception
When error_code then
... What to do ...
End;
block, it works to me, it is better explained in the manual..
----- Original Message -----
From: "Richard Huxton" <dev@archonet.com>
To: "Shaun Clements" <ShaunC@relyant.co.za>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, March 30, 2005 11:44 AM
Subject: Re: [GENERAL] Catch of ERROR in PLPGSQL
Show quoted text
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)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
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
Import Notes
Reply to msg id not found: 100F78F2B203444BB161BBA7077FF6131CD9BA@srldbexc003.relyant.co.zaReference msg id not found: 100F78F2B203444BB161BBA7077FF6131CD9BA@srldbexc003.relyant.co.za | Resolved by subject fallback
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
Import Notes
Resolved by subject fallback