Postgres Pro
Downloads
Home   >   mailing lists

BUG #1423: ODBC SQLTables SQL_ALL_CATALOGS and SQL_ALL_SCHEMAS options don't work - Mailing list pgsql-bugs

From Farid Zidan
Subject BUG #1423: ODBC SQLTables SQL_ALL_CATALOGS and SQL_ALL_SCHEMAS options don't work
Date
Msg-id 200501200005.j0K05CH2007310@developer.pgadmin.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      1423
Logged by:          Farid Zidan
Email address:      cpp256@netscape.net
PostgreSQL version: 8.0
Operating system:   Windows 2000
Description:        ODBC SQLTables SQL_ALL_CATALOGS and SQL_ALL_SCHEMAS
options don't work
Details:

You get an incorrect resultset.

ODBC documentation for SQLTables:

If CatalogName is SQL_ALL_CATALOGS and SchemaName and TableName are empty
strings, the result set contains a list of valid catalogs for the data
source. (All columns except the TABLE_CAT column contain NULLs.)

If SchemaName is SQL_ALL_SCHEMAS and 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.)

pgsql-bugs by date:

Previous
From: "Byron Zambrano"
Date:
Subject: BUG #1420: Doesn't accomplish connection with the server
Next
From: MAX MARCELL
Date:
Subject: BUG PostgreSQL for Windows