views:

317

answers:

1

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