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

BUG #2892: NULL problems, E_FAIL

From: "michael" <miblogic(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2892: NULL problems, E_FAIL
Date: 2007-01-14 11:31:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2892
Logged by:          michael
Email address:      miblogic(at)yahoo(dot)com
PostgreSQL version: 8.2.0 and 8.2.1
Operating system:   windows 2000
Description:        NULL problems, E_FAIL

hi PostgreSQL team,

i seems to find a flaw with NULL values in odbc driver, when using these for pg version 8.2.1, it errors

so i tried to use the much lower odbc version 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 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 = 
pg 8.2.1 =

best regards,


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 :)

pgsql-bugs by date

Next:From: Ilya KoganDate: 2007-01-14 20:05:40
Subject: BUG #2893: Non-standard theme explodes the installer.
Previous:From: David HiggsDate: 2007-01-13 19:39:41
Subject: Re: BUG #2889: Syntax error: WHERE ANY(arrayfield) = N

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