Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
- Cc: pgsql-bugs(at)postgresql(dot)org
- Subject: Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
- Date: Tue, 19 Jul 2011 17:30:47 -0400
- Message-id: <5769.1311111047@sss.pgh.pa.us> <text/plain>
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)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
- Follow-Ups:
- Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
- From: Kevin Grittner
- Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
- References:
- BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
- From: Kevin Grittner
- BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
- Prev by Date: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
- Next by Date: Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
- Previous by thread: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
- Next by thread: Re: BUG #6123: DELETE fails if before trigger causes another trigger to UPDATE
- Indexes: