Re: INSERT rule

Darko Prenosil <darko.prenosil@finteh.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, vizALTER TABLE view ALTER COLUMN col SET DEFAULT whatever;
        regards, tom lane