From: | <noreply(at)pgfoundry(dot)org> |
---|---|
To: | noreply(at)pgfoundry(dot)org |
Subject: | [ psqlodbc-Bugs-1007689 ] Returns ODBC 2.0 column names for SQLTables calls but reports ODBC 3.0 |
Date: | 2007-07-16 13:11:35 |
Message-ID: | 20070716131135.57AB4216D41@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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 SQLTables and 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 version as 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
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2007-07-16 13:21:40 | [ psqlodbc-Bugs-1007690 ] SQLNumResultCols returns error and HY000 error when it should be success and 0 columns |
Previous Message | Rainer Bauer | 2007-07-16 10:11:01 | Return value of enlarge_query_statement() is never evaluated |