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

BUG #5694: Postgres ODBC SQLTables is not working correctly

From: "Xiaohui Xue" <xiaohui(dot)xue(at)sap(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5694: Postgres ODBC SQLTables is not working correctly
Date: 2010-10-05 15:56:17
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
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


I'm using PostgreSQL ODBC Unicode (version 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.)

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

Xiaohui XUE


pgsql-bugs by date

Next:From: Jeff HubbachDate: 2010-10-05 16:03:34
Subject: Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Previous:From: Magnus HaganderDate: 2010-10-05 13:18:27
Subject: Re: BUG #5687: RADIUS Authentication issues

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