Thread: Fwd: Multiple entries of same table in pg_class

Fwd: Multiple entries of same table in pg_class

From

Peter Bauer

Date:

16 September 2006, 16:27:51

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

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

Re: Fwd: Multiple entries of same table in pg_class

From

Tom Lane

Date:

16 September 2006, 16:42:13

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