From: | "Michael Shulman" <shulman(at)mathcamp(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: inserting to a multi-table view |
Date: | 2008-06-19 18:01:01 |
Message-ID: | c3f821000806191101y5553906bqce9aec497e1aedc6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks to everyone who responded to this thread; although I have not
gotten a complete solution I have learned a lot about how rules and
triggers work. One particular question that is still unanswered:
On Mon, Jun 16, 2008 at 9:49 PM, Michael Shulman <shulman(at)mathcamp(dot)org> wrote:
> The Postgres manual:
> http://www.postgresql.org/docs/8.3/static/rules-triggers.html
> says "a trigger that is fired on INSERT on a view can do the same as
> a rule: put the data somewhere else and suppress the insert in the
> view." So what do I need to do to make an INSERT trigger on a view?
This quote from the manual implies to me that it is possible to make a
trigger fire on INSERT on a view. But postgres won't let me do this,
and some things I've read elsewhere on the Internet imply that it is
impossible. Is the manual wrong? Or am I reading it wrong? Or is it
possible to make a trigger fire on INSERT on a view?
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2008-06-19 18:03:10 | Re: Losing data |
Previous Message | Garry Saddington | 2008-06-19 18:00:12 | Re: Losing data |