Re: Numbers of entries in pg_trigger

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Jeff Boes <jboes(at)nexcerpt(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Numbers of entries in pg_trigger
Date: 2001-11-20 20:56:42
Message-ID: 20011120125525.L58888-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew G. Hammond 2001-11-20 21:24:51 Re: grant access
Previous Message Jeff Boes 2001-11-20 20:21:53 Numbers of entries in pg_trigger