Re: "Select * from table' ignores some records - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: "Select * from table' ignores some records
Date
Msg-id 20070402122342.GB2059@soptik.pzkagis.cz
Whole thread Raw
In response to "Select * from table' ignores some records  (Josef Springer <Josef.Springer@joops.com>)
List pgsql-odbc
Hello

> our customer works with PostgreSQL 8.1.0 an ODBC driver 8.01.01.00:
>
> "Select <column-name,...> from <table>" ignores some records.
>
> In our environment PostgreSQL 8.1.4 an ODBC driver 8.01.02.00 all works
> fine. Why ???

Who knows ;o) Maybe some bug in 08.01.0100.

> What to to ? Should users update his environment ?
> How is an update done ? Or is it enouhgt to update the ODBC-driver ?

I recommend the ODBC driver upgrade at first. You can do it in a number
of ways. E.g. you can only replace psqlodbc*.dll. Or you can reinstall
it with msi installer.

> The setup of 8.1.4 contains an update.bat. It this to be used ?
> Has the database to be prepeared for updating to 8.1.4 ?

BTW 8.1.0 and 8.1.4 contains bugs. Why don't you upgrade to the latest
8.1.X (8.1.8 right now - http://www.postgresql.org/support/versioning).
What's needed you can find on www.postgresql.org (or in pgsql-admin
mailing list archive).

Regards,

Luf

pgsql-odbc by date:

Previous
From: Josef Springer
Date:
Subject: "Select * from table' ignores some records
Next
From: "Hiroshi Saito"
Date:
Subject: Re: problems installing pgsql odbc driver