Re: maximum number of triggers on a table?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Derek Spencer <derek(at)spencerogne(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: maximum number of triggers on a table?
Date: 2002-10-30 16:08:12
Message-ID: 20021030080722.X31345-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message juleni 2002-10-30 16:27:38 PROBLEM with inserting a duplicate key into unique index ...
Previous Message Eckhardt Kiwitt 2002-10-30 16:06:57 Inquiry From Form [pgsql]