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 varyin
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
