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.xue@sap.com>
To: pgsql-bugs@postgresql.org
The following bug has been logged online:
Bug reference: 5694
Logged by: Xiaohui Xue
Email address: xiaohui.xue@sap.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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs