Re: Duplicate table name within the sme schema

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