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

From Donald Fraser
Subject Re: Default values for nulls not being set.
Date
Msg-id 003f01c2e272$aec9b900$1664a8c0@DEMOLITION
Whole thread Raw
In response to Default values for nulls not being set.  ("Donald Fraser" <demolish@cwgsy.net>)
List pgsql-bugs
> "Donald Fraser" <demolish@cwgsy.net> 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 to columns that have a direct relationship with an
underlying table. Obviously when a column does not have this relationship then
a default from a table cannot be used. If have I overlooked something
fundamental about views that makes this idea sound ridiculous then I apologise
for my ignorance.

Regards,
Donald Fraser

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Default values for nulls not being set.
Next
From: "Robert Haas"
Date:
Subject: Re: setting time zone during a transaction causes time warp