Bug #832: delete rule reports 0 modifications
Dustin Sallings (dustin+pgsqlbugs@spy.net) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
delete rule reports 0 modifications
Long Description
I have a table that has a delete rule that performs a logical delete (set a ``deleted'' column to true) whenever deletes occur on the table. Prior to 7.3, delete would report the update count, but as of 7.3, delete reports 0 rows were deleted.
Sample Code
No file was uploaded with this report
pgsql-bugs@postgresql.org writes:
I have a table that has a delete rule that performs a logical delete (set a ``deleted'' column to true) whenever deletes occur on the table. Prior to 7.3, delete would report the update count, but as of 7.3, delete reports 0 rows were deleted.
We did rejigger the status reporting rules (again) in 7.3, but only
after extensive discussion; it's unlikely anyone will be eager to
revisit the issue yet again. The 7.3 behavior is documented at
http://developer.postgresql.org/docs/postgres/rules-status.html
regards, tom lane