Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored

From: Konstantin Nikiforov <helllamer(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored
Date: 2010-12-03 07:35:47
Message-ID: 20101203103547.48943eea@avers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Ok, thanks, roger you.
But one question still cause my misunderstanding:
> > 2. If i create trigger FOR EACH STATEMENT, it will work ok for
> > insert, update and delete.
>
> You mean FOR EACH ROW, no?

Yes, confused. FOR EACH ROW.

"FOR EACH ROW"-trigger successfully fires in inherited
table "xtest_inh", then we deleteting row from PARENT table "xtest".

This behaviour conflicts with:

> So the designed behavior is
> that only the named target table has its statement triggers fired.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Konstantin Nikiforov 2010-12-03 08:16:12 Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored
Previous Message Tom Lane 2010-12-03 04:50:06 Re: BUG #5781: unaccent() function should be marked IMMUTABLE