<!--

$PostgreSQL: pgsql/doc/src/sgml/ref/create_constraint.sgml,v 1.15 2006/10/16 19:30:09 momjian Exp $

$PostgreSQL: pgsql/doc/src/sgml/ref/create_constraint.sgml,v 1.16 2006/10/16 19:33:12 momjian Exp $

PostgreSQL documentation

-->

AFTER <replaceable class="parameter">event [ OR ... ]</replaceable>

ON <replaceable class="parameter">table_name</replaceable>

[ FROM <replaceable class="parameter">referenced_table_name</replaceable> ]

{ NOT DEFERRABLE | [DEFERABBLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } }

{ NOT DEFERRABLE | [DEFERRABLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } }

FOR EACH ROW

EXECUTE PROCEDURE <replaceable class="parameter">funcname</replaceable> ( <replaceable class="parameter">arguments</replaceable> )

</synopsis>

created trigger will be of the form

<literal>RI_ConstraintTrigger_0000<literal> (where 0000 is some number

assigned by the server).

Use this assigned nameiswhen dropping theconstraint.

Use this assigned name when dropping thetrigger.

</para>

</listitem>

</varlistentry>