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 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
