Skip site navigation (1) Skip section navigation (2)

Re: maximum number of triggers on a table?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: Derek Spencer <derek(at)spencerogne(dot)com>,pgsql-general(at)postgresql(dot)org
Subject: Re: maximum number of triggers on a table?
Date: 2002-10-30 18:39:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
>> 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.

I'm wondering if the ALTER is waiting to acquire lock on the referenced
table (it will need exclusive lock to add the trigger).  If some open
transaction has used the referenced table and is now sitting around
without committing, it would cause the above behavior.

			regards, tom lane

In response to

pgsql-general by date

Next:From: st_mwilsonDate: 2002-10-30 18:41:21
Subject: Oracle 8.1.x to Postgresql Conversion.
Previous:From: Medi MontaseriDate: 2002-10-30 18:35:59
Subject: Re: Stream data into Postgres via Perl

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group