Better version of ODBC to use with each version of Postgres

Hi, all
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 ?

I'm using VFP 8.0 with Postgres 8.0.xx in almost projects and want to
migrate these to Postgres 8.1.xx.
But I read some messages that there are some problems with
psqlodbc-08_01_0102 with VFP.
I'm have one project that I testing with Postgres 8.1 then I install
psqlodbc-08_01_0102, apparently it's all ok
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 ?
We have some optimistic probability of a new release version soon ?

TIA

PS. Sorry by my poor english



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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

> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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

------=_Part_10642_23772092.1138109540278
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

2006/1/24, Ludek Finstrle :
>
> > 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 thi=
s
> > 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

------=_Part_10642_23772092.1138109540278
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

2006/1/24, Ludek Finstrle <luf@pzkagis=
..cz>:

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

This is a multi-part message in MIME format.
--------------080408060602000104060705
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 >:
>
> > 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

--------------080408060602000104060705
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit







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:

type="cite">2006/1/24, Ludek Finstrle < href="mailto:luf@pzkagis.cz">luf@pzkagis.cz>:

style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">>
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