Re: [BUGS] issue with integer nullable column and value 0

2009-10-15 Thread Sean Hsien
Found the bug...was my fault, of course. Sorry for the mistake. Sean -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] issue with integer nullable column and value 0

2009-10-15 Thread Kevin Grittner
Sean Hsien wrote: > 2009/10/15 Kevin Grittner : >> what are the OS and Java versions on the client side? > I'm using CentOS 5.2 64-bits with postgres 8.1.11 + java 6u16, and > Windows Vista 32-bits with postgres 8.4.1 + java 6u13. So the Java code is running on the same machine as the databa

Re: [BUGS] issue with integer nullable column and value 0

2009-10-15 Thread Sean Hsien
I'm using CentOS 5.2 64-bits with postgres 8.1.11 + java 6u16, and Windows Vista 32-bits with postgres 8.4.1 + java 6u13. Here is a small code snippet that shows the problem, where the user id value is 0: public void update(EntityVO vo) { StringBuilder sql = new StringBuil

Re: [BUGS] issue with integer nullable column and value 0

2009-10-14 Thread Kevin Grittner
Sean Hsien wrote: > using the latest JDBC driver type 4. > I have a nullable integer column in one of my tables. When I'm > updating the column in 8.4 Windows with value 0, it stays as null, > but on the Linux 8.1 it will try to update it with the value 0. Could you post a small, self-contai

[BUGS] issue with integer nullable column and value 0

2009-10-14 Thread Sean Hsien
Hi guys, I'm not sure what the source of this bug is, as I'm getting a discrepancy between 8.1 on Linux vs. 8.4 on Windows, using the latest JDBC driver type 4. The issue is this, I have a nullable integer column in one of my tables. When I'm updating the column in 8.4 Windows with value 0, it st