Multiple entries of same table in pg_class

Started by Peter Bauerover 19 years ago3 messagesgeneral
Jump to latest
#1Peter Bauer
peter.m.bauer@gmail.com

Hi all,

after extensive logfilechecking we found out that there are 70 entries
for the same table in pg_class which are identical.
Dropping the table results in a "missing attribute ..." error for this relation.

PostgreSQL 7.4.7
Debian Sarge

regards,
Peter

#2Peter Bauer
peter.m.bauer@gmail.com
In reply to: Peter Bauer (#1)
Fwd: Multiple entries of same table in pg_class

Has nobody an idea what could have happened?

thx,
Peter

---------- Weitergeleitete Nachricht ----------

Subject: Multiple entries of same table in pg_class
Date: Dienstag, 12. September 2006 13:19
From: "Peter Bauer" <peter.m.bauer@gmail.com>
To: pgsql-general@postgresql.org

Hi all,

after extensive logfilechecking we found out that there are 70 entries
for the same table in pg_class which are identical.
Dropping the table results in a "missing attribute ..." error for this
relation.

PostgreSQL 7.4.7
Debian Sarge

regards,
Peter

-------------------------------------------------------

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Peter Bauer (#2)
Re: Fwd: Multiple entries of same table in pg_class

Peter Bauer <peter.m.bauer@gmail.com> writes:

after extensive logfilechecking we found out that there are 70 entries
for the same table in pg_class which are identical.

Hm, could we see

select ctid,xmin,cmin,xmax,cmax,oid from pg_class where relname = whatever

regards, tom lane