Re: triggers and inheritance tree - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: triggers and inheritance tree
Date
Msg-id CAJKUy5gNAacSkfE4N29yzBitbN_5eV4tfdeEx3Uu231eDp5M+Q@mail.gmail.com
Whole thread Raw
In response to triggers and inheritance tree  (Jaime Casanova <jaime@2ndquadrant.com>)
Responses Re: triggers and inheritance tree
List pgsql-hackers
On Wed, Mar 28, 2012 at 1:21 AM, Jaime Casanova <jaime@2ndquadrant.com> wrote:
> Hi,
>
> i was trying to create triggers that redirect INSERT/UPDATE/DELETE
> actions from parent to childs, but found that UPDATE/DELETE doesn't
> get redirected. Actually, the triggers BEFORE UPDATE and BEFORE DELETE
> aren't even fired.
>

and of course, it has nothing to do with the inheritance tree. that
was just a coincidence.

the problem occurs the same with normal tables, but i can't find where
is the problem.
i suspect, though, that is in the comparison in TRIGGER_TYPE_MATCHES

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación


pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: Re: [COMMITTERS] pgsql: pg_test_timing utility, to measure clock monotonicity and timing
Next
From: Robert Haas
Date:
Subject: Re: triggers and inheritance tree