Thread: [ psqlodbc-Bugs-1007689 ] Returns ODBC 2.0 column names for SQLTables calls but reports ODBC 3.0

Bugs item #1007689, was opened at 2007-07-16 13:11
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1007689&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Martin Evans (mjevans)
Assigned to: Nobody (None)
Summary: Returns ODBC 2.0 column names for SQLTables calls but reports ODBC 3.0

Initial Comment:
Using the Postgres ODBC Driver 08.01.0200 on Linux/Ubuntu it fails some of the Perl DBD::ODBC tests. If you call
SQLTablesand then look at the column names the names for the columns returned are: 

TABLE_QUALIFIER
TABLE_OWNER
TABLE_NAME
TABLE_TYPE
REMARKS

but these are ODBC 2 defined column names. As DBD::ODBC asks for ODBC 3.0 and the postgres driver reports it's ODBC
versionas 03.00 (via SQL_DRIVER_ODBC_VERSION) the returned column names should be: 

TABLE_CAT
TABLE_SCHEM
TABLE_NAME
TABLE_TYPE
REMARKS


----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1007689&group_id=1000125