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 [EMAIL PROTECTED] 512.569.9461 (cell) http://jim.nasby.net ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
