The following bug has been logged online: Bug reference: 1492 Logged by: Rong Wang Email address: [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
