The following bug has been logged online:
Bug reference: 5614
Logged by: Mariusz Majer
Email address: mmajer(at)janmedia(dot)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