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

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

2009-10-15 Thread Kevin Grittner
Sean Hsien umph...@gmail.com wrote: 2009/10/15 Kevin Grittner kevin.gritt...@wicourts.gov: 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

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

[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

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

2009-10-14 Thread Kevin Grittner
Sean Hsien umph...@gmail.com 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