Re: BUG #5694: Postgres ODBC SQLTables is not working correctly - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5694: Postgres ODBC SQLTables is not working correctly
Date
Msg-id AANLkTi=nCy0x8Qm-zVw5aS3eHVGVY0zMOtTG+KDE=OY2@mail.gmail.com
Whole thread Raw
In response to BUG #5694: Postgres ODBC SQLTables is not working correctly  ("Xiaohui Xue" <xiaohui.xue@sap.com>)
List pgsql-bugs
On Tue, Oct 5, 2010 at 11:56 AM, Xiaohui Xue <xiaohui.xue@sap.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05694
> Logged by: =A0 =A0 =A0 =A0 =A0Xiaohui Xue
> Email address: =A0 =A0 =A0xiaohui.xue@sap.com
> PostgreSQL version: 8.3.4
> Operating system: =A0 Windows
> Description: =A0 =A0 =A0 =A0Postgres ODBC SQLTables is not working correc=
tly
> 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.

You may want to report this problem here:

http://archives.postgresql.org/pgsql-odbc/

This list is for bugs in core PostgreSQL.

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: libpq: system-wide root.crt
Next
From: Michael Meskes
Date:
Subject: Re: rollback to savepoint leads to transaction already in progress