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

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 (view raw or flat)
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

pgsql-admin by date

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

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