pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Fritz Lehmann-Grube <lehmannf@math.TU-Berlin.DE>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: ERROR (Bug?) in RULE processing ?
Date: Wed, 23 Jan 2002 15:43:30 +0100
Message-ID: <3C4ECC12.A78DCE45@math.tu-berlin.de> (raw)


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



view thread (4+ messages)  latest in thread

Message-ID: <3C4ECC12.A78DCE45@math.tu-berlin.de>
Permalink:  ../3C4ECC12.A78DCE45@math.tu-berlin.de/
Also on:    postgresql.org/message-id/3C4ECC12.A78DCE45@math.tu-berlin.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: lehmannf@math.TU-Berlin.DE
  Subject: Re: ERROR (Bug?) in RULE processing ?
  In-Reply-To: <3C4ECC12.A78DCE45@math.tu-berlin.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox