Darko Prenosil <[EMAIL PROTECTED]> writes:
> Just wrote a function that takes view name as argument and generates INSERT,
> UPDATE and DELETE rules for that view. It is working OK (thanks to Tom), but
> I have trouble with INSERT rule.
> When inserting directly into table, default values are filled in when the
> field is not in the insert target list, but when using rule system field is
> filled with NULL.
You want to attach the defaults directly to the view, viz
ALTER TABLE view ALTER COLUMN col SET DEFAULT whatever;
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
