Re: Driver updates for 7.1 - Mailing list pgsql-odbc

From Bruce Momjian
Subject Re: Driver updates for 7.1
Date
Msg-id 200101250333.WAA00474@candle.pha.pa.us
Whole thread Raw
In response to Driver updates for 7.1  (Dave Page <dpage@vale-housing.co.uk>)
List pgsql-odbc
Dave, did you fix all of these?

[ Charset ISO-8859-1 unsupported, converting... ]
>
> Unfortunately my understanding of the ODBC drivers internals is not such
> that I'm confident to do these mods myself (or my C for that matter!), but
> I've noticed a couple of things that probably should be updated for 7.1:
>
> 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

pgsql-odbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Additional ODBC patch
Next
From: Paul Breen
Date:
Subject: RE: [INTERFACES] bug in ODBC driver (and fix)