Re: Catch of ERROR in PLPGSQL

Поиск
Список
Период
Сортировка
От Shaun Clements
Тема Re: Catch of ERROR in PLPGSQL
Дата
Msg-id 100F78F2B203444BB161BBA7077FF6131CD9BF@srldbexc003.relyant.co.za
обсуждение исходный текст
Ответ на Catch of ERROR in PLPGSQL  (Shaun Clements <ShaunC@relyant.co.za>)
Список 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@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

В списке pgsql-general по дате отправления:

Предыдущее
От: "GIROIRE Nicolas (COFRAMI)"
Дата:
Сообщение: Re: plperl doesn't release memory
Следующее
От: Harald Fuchs
Дата:
Сообщение: Re: plperl doesn't release memory