Fritz Lehmann-Grube <lehmannf(at)math(dot)TU-Berlin(dot)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