Thread: 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
deletesoccur on the table.  Prior to 7.3, delete would report the update count, but as of 7.3, delete reports 0 rows
weredeleted. 

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
deletesoccur on the table.  Prior to 7.3, delete would report the update count, but as of 7.3, delete reports 0 rows
weredeleted. 

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