Re: [BUGS] Default values for nulls not being set.

2003-03-04 Thread Donald Fraser
> "Donald Fraser" <[EMAIL PROTECTED]> writes: > > What would be nice is when you don't specify a default on the view, the default > > from the table is used. > > What table? You seem to have an extremely narrow-minded concept of what > a view is. > > regards, tom lane In the above I was referring

Re: [BUGS] Default values for nulls not being set.

2003-03-04 Thread Tom Lane
"Donald Fraser" <[EMAIL PROTECTED]> writes: > What would be nice is when you don't specify a default on the view, the default > from the table is used. What table? You seem to have an extremely narrow-minded concept of what a view is. regards, tom lane --

Re: [BUGS] Default values for nulls not being set.

2003-03-04 Thread Donald Fraser
> "Donald Fraser" <[EMAIL PROTECTED]> 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). What would be nice is when you don't

Re: [BUGS] Default values for nulls not being set.

2003-03-03 Thread Tom Lane
"Donald Fraser" <[EMAIL PROTECTED]> 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