Skip site navigation (1) Skip section navigation (2)

Re: Duplicate table name within the sme schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Cyril DE MURCIA <cyril(dot)de-murcia(at)dcnsgroup(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Duplicate table name within the sme schema
Date: 2011-02-08 18:20:03
Message-ID: 22482.1297189203@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Cyril DE MURCIA <cyril(dot)de-murcia(at)dcnsgroup(dot)com> writes:
> We use postgresql 7.3.2 under Linux Red Hat 9.0. 
> We periodically dump and restore our database. I don't know if an error 
> occured during a dump restore but our DB seems to be corrupted.
> Our base contains many pair of table with the same name.

My goodness, that's a pretty obsolete system :-(.  You do realize that
7.3.x was up to 7.3.21 by the time it was obsoleted?

My recollection is that this has been seen to happen when there were for
some reason duplicate rows in pg_shadow --- pg_dump does something like
"SELECT FROM pg_class JOIN pg_shadow ON relowner = usesysid", so it
would get multiple copies of any table that joined to multiple pg_shadow
entries.  How you got into that state is harder to say, but if you can
get rid of the duplicate entries then your dump would go back to a sane
state.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: John R PierceDate: 2011-02-08 18:56:25
Subject: Re: Duplicate table name within the sme schema
Previous:From: cheeragDate: 2011-02-08 16:16:26
Subject: BUG #5871: database connecting failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group