Re: Provider & DBMS version

[Rodrigo Moya <rodrigo linuxave net>]

Vivien Malerba wrote:
> 
> On jeu, 13 jui 2000, you wrote:
> > Vivien Malerba wrote:
> > >
> > > Hi!
> > >
> > > As Postgres V7.0.2 has been released, I would like to make the postgres
> > > provider work with this new version. However it seems that the communication
> > > protocol in this new version has changed a bit. So if the new provider works
> > > with that version, it will not work anymore with the older versions.
> > >
> > > Do you think it would be a good think to have several postgres providers built,
> > > one for each postgres protocol backend (for example gda-postgres-srv6.5.x and
> > > gda-postgres-srv7.0.2)?
> > >
> > Is there any way of determining the version being used to compile (maybe
> > a #define), and if possible have the code with #ifdef when there is a
> > difference in the code? or are there too many differences?
> 
> Maybe I could find a way, but the problem comes not at compile time, but at
> execution: suppose I want to connect to a postgres backend which is not the
> same version as the one for which the provider has been compiled. That is the
> problem here.
> 
oh yes, I didn't think about this being the real problem.

> Maybe I should just bother with the compile problem assuming that one will
> compile for the version he has installed. This is what I will do (and anyway,
> otherwise one can use the ODBC as Nick suggested).
> 
And, how is it done in the ODBC drivers, Nick? is it the same driver
which is able to connect to both versions?