Обсуждение: RE: RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows

Поиск
Список
Период
Сортировка

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

От
Dave Page
Дата:

> -----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.
Вложения

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

От
Hiroshi Inoue
Дата:
Dave Page wrote:
>

[snip]

> > >
> > > 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).
>

Thanks.
I may be able to fix a large-object related change
using your pg_version(_number).

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

Unfortunately I know no one who could test both :-).

Regards,
Hiroshi Inoue