"Select * from table" ignores some records
am 02.04.2007 13:36:57 von Josef Springer
Hi folks,
our customer works with PostgreSQL 8.1.0 an ODBC driver 8.01.01.00:
"Select from " 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Re: "Select * from table" ignores some records
am 02.04.2007 14:23:42 von Ludek Finstrle
Hello
> our customer works with PostgreSQL 8.1.0 an ODBC driver 8.01.01.00:
>
> "Select from " 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq