Re: Problem with RULE to update tables

Sean Reifschneider <jafo@tummy.com> writes:
> I've tried this on both 7.3 and 7.2.3, and am running into an odd
> problem.  Basically I have one table that is a count of available and one
> that has allocations against that.  I wanted to use rules to auto-update the
> available count, and everything works fine as long as I do deletes
> one-by-one...

> If I delete multiple records, the available count is only updated once.

Yup.  A rule is invoked once per query, not once per operated-on record.
You'll find that a trigger acts more like what you are expecting.

            regards, tom lane