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

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

From: Mariusz Majer <mmajer(at)janmedia(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5614: Varchar column (with DEFAULT NULL) stores 'UL' value instead of null
Date: 2010-08-16 07:54:44
Message-ID: 1281945284853-2636403.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I am using postgresql-8.2-504.jdbc3.jar driver. 

I altered table ecom2_orders using psql (not JDBC to exclude its influence):
ALTER TABLE ecom2_orders ALTER COLUMN net_source SET DEFAULT NULL;

Now when you enter command:
\d ecom2_orders
you got:
net_source                      | character varying(100)      | default
NULL::character varying
password_pdf                    | character varying(50)       |

in dump.txt result of execution query you provided
> select * from pg_attrdef where adrelid = 'ecom2_orders'::regclass; 

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??). 

http://postgresql.1045698.n5.nabble.com/file/n2636403/descr.txt descr.txt 

-- 
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-5614-Varchar-column-with-DEFAULT-NULL-stores-UL-value-instead-of-null-tp2473415p2636403.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

In response to

Responses

pgsql-bugs by date

Next:From: Felipe LopesDate: 2010-08-16 14:03:49
Subject: LINE COMMAND
Previous:From: Tom LaneDate: 2010-08-16 02:54:31
Subject: Re: DropRelFileNodeBuffers API change (was Re: [BUGS] BUG #5599: Vacuum fails due to index corruption issues)

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