Re: triggers and inheritance tree
Jaime Casanova <jaime@2ndquadrant.com>
From: Jaime Casanova <jaime@2ndquadrant.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-03-28T13:16:46Z
Lists: 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