Re: Default values for nulls not being set. - Mailing list pgsql-bugs

"Donald Fraser" <demolish@cwgsy.net> writes:
> I have a major problem with DEAFAULT values:

Consider attaching a default to the view column.  As-is, its default
is NULL (and I can't see any good argument for the factory default
being anything else).

tt=# INSERT INTO vu_tbl_test (id, s_desc) VALUES('2', 'View insert test');
ERROR:  ExecInsert: Fail to add null value in not null attribute b_disabled
tt=# alter table vu_tbl_test alter column b_disabled set default '0';
ALTER TABLE
tt=# INSERT INTO vu_tbl_test (id, s_desc) VALUES('2', 'View insert test');
INSERT 0 1
tt=#

            regards, tom lane