Re: Bug #832: delete rule reports 0 modifications

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dustin+pgsqlbugs(at)spy(dot)net, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #832: delete rule reports 0 modifications
Date: 2002-12-01 23:31:11
Message-ID: 2604.1038785471@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-12-01 23:42:20 Re: initdb and OSX why must I --no-locale
Previous Message Tom Lane 2002-12-01 23:09:26 Re: Bug #830: 7.3 - timespan missing?