Re: calling EXECUTE on any exception

Поиск
Список
Период
Сортировка
От gherzig@fmed.uba.ar
Тема Re: calling EXECUTE on any exception
Дата
Msg-id 2081.157.92.152.3.1122652768.squirrel@www.webmail.fmed.uba.ar
обсуждение исходный текст
Ответ на Re: calling EXECUTE on any exception  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-sql
Oh...to bad...Thank you Michael!
Did someone know if it can be acomplished in pypgsql?

Thanks againg falks.
Gerardo
> On Fri, Jul 29, 2005 at 10:36:52AM -0300, gherzig@fmed.uba.ar wrote:
>> EXCEPTION
>>   WHEN OTHER THEN
>>     EXECUTE exception_handler(Exception_code)
>>
>> how do i get that error_code (or code_name, whatever i can get)
>> generated in the something() function to be proccesed by the
>> exception_handler() function?
>
> I don't think you can do this in released versions of PostgreSQL.
> In 8.1 you'll be able to use SQLSTATE to get the error code and
> SQLERRM to get the error message.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
>




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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Why are these queries so different in time?
Следующее
От: Jeff Boes
Дата:
Сообщение: CREATE TABLE AS SELECT