Re: Better version of ODBC to use with each version of Postgres

Thank's Ludek and Alejandro.

This clarify what's I can recommend to my team to do.
I will wait the new release before to recommend upgrade and in the test
project, will use 08.01.0107.

Alejandro D. Burne wrote:
> 2006/1/24, Ludek Finstrle <luf(at)pzkagis(dot)cz <mailto:luf(at)pzkagis(dot)cz>>:
>
> > I'm some confusing about what the better version of Odbc to use with
> > Postgres 8.0.x versions
> > Is the psqlodbc-08_00_0102 better to use than psqlodbc-08_01_0102 ?
>
> No it isn't. Higher psqlODBC version may be better. There are
> some known problems between 07.03 and 08.01 (I'm sorry I don't know
> if the problem raised between 07.03 and 08.00 or between 08.00 and
> 08.01).
> 08.01 is libpq based. It means that 08.01 is using libpq calls when
> communicate with backend.
> We follow backend version numbering but we may be backward compatible
> (08.01 my be backward compatible with 7.3 at least).
>
> > But I read some messages that there are some problems with
> > psqlodbc-08_01_0102 with VFP.
>
> Yes it's true.
>
> > I'm have one project that I testing with Postgres 8.1 then I install
> > psqlodbc-08_01_0102, apparently it's all ok
>
> If you have no problem you can use the version which better suite to
> you (time comparsing or whatever you want).
>
> > Well, I know that psqlodbc-08_01_0107 is a snapshot release, but
> in this
> > case is more recommended still work with 08_01_0102 or use
> 08_01_0107 ?
>
> I'm recommending 08.01.0107. But I advise you test the psqlODBC before
> you use it in production. 08.01.0107 has a many bug fixes againist
> 08.01.0102. Some of the changes could create another bug which we
> haven't find yet ...
>
> > We have some optimistic probability of a new release version soon ?
>
> If you read 08.01.0107 release notes we're close to releasing new
> stable release. There is 64-bit compatibility problem which we marked
> as release stopper. I hope we'll solve the 64-bit issue quite soon
> (week or two).
>
> I hope I don't add you more questions then answers.
>
> Regards,
>
> Luf
>
>
> Hi, I'm a vfp+postgres developer too, (vfp 6.0 - postgres 8.1), I
> suggest use of 08.01.0107 psqlODBC's version. This solved a lot of
> C00005 error messages on vfp.
>
> Alejandro