Re: Equivalent function not found for ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE().

On 3/27/2017 3:59 AM, MAJUMDER, SAYAN wrote:
>
> I am new to postgresql and presently we are migrating from sql server
> to postgresql.
>
> We have certain functions in sql server such as
> ERROR_PROCEDURE(),ERROR_LINE(),ERROR_MESSAGE(). I am unable to find
> any equivalent
>
> functions in postgresql. Kindly help me. Thanks in advance. Its urgent.
>

I'm not familiar with those functions in Microsoft SQL Server, however
see the various result functions in
https://www.postgresql.org/docs/current/static/libpq-exec.html such as
PQresultStatus, PQresultErrorMessage, PQresultErrorField, etc, to get
the error results of a query executed via the standard libpq API.

If you are using a different API to access postgres, then you'd need to
look into that API's error return functions.

--
john r pierce, recycling bits in santa cruz