Re: WIP fix proposal for bug #6123

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Robert Haas" <robertmhaas@gmail.com>
Cc: <pgsql-hackers@postgresql.org>
Date: 2011-07-22T21:51:49Z
Lists: pgsql-hackers

Attachments

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote:
 
> I believe that we can get DELETE behavior which is every bit as
> sensible as INSERT behavior with a very small change.
 
> I think the right thing is to throw an error if the old row for a
> BEFORE UPDATE is updated by the same transaction and the trigger
> function ultimately returns a non-NULL value.
 
And to make this a bit less hand-wavy, a rough patch attached.  I
expect the error message could use some word-smithing, and it could
use comments; but it seemed like something concrete might speed
things along.
 
-Kevin