Re: maximum number of triggers on a table?

I don't know of any limit on triggers allowed, and looking at my
development server I have a couple tables with more than 36 (one has
100+) though the majority of this are RI triggers. Can you post the sql
involved?

Robert Treat

On Tue, 2002-10-29 at 18:50, 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 tried to find a reference to this in the documentation or FAQ but
> was not successful.
>
> -Derek
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org