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:38:46
Message-ID: 2ca799770804080738i7b653285l9889667b79ac4ee5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 8, 2008 at 5:26 PM, Mikko Partio <mpartio(at)gmail(dot)com> wrote:

>
> 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?
>
>

I managed to solve the situation with the help of this thread:
http://archives.postgresql.org/pgsql-bugs/2007-02/msg00167.php

Everything seems to be ok for now, but I'm still curious what caused to
whole mess to begin with.

Thanks a lot for your help again.

Regards

Mikko

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mljv 2008-04-08 14:57:26 Problem after VACUUM ANALYZE
Previous Message Mikko Partio 2008-04-08 14:26:14 Re: "too many trigger records found for relation xyz"