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

[BUGS] BUG #5694: Postgres ODBC SQLTables is not working correctly

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: pgsql-odbc(at)postgresql(dot)org
Subject: [BUGS] BUG #5694: Postgres ODBC SQLTables is not working correctly
Date: 2010-10-07 02:04:39
Message-ID: 4CAD2AB7.1040407@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi folks

This request popped up on the -bugs list, and hasn't seen any response.
I don't really do/know ODBC, but it looks like a reasonable concern, so
I thought I'd pass it on in in case there's nobody equipped to deal with
it reading -bugs.

Original message follows.

-------- Original Message --------
Subject: [BUGS] BUG #5694: Postgres ODBC SQLTables is not working correctly
Date: Tue, 5 Oct 2010 15:56:17 GMT
From: Xiaohui Xue <xiaohui(dot)xue(at)sap(dot)com>
To: pgsql-bugs(at)postgresql(dot)org


The following bug has been logged online:

Bug reference:      5694
Logged by:          Xiaohui Xue
Email address:      xiaohui(dot)xue(at)sap(dot)com
PostgreSQL version: 8.3.4
Operating system:   Windows
Description:        Postgres ODBC SQLTables is not working correctly
Details:

Hi,

I'm using PostgreSQL ODBC Unicode (version 8.01.02.00) to connect to a
PostgreSQL server (version 8.3.4).

Following ODBC specification, when ODBC SQLTables is called with
- SchemaName is SQL_ALL_SCHEMAS
- CatalogName and TableName are empty strings
the result set contains a list of valid schemas for the data source. (All
columns except the TABLE_SCHEM column contain NULLs.)
http://msdn.microsoft.com/en-us/library/ms711831%28VS.85%29.aspx

But PostgreSQL ODBC returns still the list of tables. As result, we get a
list of duplicated schemas, as many times as the number of the tables in the
schema.

Thanks,
Xiaohui XUE

Responses

pgsql-odbc by date

Next:From: Ryan PfeifferDate: 2010-10-07 04:04:20
Subject: INSERT INTO ... RETURNING id not behaving as expected with SQLNumResultCols
Previous:From: RaifordDate: 2010-10-04 22:02:21
Subject: PostgreSQL ODBC 8.04.0200 and Crystal Reports XI Developer

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