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