*** ./doc/src/sgml/ref/alter_table.sgml.orig 2010-06-06 09:16:34.000000000 +0100 --- ./doc/src/sgml/ref/alter_table.sgml 2010-06-06 09:49:00.000000000 +0100 *************** *** 250,257 **** status is checked when the event occurs, not when the trigger function is actually executed. One can disable or enable a single trigger specified by name, or all triggers on the table, or only ! user triggers (this option excludes triggers that are used to implement ! foreign key constraints). Disabling or enabling constraint triggers requires superuser privileges; it should be done with caution since of course the integrity of the constraint cannot be guaranteed if the triggers are not executed. --- 250,259 ---- status is checked when the event occurs, not when the trigger function is actually executed. One can disable or enable a single trigger specified by name, or all triggers on the table, or only ! user triggers (this option excludes internally generated constraint ! triggers such as those that are used to implement foreign key ! constraints or deferrable uniqueness and exclusion constraints). ! Disabling or enabling internally generated constraint triggers requires superuser privileges; it should be done with caution since of course the integrity of the constraint cannot be guaranteed if the triggers are not executed. *************** *** 585,592 **** Disable or enable all triggers belonging to the table. ! (This requires superuser privilege if any of the triggers are for ! foreign key constraints.) --- 587,596 ---- Disable or enable all triggers belonging to the table. ! (This requires superuser privilege if any of the triggers are ! internally generated constraint triggers such as those that are used ! to implement foreign key constraints or deferrable uniqueness and ! exclusion constraints.) *************** *** 596,602 **** Disable or enable all triggers belonging to the table except for ! foreign key constraint triggers. --- 600,608 ---- Disable or enable all triggers belonging to the table except for ! internally generated constraint triggers such as those that are used ! to implement foreign key constraints or deferrable uniqueness and ! exclusion constraints.