"Donald Fraser" <demolish(at)cwgsy(dot)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