11<!--
2- $PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.113 2010/05/13 18:54:18 tgl Exp $
2+ $PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.114 2010/06/09 17:48:10 alvherre Exp $
33PostgreSQL documentation
44-->
55
@@ -250,8 +250,10 @@ ALTER TABLE <replaceable class="PARAMETER">name</replaceable>
250250 status is checked when the event occurs, not when the trigger function
251251 is actually executed. One can disable or enable a single
252252 trigger specified by name, or all triggers on the table, or only
253- user triggers (this option excludes triggers that are used to implement
254- foreign key constraints). Disabling or enabling constraint triggers
253+ user triggers (this option excludes internally generated constraint
254+ triggers such as those that are used to implement foreign key
255+ constraints or deferrable uniqueness and exclusion constraints).
256+ Disabling or enabling internally generated constraint triggers
255257 requires superuser privileges; it should be done with caution since
256258 of course the integrity of the constraint cannot be guaranteed if the
257259 triggers are not executed.
@@ -585,8 +587,10 @@ ALTER TABLE <replaceable class="PARAMETER">name</replaceable>
585587 <listitem>
586588 <para>
587589 Disable or enable all triggers belonging to the table.
588- (This requires superuser privilege if any of the triggers are for
589- foreign key constraints.)
590+ (This requires superuser privilege if any of the triggers are
591+ internally generated constraint triggers such as those that are used
592+ to implement foreign key constraints or deferrable uniqueness and
593+ exclusion constraints.)
590594 </para>
591595 </listitem>
592596 </varlistentry>
@@ -596,7 +600,9 @@ ALTER TABLE <replaceable class="PARAMETER">name</replaceable>
596600 <listitem>
597601 <para>
598602 Disable or enable all triggers belonging to the table except for
599- foreign key constraint triggers.
603+ internally generated constraint triggers such as those that are used
604+ to implement foreign key constraints or deferrable uniqueness and
605+ exclusion constraints.
600606 </para>
601607 </listitem>
602608 </varlistentry>