Re: updatable views and default values

On Thu, Aug 31, 2006 at 06:29:50PM -0400, Tom Lane wrote:
> For backwards compatibility we should probably say that this automatic
> lifting of base-table defaults happens only if the INSERT rule is
> implicitly generated ... if you write a manual INSERT rule you need
> manual defaults too.  Or should "propagate default values" become an
> explicit attribute of ON INSERT rules?

ISTM that least surprise dictates that inserting into a view uses the
base table default unless you specifically override them.
-- 
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net