From: Tom Lane <tgl@sss.pgh.pa.us>
To: Frank Joerdens <frank@joerdens.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Rule trouble (looks to me exactly like the example)
Date: Thu, 04 Apr 2002 14:29:13 -0500
Message-ID: <25306.1017948553@sss.pgh.pa.us> (raw)
In-Reply-To: <20020404191719.C30469@superfly.archi-me-des.de>
References: <20020404191719.C30469@superfly.archi-me-des.de>
Frank Joerdens <frank@joerdens.de> writes:
> And here's the rule (it doesn't do anything real or interesting, I just
> simplified it to the point where it looked like the example):
> CREATE RULE insert_level AS
> ON INSERT TO tree
> WHERE new.id > 0 DO
> UPDATE tree SET leveling = 1
> WHERE tree.oid = new.oid;
What's happening is that "new.id" is effectively still NULL at the point
where the rule is processed, so the rule WHERE condition fails. I'm not
sure why you're bothering with that WHERE condition anyway ... but this
seems to be another argument for moving INSERT's default-value-insertion
step to before the rule rewriter. (There was some discussion of this
point just a few days ago, IIRC.)
regards, tom lane
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: tgl@sss.pgh.pa.us, frank@joerdens.de
Subject: Re: Rule trouble (looks to me exactly like the example)
In-Reply-To: <25306.1017948553@sss.pgh.pa.us>
* 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