ODBC Patch for OJs/Large Querys & Rows - Mailing list pgsql-odbc

From Dave Page
Subject ODBC Patch for OJs/Large Querys & Rows
Date
Msg-id 8568FC767B4AD311AC33006097BCD3D61A290E@woody.vale-housing.co.uk
Whole thread Raw
Responses Re: ODBC Patch for OJs/Large Querys & Rows  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: [PATCHES] ODBC Patch for OJs/Large Querys & Rows  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-odbc
Hi,

I decided to give this a go after all :-) The attached patch does the
following but it does *not* check whether the user is connected to
PostgreSQL 7.0.x or 7.1 first (as would be required for some of the
features) - the driver doesn't do this at all afaik and it's beyond my
capabilities to implement such checking in code that doesn't look like it
was written by my 1 year old daughter!

1) The driver now reports no maximum query length (SQL_MAX_QUERY_SIZE).
2) The driver now reports no maximum row length (SQL_MAX_ROW_SIZE).
3) The driver now reports that Outer Joins are supported (SQL_OUTER_JOINS),
but still does not report oj capabilities (SQL_OJ_CAPABILITIES).
4) The version number has been incremented to 7.1.0000 in psqlodbc.h *and*
psqlodbc.rc

If someone can clarify which SQL_OJ_CAPABILITIES PostgreSQL supports I
should be able to sort that as well.

BTW: If this patch gets thrown straight in the bin I won't be offended :-)

Regards,

Dave.


Attachment

pgsql-odbc by date:

Previous
From: Cedar Cox
Date:
Subject: Re: Re: [INTERFACES] Re: more odbc patches
Next
From: Bruce Momjian
Date:
Subject: Re: unixODBC again :-(