Re: too many trigger records found for relation "item" - - Mailing list pgsql-general

From Tom Lane
Subject Re: too many trigger records found for relation "item" -
Date
Msg-id 18331.1169563428@sss.pgh.pa.us
Whole thread Raw
In response to Re: too many trigger records found for relation "item" -  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: too many trigger records found for relation "item" -
List pgsql-general
Csaba Nagy <nagy@ecircle-ag.com> writes:
> The responsible code is in src/backend/commands/trigger.c, and I
> think it only happens if you manage to create/drop a new trigger (which
> also could be a FK trigger created by a new foreign key referencing that
> table, as in our case) exactly between that code gets the count of the
> triggers and processes them.

All such code takes exclusive lock on the table, so the above
explanation is impossible.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Regular expressions and arrays and ANY() question
Next
From: "Erick Papadakis"
Date:
Subject: Re: Installing PostgreSQL under Cpanel