| 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: | Whole Thread | Raw Message | 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? |