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

ODBC Patch for OJs/Large Querys & Rows

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>, "'pgsql-patches(at)postgresql(dot)org'" <pgsql-patches(at)postgresql(dot)org>
Subject: ODBC Patch for OJs/Large Querys & Rows
Date: 2001-01-24 10:32:06
Message-ID: 8568FC767B4AD311AC33006097BCD3D61A290E@woody.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbcpgsql-patches
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: odbc.patch
Description: application/octet-stream (5.7 KB)

Responses

pgsql-odbc by date

Next:From: Bruce MomjianDate: 2001-01-24 13:50:20
Subject: Re: unixODBC again :-(
Previous:From: Cedar CoxDate: 2001-01-24 09:52:22
Subject: Re: Re: [INTERFACES] Re: more odbc patches

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-01-24 13:40:41
Subject: Re: [PORTS] Locale bug
Previous:From: Cedar CoxDate: 2001-01-24 09:52:22
Subject: Re: Re: [INTERFACES] Re: more odbc patches

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