Re: libpq: How to get the error code after a failed PGconn connection - Mailing list pgsql-hackers

From Tom Lane
Subject Re: libpq: How to get the error code after a failed PGconn connection
Date
Msg-id 28833.1398809892@sss.pgh.pa.us
Whole thread Raw
In response to libpq: How to get the error code after a failed PGconn connection  (Hello World <worldanizer@gmail.com>)
List pgsql-hackers
Hello World <worldanizer@gmail.com> writes:
> Given the following code.
> PGconn* const conn=PQconnectdbParams(keywords, values, false);
> if(! conn || PQstatus(conn)!=CONNECTION_OK){ /* error code? */ }

> - In case of a failed connection is there a way to get the error code to be
> able to distinguish between a (e.g.) bad password and the server being down.

1. This question is not really material for the -hackers list.

2. No, I'm afraid.  libpq does not currently assign SQLSTATE error codes
to errors it detects internally, so even if there were an API for this,
it would fail to return anything in a lot of cases.  Fixing that is on
the TODO list, but it's been there for a long time, so don't hold your
breath ...
        regards, tom lane



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pg_dump --pretty-print-views
Next
From: Tom Lane
Date:
Subject: Re: Considerer Harmful Considered Harmful