Skip site navigation (1) Skip section navigation (2)

Re: Dedect unknown database in 08.01.0100 and Postgres 8.1

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Andrus" <eetasoft(at)online(dot)ee>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Dedect unknown database in 08.01.0100 and Postgres 8.1
Date: 2005-11-09 09:43:04
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4E7DE85@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
 

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org 
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
> Sent: 08 November 2005 19:02
> To: Andrus
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Dedect unknown database in 08.01.0100 and 
> Postgres 8.1 
> 
> "Andrus" <eetasoft(at)online(dot)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

Responses

pgsql-odbc by date

Next:From: HÃ¥kon ClausenDate: 2005-11-09 10:15:24
Subject: SQLRowCount
Previous:From: Leendert Paul DiterwichDate: 2005-11-09 09:12:21
Subject: Anyone using PostgresODBC and .NET 2.0?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group