Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
Date
Msg-id 5769.1311111047@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
List pgsql-bugs
Tree view 
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> [ circular trigger relationships ]

> I expect the DELETE from a to delete related b record(s) and then succeed.
> Instead the UPDATE in b_del_trig causes delete of a to silently fail.

The update causes the already-selected target row version of the DELETE
to be obsoleted, so heap_delete finds it has nothing to do.  I'm
disinclined to mess with that logic.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE