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

From Tom Lane
Subject Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored
Date
Msg-id 26429.1291391875@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored  (Konstantin Nikiforov <helllamer@gmail.com>)
List pgsql-bugs
Konstantin Nikiforov <helllamer@gmail.com> writes:
> Also another bug and usecase connected with subj.
> It creates parent table "xtest", inherited table "xtest_inh" with
> some data, and a trigger BEFORE INSERT/UPDATE/DELETE on table "xtest".
> After, it deletes one row.

I think you fundamentally misunderstand how triggers on inherited tables
work.  A row-level trigger is fired for events on rows *in its table*.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re:
Next
From: daniel
Date:
Subject: pgcrypto bug or my brain?