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

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

Konstantin Nikiforov <helllamer(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message daniel 2010-12-03 17:48:26 pgcrypto bug or my brain?
Previous Message Heikki Linnakangas 2010-12-03 15:53:15 Re: