SQLTables() doesn't support enumeration

From: Jon Willeke <willeke(at)users(dot)sourceforge(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: SQLTables() doesn't support enumeration
Date: 2004-01-30 17:21:32
Message-ID: 5.1.0.14.2.20040130121811.01f35758@wheresmymailserver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I'm using ODBCTest 3.510.3513.0 and psqlodbc 07.03.0200 on Windows 2000
with PostgreSQL 7.3.2 on SuSE Linux 8.2.

From the SQLTables() section in the ODBC Programmer's Reference: "To
support enumeration ... the following special semantics are defined for the
CatalogName, SchemaName, TableName, and TableType arguments of SQLTables:

"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.) ..."

Instead of getting the expected list, I get a list of tables.

Browse pgsql-odbc by date

  From Date Subject
Next Message Jon Willeke 2004-01-30 20:42:37 Re: Unicode support on Linux?
Previous Message Jon Willeke 2004-01-30 17:16:28 Unicode support on Linux?