| From: | "Farid Zidan" <cpp256(at)netscape(dot)net> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #1423: ODBC SQLTables SQL_ALL_CATALOGS and SQL_ALL_SCHEMAS options don't work |
| Date: | 2005-01-20 00:05:12 |
| Message-ID: | 200501200005.j0K05CH2007310@developer.pgadmin.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1423
Logged by: Farid Zidan
Email address: cpp256(at)netscape(dot)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.)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-01-20 04:18:35 | 8.0.0 pg_restore -L doesn't restore ACLs |
| Previous Message | Farid Zidan | 2005-01-19 23:56:30 | BUG #1422: ODBC SQLTables SQL_ALL_TABLE_TYPES no resultset |