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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lenorovitz, Joel" <Joel(dot)Lenorovitz(at)usap(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: too many trigger records found for relation "item" - what's that about??
Date: 2007-01-23 05:45:50
Message-ID: 10482.1169531150@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Lenorovitz, Joel" <Joel(dot)Lenorovitz(at)usap(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-01-23 05:59:38 Re: Regular expressions and arrays and ANY() question
Previous Message Tom Lane 2007-01-23 05:33:37 Re: Tracking database activity