Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr> 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