My googling-fu is failing me. How to know if a PostgreSQL trigger is disabled or not?
+2
A:
It's my first day with postresql, but I think you can check the trigger state via pg_trigger system table: http://www.postgresql.org/docs/7.4/static/catalog-pg-trigger.html The columns you will need are tgrelid and tgenabled.
Rafael
2009-04-01 07:32:13