Skip site navigation (1) Skip section navigation (2)

Re: triggers and inheritance tree

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: triggers and inheritance tree
Date: 2012-03-28 13:16:46
Message-ID: CAJKUy5gNAacSkfE4N29yzBitbN_5eV4tfdeEx3Uu231eDp5M+Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Mar 28, 2012 at 1:21 AM, Jaime Casanova <jaime(at)2ndquadrant(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2012-03-28 13:29:22
Subject: Re: triggers and inheritance tree
Previous:From: Marko KreenDate: 2012-03-28 13:13:16
Subject: Re: Re: [COMMITTERS] pgsql: pg_test_timing utility, to measure clock monotonicity and timing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group