Re: Rule trouble (looks to me exactly like the example)

Frank Joerdens <frank@joerdens.de> writes:
>> 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.

I was speaking of the WHERE new.id > 0 part.  However, given that you
want to affect only the newly-inserted row, ISTM you'd be a lot better
off with a trigger instead of a rule.
        regards, tom lane