Re: Numbers of entries in pg_trigger

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Numbers of entries in pg_trigger
Дата
Msg-id 20011120125525.L58888-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Numbers of entries in pg_trigger  ("Jeff Boes" <jboes@nexcerpt.com>)
Список 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 по дате отправления:

Предыдущее
От: "Jeff Boes"
Дата:
Сообщение: Numbers of entries in pg_trigger
Следующее
От: "Andrew G. Hammond"
Дата:
Сообщение: Re: grant access