Thread: RE: [ODBC] RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows

RE: [ODBC] RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows

From
Dave Page
Date:

> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
> Sent: 25 January 2001 16:28
> To: Dave Page; Bruce Momjian
> Cc: pgsql-interfaces; pgsql-odbc@postgresql.org
> Subject: RE: [ODBC] RE: [PATCHES] ODBC Patch for OJs/Large
> Querys & Rows
>
>
> > -----Original Message-----
> > From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> >
> > We usually are more concerned about old libraries talking to new
> > servers.  New libraries talking to old servers are not
> needed as much.
> >
>
> I strongly object.
> Postgres ODBC driver has supported all the way back to version 6.2(
> or 6.0 according to a person's opinion). Why could we easily break the
> backward compatibility without any consensus ?

OK. Here's another (additional) patch. This gets the PostgreSQL version upon
connection, and then uses it to determine what to return from SQLGetInfo for
SQL_DBMS_VER, SQL_MAX_ROW_SIZE, SQL_MAX_STATEMENT_LEN, SQL_OJ_CAPABILITIES
and SQL_OUTER_JOINS. This makes all my changes backward compatible. It also
increments the revision number to 07.01.0001 and corrects the format of the
version number which I previously mistyped as 7.1.0000 (as per ODBC
requirements).

NB: I've not tested this under *nix, only W2K.

Regards, Dave.



Attachment