Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 16D9E6506DD for ; Mon, 14 Jul 2008 23:42:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46674-07 for ; Mon, 14 Jul 2008 23:42:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vms046pub.verizon.net (vms046pub.verizon.net [206.46.252.46]) by postgresql.org (Postfix) with ESMTP id 5EE576506DA for ; Mon, 14 Jul 2008 23:42:21 -0300 (ADT) Received: from ridley.home ([71.179.5.175]) by vms046.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0K41001XS0U8UJ26@vms046.mailsrvcs.net> for pgsql-docs@postgresql.org; Mon, 14 Jul 2008 21:42:08 -0500 (CDT) Date: Mon, 14 Jul 2008 22:42:04 -0400 From: Robert Treat Subject: triggers on views? To: pgsql-docs@postgresql.org Message-id: <200807142242.06734.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit Content-disposition: inline User-Agent: KMail/1.9.9 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/4 X-Sequence-Number: 4935 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