The following bug has been logged online:
Bug reference: 1492
Logged by: Rong Wang
Email address: rong@ozdocs.com.au
PostgreSQL version: 8
Operating system: Windows 2003
Description: PostgreSQL ODBC error
Details:
ODBC having an open nature allows client application to query SQL Syntax
capabilities of the database. The ODBC CK (an aplication using ODBC)uses
this to make sure it generates the correct syntax. When creating indexes it
asks the database if schema names should be used. PostgreSQL indicates they
should be used. When we do this we get a syntax error.
The technical detail:
When calling SQLGetInfo with the SQL_SCHEMA_USAGE InfoType it returns a
value with the SQL_SU_INDEX_DEFINITION set. It looks like this should not be
set.