Re: Catch of ERROR in PLPGSQL

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(at)archonet(dot)com>
To: "Shaun Clements" <ShaunC(at)relyant(dot)co(dot)za>
Cc: <pgsql-general(at)postgresql(dot)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) 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(at)postgresql(dot)org)
>