Re: Driver updates for 7.1

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Driver updates for 7.1
Date: 2001-01-25 03:33:38
Message-ID: 200101250333.WAA00474@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2001-01-25 06:02:11 Re: RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows
Previous Message Bruce Momjian 2001-01-25 03:28:38 Re: Additional ODBC patch