God, that was so obvious ! Thanks (again). Regards !
----- Original Message ----- From: "Tom Lane" <[EMAIL PROTECTED]> To: "Darko Prenosil" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 29, 2004 4:18 PM Subject: Re: [HACKERS] INSERT rule > 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 > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster