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

["Mikko Partio" <mpartio@xxxxxxxxx>]

On Tue, Apr 8, 2008 at 1:45 PM, Zdenek Kotala <Zdenek.Kotala@xxxxxxx> 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