Re: Numbers of entries in pg_trigger - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Numbers of entries in pg_trigger
Date
Msg-id 20011120125525.L58888-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Numbers of entries in pg_trigger  ("Jeff Boes" <jboes@nexcerpt.com>)
List pgsql-admin
On Tue, 20 Nov 2001, Jeff Boes wrote:

> Does anyone have a pointer to info on what kinds of things cause entries
> in pg_trigger?  We're trying to understand why some tables have a
> half-dozen corresponding entries, and some have 30.

With that many I'd guess foreign keys.  Each fk constraint adds 1 trigger
to the referencing table and 2 to the referenced table if I remember
right.



pgsql-admin by date:

Previous
From: "Jeff Boes"
Date:
Subject: Numbers of entries in pg_trigger
Next
From: "Andrew G. Hammond"
Date:
Subject: Re: grant access