"too many trigger records found for relation xyz"

Hello all

Postgres version 8.3.1

I just created a bunch of tables (~10) with identical structure; all tables
have 6 foreign key references to other tables and a primary key. To my
surprise, some of the tables were created ok, some missed primary key and
some didn't get created at all.

Postgres complained:

2008-04-08 08:50:41 EEST [721]: [27-1] ERROR: relation 543058 deleted while
still in use

and

2008-04-08 08:50:41 EEST [721]: [36-1] ERROR: could not find tuple for
relation 54309

and

2008-04-08 08:50:42 EEST [721]: [114-1] ERROR: duplicate key value violates
unique constraint "pg_class_oid_index"

When I tried to remove the tables, the same errors kept coming up

2008-04-08 08:53:15 EEST [27794]: [5-1] ERROR: duplicate key value violates
unique constraint "pg_class_oid_index"
2008-04-08 08:53:15 EEST [27794]: [6-1] STATEMENT: drop table xyz ;

I searched google for a while, and then tried again and this time I was able
to drop all but one of the tables. When I try to drop the one remaining
table, I get this error message:

2008-04-08 10:09:31 EEST [27794]: [95-1] ERROR: too many trigger records
found for relation "xyz"

The database had a bunch of autovacuum runs and an import process copying
data to temporary tables at the time I tried to create the tables. What
could cause such behaviour, and how can I remove the one remaining table?

Regards

Mikko