Thanks Tom and Stephan!
This works perfectly!
Brad
Tom Lane wrote:
Bradley Kieser <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
