Re: Provider & DBMS version

[Rodrigo Moya <rodrigo linuxave net>]

Nick Gorham wrote:
> 
> Rodrigo Moya 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?
> >
> Or of course you could use the unixODBC postgres driver which works to both servers.
> 
> (ducks and runs :-)
> 
yes, that's an option, but we should provide native support for both
versions of PostgreSQL, if possible, of course. If not possible, we'll
have to drop support for one of the PostgreSQL versions, or do what
Vivien suggests, of having two postgres providers.