| [Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] |
"Plugge, Joe R." <JRPlugge@xxxxxxxx> wrote: > Using postgres 9.0.7 on RHEL 5.4. I have a parent table that is > partitioned by day. My inserts are working correctly and are > being directed to the correct child table. I also have both an > UPDATE and DELETE trigger on the parent table that are defined as > AFTER triggers. The actual update and delete operation works, > however the triggers do not seem to be firing. What am I doing > wrong? The DELETE and UPDATE triggers need to be on the child tables. An operation on a child doesn't fire the triggers of the parent. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite]