Richard Huxton <dev@archonet.com> writes:
> On Friday 19 September 2003 16:04, Tom Lane wrote:
>> What Berend actually wants is to attach column defaults to the *view*,
>> so that they apply to an INSERT mentioning the view. You can do this in
>> recent PG releases (7.3 for sure, not sure about 7.2) using ALTER TABLE
>> ... ADD DEFAULT.
> Am I right in thinking that *in theory* we should be able to "inherit" the
> defaults to the view automatically?
[shrug] Maybe, in simple cases. I'm not convinced it'd be especially
useful. The defaults applicable to direct inserts into a table aren't
necessarily sensible for inserts via a view.
regards, tom lane