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

Re: Re: BUG #5614: Varchar column (with DEFAULT NULL) stores 'UL' value instead of null

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mariusz Majer <mmajer(at)janmedia(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Re: BUG #5614: Varchar column (with DEFAULT NULL) stores 'UL' value instead of null
Date: 2010-08-16 15:30:43
Message-ID: 5204.1281972643@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Mariusz Majer <mmajer(at)janmedia(dot)com> writes:
> I am using postgresql-8.2-504.jdbc3.jar driver. 
> When I add one row from psql:
> - in net_source I got null value, 
> while adding new order from application using JDBC 
> - in net_source I got 'UL' value
> ...so in my opinion it might be issue with JDBC (maybe too old JDBC??). 

Maybe.  These dumps seem to be from a newer-than-8.2 server, so it'd be
a good idea to update to a matching JDBC version in any case.

> in dump.txt result of execution query you provided
>> select * from pg_attrdef where adrelid = 'ecom2_orders'::regclass; 
> http://postgresql.1045698.n5.nabble.com/file/n2636403/descr.txt descr.txt 

These results look perfectly normal to me.  You're sure you got the data
for a malfunctioning table, not a correct table?

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Josh BerkusDate: 2010-08-16 17:26:58
Subject: Re: Unable to create serial column even with permissions
Previous:From: Tom LaneDate: 2010-08-16 14:59:47
Subject: Re: LINE COMMAND

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