Re: Provider & DBMS version

[Vivien Malerba <malerba linuxave net>]

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. 

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).

Vivien