On Mon, Mar 17, 2003 at 02:41:29PM -0500, Tom Lane wrote:
>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.
Ah, yeah, that seems to work exactly as expected. At least, my tests
now pass successfully after c
Sean Reifschneider <[EMAIL PROTECTED]> 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 everyt
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...
