Postgres Pro
Downloads
Home   >   mailing lists

Thread: "Select * from table' ignores some records

"Select * from table' ignores some records

From
Josef Springer
Date:
Hi folks,

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

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

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 ?

Josef Springer
JOOPS Informationstechnik GmbH

Re: "Select * from table' ignores some records

From
Ludek Finstrle
Date:
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