Re: Update rule on a view - what am I doing wrong
От | Leif Jensen |
---|---|
Тема | Re: Update rule on a view - what am I doing wrong |
Дата | |
Msg-id | 26331355.18665.1358861683212.JavaMail.root@quick обсуждение исходный текст |
Ответ на | Re: Update rule on a view - what am I doing wrong (Jasen Betts <jasen@xnet.co.nz>) |
Ответы |
Re: Update rule on a view - what am I doing wrong
|
Список | pgsql-general |
Hi Jasen. Thank you for your response (also thank you to Tom). I have now tried your suggestion, but I'm not sure how you have implemented the plpgsql function. When I create the function:CREATE update_rule_func( old record, new record ) AS ... I am told, that I cannot use record for the parametertype. Could you please expand a little on your example ? Leif ----- "Jasen Betts" <jasen@xnet.co.nz> wrote: > 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 > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: