| From: | Shaun Clements <ShaunC(at)relyant(dot)co(dot)za> |
|---|---|
| To: | 'Richard Huxton' <dev(at)archonet(dot)com>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Catch of ERROR in PLPGSQL |
| Date: | 2005-03-31 09:05:05 |
| Message-ID: | 100F78F2B203444BB161BBA7077FF6131CD9BF@srldbexc003.relyant.co.za |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)archonet(dot)com]
Sent: 31 March 2005 09:10 AM
To: Shaun Clements; pgsql-general(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Harald Fuchs | 2005-03-31 09:54:08 | Re: plperl doesn't release memory |
| Previous Message | Martijn van Oosterhout | 2005-03-31 08:25:30 | Re: plperl doesn't release memory |