inherting triggers - Mailing list pgsql-general

From Joseph S
Subject inherting triggers
Date
Msg-id f88qet$1210$1@news.hub.org
Whole thread Raw
List pgsql-general
I am planning on segmenting one of my large tables into many child
tables using "CREATE TABLE ... INHERITS (parent)", but I want all the
triggers on my parent table to also fire on UPDATE/INSERT/DELETE on my
child table.  As far as I can tell, there is no way to do this with the
CREATE TABLE command.  Can I just duplicate the rows in pg_trigger but
change the tgrelid to the new child?

pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: using Tsearch2 for chemical text
Next
From: Joseph S
Date:
Subject: Re: upgrade to 8.2.? or implement Slony, which first?