Re: Triggers

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Mihai Gheorghiu <tanethq(at)earthlink(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Triggers
Date: 2001-10-26 18:28:13
Message-ID: Pine.BSF.4.21.0110261126380.66638-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

  • Triggers at 2001-10-26 14:35:30 from Mihai Gheorghiu

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2001-10-26 18:31:16 Re: GUID in postgres
Previous Message Roderick A. Anderson 2001-10-26 18:19:37 Re: DBD::Pg