Search Postgresql Archives
inherting triggers
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-general@xxxxxxxxxxxxxx
- Subject: inherting triggers
- From: Joseph S <jks@xxxxxxxxxxxxxxx>
- Date: Wed, 25 Jul 2007 20:39:01 -0400
- Organization: Hub.Org Networking Services
- User-agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.12) Gecko/20070604 Thunderbird/1.5.0.12 Mnenhy/0.7.4.0
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?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]