Обсуждение: [BUGS] BUG #5694: Postgres ODBC SQLTables is not working correctly
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
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.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