Обсуждение: inherting triggers

Поиск
Список
Период
Сортировка

inherting triggers

От
Joseph S
Дата:
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?