Re: Rules on a view overwrite default values. Any way to

Thanks Tom and Stephan!

This works perfectly!

Brad


Tom Lane wrote:

>Bradley Kieser <brad@kieser.net> writes:
>
>
>>The problem is that rules on a view mean that the default values for NOT
>>NULL columns (used extensively) no longer trigger!
>>
>>
>
>The way you're supposed to fix this is to attach default values to the
>view itself.
>
>ALTER TABLE myview ALTER COLUMN updated_time SET DEFAULT now();
>
>Now an INSERT on myview will include the correct expression before view
>expansion happens.
>
>I'm not sure how long we've had this, but it's definitely in 7.4.
>
>            regards, tom lane
>
>
>