"Brendan Jurd" <[EMAIL PROTECTED]> writes: > My first impulse was to just append a " (disabled)" after each > disabled trigger, but perhaps that is not visually obvious enough, > especially if the table has many triggers on it.
Agreed, but maybe put it up at the front? Triggers: y AFTER DELETE ON x FOR EACH ROW EXECUTE PROCEDURE do_something() z (disabled) BEFORE INSERT ON x FOR EACH ROW EXECUTE PROCEDURE input_stuff() regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match