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

RE: Driver updates for 7.1

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: RE: Driver updates for 7.1
Date: 2001-01-25 08:23:34
Message-ID: 8568FC767B4AD311AC33006097BCD3D61A2918@woody.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: 25 January 2001 03:34
> To: Dave Page
> Cc: 'pgsql-odbc(at)postgresql(dot)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(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
> 

pgsql-odbc by date

Next:From: Dave PageDate: 2001-01-25 08:36:41
Subject: RE: RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows
Previous:From: Hiroshi InoueDate: 2001-01-25 06:02:11
Subject: Re: RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows

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