Re: Dedect unknown database in 08.01.0100 and Postgres 8.1

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Tom Lane
> Sent: 08 November 2005 19:02
> To: Andrus
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Dedect unknown database in 08.01.0100 and
> Postgres 8.1
>
> "Andrus" <eetasoft@online.ee> writes:
> > Earlier odbc driver with Postgres 8.0 returns special error
> text in this
> > case:
> > FATAL:  database "foo" does not exist
>
> > New ODBC driver with Postgres 8.1 returns the same error in
> all cases:
> > Could not connect to the server
>
> This seems like a serious regression in behavior.  Why isn't
> the driver
> returning the error string provided by libpq?

Some left-over debugging code from the port to libpq by the looks of it.
Fix committed, though interestingly in my testing I *almost* always got
the following message from libpq rather than the expected username or db
doesn't exist message:

could not receive data from server: The system cannot find the path
specified.
 (0x00000003/3)

Also, am I right in thinking there is no way to get an sqlstate code
from a libpq connection, or did I miss something in the docs? I realise
of course that you can get one from a result object.

Regards, Dave