| From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | triggers and inheritance tree |
| Date: | 2012-03-28 06:21:26 |
| Message-ID: | CAJKUy5gsiregGt8-y8qch4RLkyN4OUuC8=t=MDLA+y3a2RDQOg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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 | Content-Type | Size |
|---|---|---|
| test.sql | text/x-sql | 1.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2012-03-28 07:13:29 | Re: pgsql_fdw, FDW for PostgreSQL server |
| Previous Message | Ants Aasma | 2012-03-28 02:37:25 | [PATCH] Lazy hashaggregate when no aggregation is needed |