Re: ERROR (Bug?) in RULE processing ? - Mailing list pgsql-sql

From Tom Lane
Subject Re: ERROR (Bug?) in RULE processing ?
Date
Msg-id 2799.1011801628@sss.pgh.pa.us
Whole thread Raw
In response to ERROR (Bug?) in RULE processing ?  (Fritz Lehmann-Grube <lehmannf@math.TU-Berlin.DE>)
Responses Re: ERROR (Bug?) in RULE processing ?
List pgsql-sql
Fritz Lehmann-Grube <lehmannf@math.TU-Berlin.DE> 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


pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: ERROR (Bug?) in RULE processing ?
Next
From: Oleg Lebedev
Date:
Subject: Re: PGACCESS installation