Bradley Kieser <brad(at)kieser(dot)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