Re: too many trigger records found for relation "item" - what's that about?? - Mailing list pgsql-general

From Tom Lane
Subject Re: too many trigger records found for relation "item" - what's that about??
Date
Msg-id 10482.1169531150@sss.pgh.pa.us
Whole thread Raw
In response to too many trigger records found for relation "item" - what's that about??  ("Lenorovitz, Joel" <Joel.Lenorovitz@usap.gov>)
List pgsql-general
"Lenorovitz, Joel" <Joel.Lenorovitz@usap.gov> writes:
> postgres=# select * from item;
> ERROR:  too many trigger records found for relation "item"

You could reset the pg_class.reltriggers entry for "item" to be however
many pg_trigger entries there actually are for the table.  I'm curious
how you got into this state though... what PG version is this, and have
you been doing any hand manipulation of triggers?

            regards, tom lane

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Password encryption method
Next
From: Tom Lane
Date:
Subject: Re: Regular expressions and arrays and ANY() question