Skip site navigation (1) Skip section navigation (2)

Re: "Select * from table' ignores some records

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: "Select * from table' ignores some records
Date: 2007-04-02 12:23:42
Message-ID: 20070402122342.GB2059@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-odbc by date

Next:From: Hiroshi SaitoDate: 2007-04-02 13:08:17
Subject: Re: problems installing pgsql odbc driver
Previous:From: Josef SpringerDate: 2007-04-02 11:36:57
Subject: "Select * from table' ignores some records

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group