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

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Xiaohui Xue <xiaohui(dot)xue(at)sap(dot)com>
Cc: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #5694: Postgres ODBC SQLTables is not working correctly
Date: 2010-10-07 12:43:34
Message-ID: 4CADC076.2000608@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Please try the drivers of version 8.2.3 or later.

(2010/10/07 11:04), Craig Ringer wrote:
> 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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-10-07 12:47:14 Re: 9.0 driver status
Previous Message Gustavo Pinsard 2010-10-07 11:11:57 Re: INSERT INTO ... RETURNING id not behaving as expected with SQLNumResultCols