From: Frank Joerdens <frank@joerdens.de>
To: pgsql-sql@postgresql.org
Subject: Re: Rule trouble (looks to me exactly like the example)
Date: Fri, 5 Apr 2002 12:08:51 +0200
Message-ID: <20020405120851.D30469@superfly.archi-me-des.de> (raw)
In-Reply-To: <25306.1017948553@sss.pgh.pa.us>
References: <20020404191719.C30469@superfly.archi-me-des.de>
<25306.1017948553@sss.pgh.pa.us>
On Thu, Apr 04, 2002 at 02:29:13PM -0500, Tom Lane wrote:
> 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 ...
Without the WHERE condition, all rows are affected by the update, and
not just the newly inserted one.
Regards, Frank
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: frank@joerdens.de
Subject: Re: Rule trouble (looks to me exactly like the example)
In-Reply-To: <20020405120851.D30469@superfly.archi-me-des.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