Hello,
while there have been suggested some hacks on the system catalog
for disabling/enabling triggers, these have two serious disadvantages:
- they cannot be done by the owner of the trigger
(only the DBA has write access to the system catalog)
- messing in the system catalog for simple DB schema changes makes
most users feel uneasy
Oracle has an SQL command "ALTER TRIGGER triggername DISABLE|ENABLE".
Were it possible to put this command on the TODO list for a future PG release?
Thanks,
Christoph Dalitz