triggers are not shared between parent and child tables?

From: Rural Hunter <ruralhunter(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: triggers are not shared between parent and child tables?
Date: 2012-03-12 03:06:04
Message-ID: 4F5D681C.7080006@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I implemented table partition recently and found that the tiggers on
parent table are not working any more, except the before insert trigger
which redirects data to children table. The after insert/update triggers
are not working now. I understand the after insert trigger may not
working since the before insert trigger redirects inserts to children
table and returns null. But why the update triggers are also not
working? I googled and found this
article(http://www.peachpit.com/articles/article.aspx?p=31206&seqNum=3)
mentions "triggers are not shared between parent and child tables". is
it true? Maybe I overlooked but somehow I didn't find this in partition
part of postgresql
doc(http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html).

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Piyush Lenka 2012-03-12 04:23:01 How to back up selected rows using
Previous Message David Kerr 2012-03-11 22:20:10 Re: Looking for help on backing up a large database (500GB+) with LOBs