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
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? |