Re: INSERT rule - Mailing list pgsql-hackers

From Darko Prenosil
Subject Re: INSERT rule
Date
Msg-id 001401c45dff$8d7d4fa0$1e82bfd5@darko
Whole thread Raw
In response to INSERT rule  (Darko Prenosil <darko.prenosil@finteh.hr>)
List pgsql-hackers
God, that was so obvious !
Thanks (again).

Regards !

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Darko Prenosil" <darko.prenosil@finteh.hr>
Cc: <pgsql-hackers@postgresql.org>
Sent: Tuesday, June 29, 2004 4:18 PM
Subject: Re: [HACKERS] 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, 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
>



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: lock timeout patch
Next
From: "Darko Prenosil"
Date:
Subject: Re: User Privileges using dblink