X-Original-To: pgsql-docs@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 84DC84760E3 for ; Mon, 14 Apr 2003 00:11:28 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id E4C4F47580B for ; Mon, 14 Apr 2003 00:11:25 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h3E4Bt2L001757; Mon, 14 Apr 2003 00:11:55 -0400 (EDT) To: Sean Reifschneider Cc: pgsql-docs@postgresql.org, Jan Wieck Subject: Re: Docs patch to note that rules only get run once per query. In-reply-to: <20030414035829.GI7507@tummy.com> References: <20030413234349.GF7507@tummy.com> <1569.1050292052@sss.pgh.pa.us> <20030414035829.GI7507@tummy.com> Comments: In-reply-to Sean Reifschneider message dated "Sun, 13 Apr 2003 21:58:29 -0600" Date: Mon, 14 Apr 2003 00:11:55 -0400 Message-ID: <1756.1050293515@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-32.3 required=5.0 tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/25 X-Sequence-Number: 1751 Sean Reifschneider writes: > On Sun, Apr 13, 2003 at 11:47:32PM -0400, Tom Lane wrote: >> So I feel dissatisfied with the above "clarification". Can you think >> of another way to explain it? > Unfortunately, I really don't understand it... My first thought was > that it was a bug, but when I presented it to the bugs list they said > that the rule only gets executed once per query and that triggers should > be used if you want to run on every impacted row. Well, it could be argued that the present rule behavior is buggy, not because there's anything wrong with it on its own terms, but just because too many people don't understand it :-( Jan, can you offer any words of wisdom here? regards, tom lane