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

RE: 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 06:02
> To: Bruce Momjian
> Cc: Dave Page; 'Tom Lane'; 'pgsql-patches@postgresql.org';
> 'pgsql-odbc@postgresql.org'
> Subject: Re: [ODBC] RE: [PATCHES] ODBC Patch for OJs/Large
> Querys & Rows
>
>
> Bruce Momjian wrote:
> >
> > Applied.  Thanks.
> >
>
> Hmm, does the new version number "7.1.0000" mean that the
> new ODBC driver could only talk to 7.1 server ?
>

No, but it does now report that it can handle unlimited query & row length
(although in reality as MAX_MESSAGE_LEN=65536 it's not really unlimited -
some work needed to fix that), as well as outer joins which are features
that are only in 7.1 of course. It certainly still works with 7.0.3 as long
as you don't send too long a query or an oj query - which the backend will
complain about anyway.

My other reasoning for this change was that the current source had a version
number of 6.40.0009 whilst Byron's last compiled version seemed to be
6.50.0000 - there seems to have been much confusion about this on the list
(as well as the 'Will this 6.40 driver work with 7.0' faq). It also makes me
wonder if the CVS is missing Byron's last changes as well as the correct
version number...

Regards,

Dave.

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

From
Hiroshi Inoue
Date:
Dave Page wrote:
>

[snip]

> >
> > Hmm, does the new version number "7.1.0000" mean that the
> > new ODBC driver could only talk to 7.1 server ?
> >
>
> No, but it does now report that it can handle unlimited query & row length
> (although in reality as MAX_MESSAGE_LEN=65536 it's not really unlimited -
> some work needed to fix that), as well as outer joins which are features
> that are only in 7.1 of course. It certainly still works with 7.0.3 as long
> as you don't send too long a query or an oj query - which the backend will
> complain about anyway.
>

It's not me who would send such queries. For exmaple, intelligent
DAO/RDO/ADO could see that a long or an oj query is allowed and
send such queries automatically in some cases though I don't know
if it would really occur or not.
Hmm, I found a large-object related change after 7.0 which would
break some pre-7.1 specs.

> My other reasoning for this change was that the current source had a version
> number of 6.40.0009 whilst Byron's last compiled version seemed to be
> 6.50.0000 - there seems to have been much confusion about this on the list
> (as well as the 'Will this 6.40 driver work with 7.0' faq).
> It also makes me
> wonder if the CVS is missing Byron's last changes as well as the correct
> version number...
>

It seems that Byron's last (equivalent) changes were committed
(by someone) except the version number.

Regards,
Hiroshi Inoue