Re: Update rule on a view - what am I doing wrong - Mailing list pgsql-general

On 2013-01-18, Leif Jensen <leif@crysberg.dk> wrote:

>    I have been fighting a problem with an update rule on a view. I
> have a view that combines two tables where the 'sub' table (scont) can
> have several rows per row in the 'top' table (icont). The view
> combines these to show only one record per row in the top table. To be
> able to update on this view I have created a rule 'on update'. The
> rule needs to have both UPDATE, DELETE, and INSERT commands. Is this
> not possible or am I doing something else wrong ?

when I hit that issue in 8.4 i used a plpgsql function

  ... do instead select update_rule_func(old,new);

--
⚂⚃ 100% natural