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

RE: [ODBC] RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "pgsql-interfaces" <pgsql-interfaces(at)postgreSQL(dot)org>, <pgsql-odbc(at)postgresql(dot)org>
Subject: RE: [ODBC] RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows
Date: 2001-01-25 16:28:29
Message-ID: EKEJJICOHDIEMGPNIFIJKEOADGAA.Inoue@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-odbc
> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> 
> > Yes, that could happen, though in reality I suspect it proably 
> wouldn't as
> > (in my experience - I may be wrong) those technologies do 
> little more than
> > putting SELECT * FROM in front of a given table name and 
> generating query
> > based updates.
> > 
> > I suspect that more problems may be caused for apps like MS 
> Query or Seagate
> > Crystal Reports which might attempt to use outer joins on an 
> older database
> > (actually Query just enables/disables the relevant join 
> options). As far as
> > I can tell, the driver doesn't check the backend version 
> (despite returning
> > the DBMS version which is currently hardcoded), so we'd either 
> need to add a
> > 7.1 protocol option (not nice as it isn't really a different 
> protocol) or do
> > a SELECT VERSION() on connect to get the exact version string 
> and figure out
> > what is/isn't possible from that.
> > 
> > I'll look into it but I'm on the wrong end of the learning curve here!
> 
> We usually are more concerned about old libraries talking to new
> servers.  New libraries talking to old servers are not needed as much.
> 

I strongly object.
Postgres ODBC driver has supported all the way back to version 6.2(
or 6.0 according to a person's opinion). Why could we easily break the
backward compatibility without any consensus ?

I also object to centralize the version info. It is preferable that client
apps and servers are relatively indepedent as much as possible.
It seems very natural that client apps and the server have separate
versioning policies. Do we always have to wait for the all-in-one
release to get improved client apps ?

Regrads,
Hiroshi Inoue

In response to

Responses

pgsql-odbc by date

Next:From: Dave PageDate: 2001-01-25 16:53:11
Subject: RE: [ODBC] RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows
Previous:From: Alfonso PenicheDate: 2001-01-25 15:46:14
Subject: serial values and odbc

pgsql-interfaces by date

Next:From: Dave PageDate: 2001-01-25 16:53:11
Subject: RE: [ODBC] RE: [PATCHES] ODBC Patch for OJs/Large Querys & Rows
Previous:From: Manika DeyDate: 2001-01-25 16:21:53
Subject: Re: [ANNOUNCE] Gedafe (the Generic Database Front-End) 1.0.0

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