Re: maximum number of triggers on a table?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: maximum number of triggers on a table?
Дата
Msg-id 20021030080722.X31345-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на maximum number of triggers on a table?  (derek@spencerogne.com (Derek Spencer))
Ответы Re: maximum number of triggers on a table?
Список pgsql-general
On 29 Oct 2002, Derek Spencer wrote:

> Does Postgresql have a limit on the number of triggers that can exist
> on any given table?  We're using v7.2.3.
>
> I have a table with 36 triggers and upon adding another trigger
> (really a foreign key reference) the alter table query hangs and
> doesn't return...

I don't know of a trigger limit, but does this table have data in it?
It's possible that the alter table is being slow in checking the initial
state of the constraint.



В списке pgsql-general по дате отправления:

Предыдущее
От:
Дата:
Сообщение: backing up corrupt database
Следующее
От: juleni
Дата:
Сообщение: PROBLEM with inserting a duplicate key into unique index ...