Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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

pgsql-odbc by date

Next:From: noreplyDate: 2007-07-16 13:21:40
Subject: [ psqlodbc-Bugs-1007690 ] SQLNumResultCols returns error and HY000 error when it should be success and 0 columns
Previous:From: Rainer BauerDate: 2007-07-16 10:11:01
Subject: Return value of enlarge_query_statement() is never evaluated

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group