Обсуждение: 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

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

 

 

I need the exact error code so that I can shutdown my application whenever I face  the “no space available” problem.

 

--

Thanks and Regards,

Rupesh

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/15/2014 9:48 AM, Roopeshakumar Narayansa Shalgar (rshalgar) wrote:
> I need the 'integer' errorcode

SQLSTATE Error codes are NOT integers, they are strings.  note there's
stuff in there like 0100C, 01P01, etc.


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

DISCLAIMER:
-----------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and
intended
for the named recipient(s) only. 
It shall not attach any liability on the originator or NEC or its
affiliates. Any views or opinions presented in 
this email are solely those of the author and may not necessarily reflect the
opinions of NEC or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of 
this message without the prior written consent of the author of this e-mail is
strictly prohibited. If you have 
received this email in error please delete it and notify the sender
immediately. .
-----------------------------------------------------------------------------------------------------------------------

I am facing some issue during postgresql service stop.

Issue:-

[root@localhost postgresql-9.0.18]# runuser -l postgres -c '/usr/pgsql/bin/pg_ctl stop -D '\''/var/lib/pgsql/data'\'' -s -m fast'

/usr/pgsql/bin/pg_ctl: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory
...

-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast

On 10/15/2014 08:21 PM, John R Pierce wrote:
> On 10/15/2014 8:10 PM, Yogesh. Sharma wrote:
>> I am facing some issue during postgresql service stop.
>>
>> Issue:-
>>
>> [root@localhost postgresql-9.0.18]# runuser -l postgres -c
>> '/usr/pgsql/bin/pg_ctl stop -D '\''/var/lib/pgsql/data'\'' -s -m fast'
>>
>> /usr/pgsql/bin/pg_ctl: error while loading shared libraries:
>> libpq.so.5: cannot open shared object file: No such file or directory
>> ...
>
> what OS is this?
>
> how was this postgres server installed?
>
> why did you post this as a reply to an existing thread on a COMPLETELY
> different subject ??
>

Also, might want to try:

ldd /usr/pgsql/bin/pg_ctl

>
>
> --
> john r pierce                                      37N 122W
> somewhere on the middle of the left coast
>


--
Adrian Klaver
adrian.klaver@aklaver.com

Appreciate any replies on this.

/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

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