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@users.sourceforge.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@users.sourceforge.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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +