The following bug has been logged online: Bug reference: 2892 Logged by: michael Email address: [EMAIL PROTECTED] 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 :) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
