Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group