Re: "too many trigger records found for relation xyz"

From: "Mikko Partio" <mpartio(at)gmail(dot)com>
To: "Zdenek Kotala" <Zdenek(dot)Kotala(at)sun(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: "too many trigger records found for relation xyz"
Date: 2008-04-08 14:26:14
Message-ID: 2ca799770804080726i2e500845s5d8f984425e4ff5e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 8, 2008 at 1:45 PM, Zdenek Kotala <Zdenek(dot)Kotala(at)sun(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mikko Partio 2008-04-08 14:38:46 Re: "too many trigger records found for relation xyz"
Previous Message Simone Brunozzi 2008-04-08 14:15:24 Re: Postgresql Conferences/events in Europe?