RE: Driver updates for 7.1

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent: 25 January 2001 03:34
> To: Dave Page
> Cc: 'pgsql-odbc@postgresql.org'
> Subject: Re: Driver updates for 7.1
>
>
>
> Dave, did you fix all of these?

If you apply all three patches I submitted yesterday then yes, including
SQL_OJ_CAPABILITIES. There is still a restriction on query size though as
MAX_MESSAGE_LEN is used to define the message buffer length in a number of
places. I've increased it from 8192 to 65536 which should be big enough for
most people (i'd have thought), but I think a fair bit of work, beyond my
expertise would be required to remove the limit completely.

Regards,

Dave.

> > 1) SQLGetInfo SQL_MAX_ROW_SIZE returns BLKSZ which is
> defined as 4096. With
> > Toast in 7.1 presumably this is now incorrect?
> >
> > 2) SQLGetInfo SQL_MAX_STATEMENT_LEN currently returns
> MAX_QUERY_SIZE which
> > is defined as 2* BLKSZ. Again, incorrect for 7.1 (and 7.0.x
> if I remember
> > correctly)?
> >
> > 3) SQLGetInfo SQL_OUTER_JOINS currently returns 'N'. Should
> be 'Y' for 7.1?
> > As the driver now claims to conform to ODBC v2.50, does SQLGetInfo
> > SQL_OJ_CAPABILITIES also need to be implemented?
> >
> > Also, what with these and other recent updates such as
> referential integrity
> > violation reporting, not to mention the recent confusion on
> the interfaces
> > list as to what is the most up-to-date driver, perhaps the
> version number
> > should be updated in psqlodbc.rc *and* psqlodbc.h.
> >
> > Regards,
> >
> > Dave.
> >
> >
>
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill,
> Pennsylvania 19026
>