On 2013-01-18, Leif Jensen <leif@xxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
