"too many trigger records found for relation xyz"

------=_Part_26478_22127058.1207638864147
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 im****t process copying
data to tem****ary 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

------=_Part_26478_22127058.1207638864147
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello all<br><br>Postgres version 8.3.1<br><br>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&#39;t get
created at all.<br>
<br>Postgres complained:<br><br>2008-04-08 08:50:41 EEST [721]: [27-1]
ERROR:&nbsp; relation 543058 deleted while still in
use<br><br>and<br><br>2008-04-08 08:50:41 EEST [721]: [36-1] ERROR:&nbsp;
could not find tuple for relation 54309<br>
<br>and<br><br>2008-04-08 08:50:42 EEST [721]: [114-1] ERROR:&nbsp;
duplicate key value violates unique constraint
&quot;pg_class_oid_index&quot;<br><br>When I tried to remove the tables,
the same errors kept coming up<br><br>
2008-04-08 08:53:15 EEST [27794]: [5-1] ERROR:&nbsp; duplicate key value
violates unique constraint &quot;pg_class_oid_index&quot;<br>2008-04-08
08:53:15 EEST [27794]: [6-1] STATEMENT:&nbsp; drop table xyz ;<br><br>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:<br>
<br>2008-04-08 10:09:31 EEST [27794]: [95-1] ERROR:&nbsp; too many trigger
records found for relation &quot;xyz&quot;<br><br>The database had a bunch
of autovacuum runs and an im****t process copying data to tem****ary tables
at the time I tried to create the tables. What could cause such behaviour,
and how can I remove the one remaining table?<br>
<br>Regards<br><br>Mikko<br><br><br><br><br><br><br><br>

------=_Part_26478_22127058.1207638864147--