Re: how to check SQLSTATE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: how to check SQLSTATE
Дата
Msg-id 6341.1160170425@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: how to check SQLSTATE  (Hugo <htakada@gmail.com>)
Список pgsql-general
Hugo <htakada@gmail.com> writes:
> Hi again, thanks for your guidance, this is the error I got trying to save
> my fuction:
> ERROR:  unrecognized exception condition "no_data"
> CONTEXT:  compile of PL/pgSQL function "fn_verificar_aportes_socio" near
> line 36

NO_DATA isn't an error condition, only a warning, thus there is no case
in which an exception block would trap it.  So plpgsql doesn't bother to
recognize it.

            regards, tom lane

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

Предыдущее
От: Hugo
Дата:
Сообщение: Re: how to check SQLSTATE
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: exploiting features of pg to obtain polymorphism maintaining ref. integrity