Обсуждение: Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage
"Roopeshakumar Narayansa Shalgar (rshalgar)" <rshalgar@cisco.com> writes: > HI, > PQerrorMessage pirints the error message like (no space available,etc). Does postgres provide > any API which gives the error code listed in the below appendix; > http://www.postgresql.org/docs/9.1/static/errcodes-appendix.html Use PQresultErrorField(..., PG_DIAG_SQLSTATE) http://www.postgresql.org/docs/9.3/static/libpq-exec.html#LIBPQ-EXEC-MAIN regards, tom lane
Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage
От
"Roopeshakumar Narayansa Shalgar (rshalgar)"
Дата:
Thanks Tom, But that's not what I am looking for. I need the 'integer' errorcode equivalent of " errormsg string" returned by PQerrorMessage. /rK -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Wednesday, October 15, 2014 10:07 PM To: Roopeshakumar Narayansa Shalgar (rshalgar) Cc: pgsql-sql@postgresql.org; pgsql-general@postgresql.org Subject: Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage "Roopeshakumar Narayansa Shalgar (rshalgar)" <rshalgar@cisco.com> writes: > HI, > PQerrorMessage pirints the error message like (no space available,etc). Does postgres provide > any API which gives the error code listed in the below appendix; > http://www.postgresql.org/docs/9.1/static/errcodes-appendix.html Use PQresultErrorField(..., PG_DIAG_SQLSTATE) http://www.postgresql.org/docs/9.3/static/libpq-exec.html#LIBPQ-EXEC-MAIN regards, tom lane
On 10/16/2014 12:09 AM, Roopeshakumar Narayansa Shalgar (rshalgar) wrote: > Appreciate any replies on this. It has been answered, see Tom Lanes link below. In particular you are looking for PG_DIAG_SQLSTATE. > > /rK > > -----Original Message----- > From: Roopeshakumar Narayansa Shalgar (rshalgar) > Sent: Wednesday, October 15, 2014 10:19 PM > To: 'Tom Lane'; pgsql-sql@postgresql.org; pgsql-general@postgresql.org > Subject: RE: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage > > Thanks Tom, > > But that's not what I am looking for. > > I need the 'integer' errorcode equivalent of " errormsg string" returned by PQerrorMessage. > > /rK > > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: Wednesday, October 15, 2014 10:07 PM > To: Roopeshakumar Narayansa Shalgar (rshalgar) > Cc: pgsql-sql@postgresql.org; pgsql-general@postgresql.org > Subject: Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage > > "Roopeshakumar Narayansa Shalgar (rshalgar)" <rshalgar@cisco.com> writes: >> HI, >> PQerrorMessage pirints the error message like (no space available,etc). Does postgres provide >> any API which gives the error code listed in the below appendix; > >> http://www.postgresql.org/docs/9.1/static/errcodes-appendix.html > > Use PQresultErrorField(..., PG_DIAG_SQLSTATE) > > http://www.postgresql.org/docs/9.3/static/libpq-exec.html#LIBPQ-EXEC-MAIN > > regards, tom lane > > -- Adrian Klaver adrian.klaver@aklaver.com