Bruce Badger <bbadger@BadgerSE.com> writes:
> My question is: which is "right" the 7.1 behavior, or the 7.2 behavior?
Hmm ... I'd opine that neither is "right"; the correct behavior would
be that you should see no trace of the background INSERT generated
by the rule, only of the UPDATE you actually issued.
7.2 seems to be suppressing the INSERT's completion response correctly,
but not the CursorResponse.
I *think* this might be fixed in current sources, but not sure. Also,
there is an open question whether we really like this behavior at all.
I'd be interested to see your take on the thread "Queries using rules
show no rows modified?" from mid-May in pgsql-hackers. (I'd give a
better URL if archive searching weren't currently broken for non-IE
browsers.)
regards, tom lane