| Lists: | pgsql-bugs |
|---|
| 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: | 201010051556.o95FuHNP059233@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
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
| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Xiaohui Xue <xiaohui(dot)xue(at)sap(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #5694: Postgres ODBC SQLTables is not working correctly |
| Date: | 2010-10-14 01:16:03 |
| Message-ID: | AANLkTi=nCy0x8Qm-zVw5aS3eHVGVY0zMOtTG+KDE=OY2@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
On Tue, Oct 5, 2010 at 11:56 AM, Xiaohui Xue <xiaohui(dot)xue(at)sap(dot)com> wrote:
>
> 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.
You may want to report this problem here:
http://archives.postgresql.org/pgsql-odbc/
This list is for bugs in core PostgreSQL.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company