Re: Kind of error-handler in a pgsql function - Mailing list pgsql-sql

From Tom Lane
Subject Re: Kind of error-handler in a pgsql function
Date
Msg-id 1517.994293505@sss.pgh.pa.us
Whole thread Raw
In response to Kind of error-handler in a pgsql function  (DI Hasenöhrl <i.hasenoehrl@aon.at>)
List 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 by date:

Previous
From: DI Hasenöhrl
Date:
Subject: Kind of error-handler in a pgsql function
Next
From: Alex Pilosov
Date:
Subject: Re: Kind of error-handler in a pgsql function