Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored - Mailing list pgsql-bugs

From Konstantin Nikiforov
Subject Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored
Date
Msg-id 20101203103547.48943eea@avers
Whole thread Raw
In response to Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.
>=20
> 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".
=20
This behaviour conflicts with:

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

pgsql-bugs by date:

Previous
From: Konstantin Nikiforov
Date:
Subject: Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: Problems with max_connections parameter