Re: Problem with trigger makes Detail record be invalid

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: PegoraroF10 <marcos(at)f10(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with trigger makes Detail record be invalid
Date: 2018-04-19 18:44:20
Message-ID: f2690c11-37df-7f00-de44-5500fc30a950@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Edmundo Robles 2018-04-19 18:48:15 Re: Doubts about replication..
Previous Message Adrian Klaver 2018-04-19 18:40:25 Re: Problem with trigger makes Detail record be invalid