Re: triggers on views?

We had a doc comment come in noting that the second paragraph seems to be
incorrect on
http://www.postgresql.org/docs/8.3/interactive/rules-triggers.html,
specifically the part that says "On the other hand, a trigger that is fired
on INSERT on a view can do the same as a rule". I'm not sure if this is
supposed to just be taken as a conceptual argument, but it is confusing
because you can't put insert triggers on views... so just what is it getting
at? This exists in several versions back, not sure how folks feel about
updating existing versions, but seems like it could use some rewording...
thoughts?

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> We had a doc comment come in noting that the second paragraph seems to be
> incorrect on
> http://www.postgresql.org/docs/8.3/interactive/rules-triggers.html,
> specifically the part that says "On the other hand, a trigger that is fired
> on INSERT on a view can do the same as a rule".

This was discussed last month:
http://archives.postgresql.org/pgsql-general/2008-06/msg00669.php

regards, tom lane

Tom Lane wrote:
> Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> > We had a doc comment come in noting that the second paragraph seems to be
> > incorrect on
> > http://www.postgresql.org/docs/8.3/interactive/rules-triggers.html,
> > specifically the part that says "On the other hand, a trigger that is fired
> > on INSERT on a view can do the same as a rule".
>
> This was discussed last month:
> http://archives.postgresql.org/pgsql-general/2008-06/msg00669.php

OK, updated wording applied to CVS HEAD; attached.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +