The following bug has been logged online:
Bug reference: 2892
Logged by: michael
Email address: miblogic@yahoo.com
PostgreSQL version: 8.2.0 and 8.2.1
Operating system: windows 2000
Description: NULL problems, E_FAIL
Details:
hi PostgreSQL team,
i seems to find a flaw with NULL values in odbc driver
psqlodbc-08_01_0200.zip, when using these for pg version 8.2.1, it errors
E_FAIL.
so i tried to use the much lower odbc version psqlodbc-08_01_0101.zip for
8.2.1, the error gone.
my query is basically an expense transaction with fund transfer(optional,
hence NULL-able), using LEFT JOIN.
what i find strange is i'm already using psqlodbc-08_01_0200.zip for pg
version 8.2.0 and it's ok, but it doesn't work with pg 8.2.1
these are the OK setup:
pg 8.2.0 = psqlodbc-08_01_0200.zip
pg 8.2.1 = psqlodbc-08_01_0101.zip
best regards,
mike
p.s.
btw, "no buffer space available" is still very much a problem in Windows
2000 Server, when doing dump backups, and sometimes when fetching data (the
user has to retry opening the record). but this doesn't happen when
PostgreSQL is in Windows XP Professional, i'm already thinking to make WinXP
as our PostgreSQL server, but WinXP has something only 10 "hardwired"
concurrent TCP/IP connections, this is not suitable in our environment, we
exceeded 10 concurrent users
overall, thanks for the greatest database product :)