Re: Problem with trigger makes Detail record be invalid - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Problem with trigger makes Detail record be invalid
Date
Msg-id f2690c11-37df-7f00-de44-5500fc30a950@aklaver.com
Whole thread Raw
In response to Re: Problem with trigger makes Detail record be invalid  (PegoraroF10 <marcos@f10.com.br>)
List pgsql-general
On 04/19/2018 11:30 AM, PegoraroF10 wrote:
> I know my trigger is incorrect. I know that I can use TG_OP to know what
> operation is being done.
> My question is ...
>> Is this a bug or it´s mine responsability to check that trigger result ?
> 
> I think it´s a bug because if something got wrong on detail deletion and it
> was rolled back, how could be a parent record be deleted ?

Another thought, are there are any other triggers on the Master and/or 
Detail tables?

> 
> 
> 
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Problem with trigger makes Detail record be invalid
Next
From: Edmundo Robles
Date:
Subject: Re: Doubts about replication..