Received: from mail.math.TU-Berlin.DE (mail.math.TU-Berlin.DE [130.149.12.212]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0NEhRl32537 for ; Wed, 23 Jan 2002 09:43:27 -0500 (EST) (envelope-from lehmannf@math.TU-Berlin.DE) Received: from math.tu-berlin.de (methusalix.math.TU-Berlin.DE [130.149.13.129]) by mail.math.TU-Berlin.DE (8.12.0.Beta10/8.12.0.Beta10) with ESMTP id g0NEhR7N016655 for ; Wed, 23 Jan 2002 15:43:27 +0100 (MET) Message-ID: <3C4ECC12.A78DCE45@math.tu-berlin.de> Date: Wed, 23 Jan 2002 15:43:30 +0100 From: Fritz Lehmann-Grube X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.4-4GB i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql Subject: ERROR (Bug?) in RULE processing ? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200201/261 X-Sequence-Number: 6345 Can somebody tell what this errormessage means ? ERROR: fireRIRrules: failed to remove aggs from qual I don't know what "aggs" and "qual" is. What I did: arbeitsdb=# select id,type,subtype,name from documents; id | type | subtype | name ----+------+---------+--------------- 1 | 1 | 5 | motiv_el_01 2 | 1 | 1 | def_el_01 3 | 2 | 10 | deduc_el_01 4 | 2 | 18 | example_el_01 (4 rows) arbeitsdb=# insert into documents(type,subtype,name) arbeitsdb-# values (2,16,'foo'); INSERT 55505 1 arbeitsdb=# delete from documents where oid=55505; DELETE 1 arbeitsdb=# CREATE RULE doc_contained AS ON INSERT TO documents WHERE arbeitsdb-# ((NEW.type = 1) AND (count( (SELECT element_id arbeitsdb(# FROM element_contained_in WHERE (element_id = currval('docs_seq')) )) = 0)) arbeitsdb-# DO INSTEAD NOTHING; CREATE arbeitsdb=# insert into documents(type,subtype,name) arbeitsdb-# values (2,16,'foo'); ERROR: fireRIRrules: failed to remove aggs from qual Thanks Fritz