Thread: Triggers

Triggers

From
"Mihai Gheorghiu"
Date:
How can I find and see the code of a trigger automatically generated by a
referential integrity constraint.
Thank you.


Re: Triggers

From
Stephan Szabo
Date:
On Fri, 26 Oct 2001, Mihai Gheorghiu wrote:

> How can I find and see the code of a trigger automatically generated by a
> referential integrity constraint.

You can get the parameters out of pg_trigger (if you've named your
constraint you can use tgconstrname to find them, otherwise you need to
compare items in tgargs).

The code itself is in C and is in src/backend/utils/adt/ri_triggers.c