Skip site navigation (1)
Skip section navigation (2)
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?
Peripheral Links
Header And Logo
|
Site Navigation
inherting triggers
- From: Joseph S <jks(at)selectacast(dot)net>
- To: pgsql-general(at)postgresql(dot)org
- Subject: inherting triggers
- Date: Wed, 25 Jul 2007 20:39:01 -0400
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?
- Prev by Date: Re: using Tsearch2 for chemical text
- Next by Date: Re: upgrade to 8.2.? or implement Slony, which first?
- Previous by thread: using Tsearch2 for chemical text
- Next by thread: C.H.E.A.P...M.A.R.L.B.O.R.O...C.I.G.A.R.E.T.T.E.S.... ==== CEZukcY5
- Indexes: