problems with rules and views

From: "Fabrizio Mazzoni" <fabrizio(at)macron(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: problems with rules and views
Date: 2001-07-09 08:17:41
Message-ID: 001801c1084f$a007f840$4f00a8c0@fabrizio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all..
I'm having problems with a view..
I created a view which uses multiple tables and this view must be updated. I
checked the docs and it explains that i need a rule to do this..
Ok i understood it..what i don't understand is how to create this rule for
an entire view. The docs explain how to create the rule for a few fields of
the view but i need that the view must be all updatable..
Considering that my view has about 35 columns, is there a way to write a
rule that does a batch update..?? Something like:

create rule xxx as
on update to yyy <-- my view
do instead
update to xxx,qqq,zzz; <-- tables from which the view is created

Or do i have to write a statement for each column...

Awaiting for your suggestions i thank you all...

Regards

fabrizio(at)macrongolf(dot)com
http://macrongolf.com
http://eteampoint.com
http://macron.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-07-09 09:36:34 Re: error handling. How to?
Previous Message Janning Vygen 2001-07-09 08:03:55 error handling. How to?