Postgres Pro
Downloads
Home   >   mailing lists

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

From Mikko Partio
Subject Re: "too many trigger records found for relation xyz"
Date
Msg-id 2ca799770804080726i2e500845s5d8f984425e4ff5e@mail.gmail.com
Whole thread Raw
In response to Re: "too many trigger records found for relation xyz"  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Responses Re: "too many trigger records found for relation xyz"  ("Mikko Partio" <mpartio@gmail.com>)
List pgsql-general
Tree view


On Tue, Apr 8, 2008 at 1:45 PM, Zdenek Kotala <Zdenek.Kotala@sun.com> wrote:
Mikko Partio napsal(a):


Should I try remove one of the duplicate rows from pg_class?

Try it with caution. You should use ctid column to refer to exact row.



Ok I removed the faulty tuple and nothing catastrophical happened. I can do a pg_dump now, but I still can't remove the one remaining table:

# drop table xyz ;
ERROR:  too many trigger records found for relation "xyz"

Any insight for this problem?

Regards

Mikko

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: dirty select
Next
From: "Mikko Partio"
Date:
Subject: Re: "too many trigger records found for relation xyz"