The following bug has been logged online: Bug reference: 5614 Logged by: Mariusz Majer Email address: mma...@janmedia.com PostgreSQL version: 8.3.11 Operating system: Debian (Linux 2.6.26-1-686-bigmem #1 SMP i686 GNU/Linux) Description: Varchar column (with DEFAULT NULL) stores 'UL' value instead of null Details:
Varchar column store 'UL' value instead of null There has been a table ecom2_orders for a while (~0.5m records). After executing query: ALTER TABLE ecom2_orders ADD COLUMN password_pdf character varying(50); when new rows are added, column password_pdf is filled with 'UL' value rather than null psql>\d table (...) Column description: password_pdf | character varying(50) | default NULL::character varying version 8.3.11 - has got above bug version 8.1.19 - works fine -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
