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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
