Re: maximum number of triggers on a table? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: maximum number of triggers on a table?
Date
Msg-id 20021030080722.X31345-100000@megazone23.bigpanda.com
Whole thread Raw
In response to maximum number of triggers on a table?  (derek@spencerogne.com (Derek Spencer))
Responses Re: maximum number of triggers on a table?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From:
Date:
Subject: backing up corrupt database
Next
From: juleni
Date:
Subject: PROBLEM with inserting a duplicate key into unique index ...