Postgres Pro
Downloads
Home   >   mailing lists

triggers and inheritance tree - Mailing list pgsql-hackers

From Jaime Casanova
Subject triggers and inheritance tree
Date
Msg-id CAJKUy5gsiregGt8-y8qch4RLkyN4OUuC8=t=MDLA+y3a2RDQOg@mail.gmail.com
Whole thread Raw
Responses Re: triggers and inheritance tree  (Jaime Casanova <jaime@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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.

I haven't tried with AFTER triggers to see if they are fired but i
tried on 8.4 to 9.1 and all of these have the same behaviour

attached is a simple contained test of this

PS: i'm hoping this is just me needed to sleep

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

pgsql-hackers by date:

Previous
From: Ants Aasma
Date:
Subject: [PATCH] Lazy hashaggregate when no aggregation is needed
Next
From: Thom Brown
Date:
Subject: Re: pgsql_fdw, FDW for PostgreSQL server