Re: trap for any exception

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: trap for any exception
Дата
Msg-id 20071115103448.S32121@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Re: trap for any exception  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
Ответы Re: trap for any exception
Список pgsql-sql
On Thu, 15 Nov 2007, Sabin Coanda wrote:

> >
> > I read 37.7.5. Trapping Errors, but the syntax requires to write
> > explicitly the exception condition, and not a generic one.
> >
> > Is it possible to build a generic trap or do you know a workaround for
> > that ?
> >
> Sorry, I found the OTHERS condition that trap any error.
>
> But the question still remains to find how could I interpret it and found
> the error code and message ?

I think you'll want to look at SQLSTATE and SQLERRM inside the exception
handler.


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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Is there anything special about pg_dump's compression?
Следующее
От: "Daniel Caune"
Дата:
Сообщение: Erlang & PostgreSQL native driver