Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0NG1ul73569 for ; Wed, 23 Jan 2002 11:01:56 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g0NG0Sf02802; Wed, 23 Jan 2002 11:00:28 -0500 (EST) To: Fritz Lehmann-Grube cc: pgsql-sql Subject: Re: ERROR (Bug?) in RULE processing ? In-reply-to: <3C4ECC12.A78DCE45@math.tu-berlin.de> References: <3C4ECC12.A78DCE45@math.tu-berlin.de> Comments: In-reply-to Fritz Lehmann-Grube message dated "Wed, 23 Jan 2002 15:43:30 +0100" Date: Wed, 23 Jan 2002 11:00:28 -0500 Message-ID: <2799.1011801628@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200201/264 X-Sequence-Number: 6348 Fritz Lehmann-Grube writes: > Can somebody tell what this errormessage means ? > ERROR: fireRIRrules: failed to remove aggs from qual The reason it's such an unfriendly error message is that it's an internal "shouldn't ever happen" check. What you actually did wrong was to use an aggregate function (count()) in the rule's WHERE clause. This should have been rejected much further upstream, like when you tried to create the rule. That error test doesn't seem to be there now though :-( regards, tom lane