pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jan Wieck <janwieck@yahoo.com>
To: Fritz Lehmann-Grube <lehmannf@math.TU-Berlin.DE>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: ERROR (Bug?) in RULE processing ?
Date: Wed, 23 Jan 2002 11:06:09 -0500 (EST)
Message-ID: <200201231606.g0NG69n14924@saturn.janwieck.net> (raw)
In-Reply-To: <3C4ECC12.A78DCE45@math.tu-berlin.de>

Fritz Lehmann-Grube wrote:
>
> Can somebody tell what this errormessage means ?
> ERROR:  fireRIRrules: failed to remove aggs from qual
>
> I don't know what "aggs" and "qual" is.

    The  rewrite  rule  system  was not able to combine the given
    rule into your insert statement,  because  aggregate  clauses
    (count()  here)  in the qualification (WHERE ...) are in fact
    impossible.

    Your best bet it to implement that with a trigger.


Jan

>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>


--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




view thread (4+ messages)  latest in thread

Message-ID: <200201231606.g0NG69n14924@saturn.janwieck.net>
Permalink:  ../200201231606.g0NG69n14924@saturn.janwieck.net/
Also on:    postgresql.org/message-id/200201231606.g0NG69n14924@saturn.janwieck.net

 · 

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: janwieck@yahoo.com, lehmannf@math.TU-Berlin.DE
  Subject: Re: ERROR (Bug?) in RULE processing ?
  In-Reply-To: <200201231606.g0NG69n14924@saturn.janwieck.net>

* 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