Re: Kind of error-handler in a pgsql function

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Kind of error-handler in a pgsql function
Дата
Msg-id 1517.994293505@sss.pgh.pa.us
обсуждение
Ответ на Kind of error-handler in a pgsql function  (DI Hasenöhrl <i.hasenoehrl@aon.at>)
Список pgsql-sql
DI Hasenöhrl <i.hasenoehrl@aon.at> writes:
> I want to know the result of an insert or update, because I call these func=
> tions from an Access form and the next steps of the program depend on these=
>  results.

See the FOUND variable (if you just want to test zero or not-zero rows
processed) or the SET DIAGNOSTICS statement to get the row count.

There is no way to trap an error inside a plpgsql function, however.
        regards, tom lane


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