Mikko Partio napsal(a):
On Tue, Apr 8, 2008 at 5:26 PM, Mikko Partio <mpartio@xxxxxxxxx> 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.
It is really strange. It would be nice to have reproduce scenario. Can you run
same DDL command which invoke a catalog corruption on test database cluster?
Zdenek
