Duplicate table name within the sme schema
Good morning,
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.
Schema are the same = public.
How is it possible and how can i turn around this problem to have a
healthy DB.
Thank you.
<PRE>
<font face="sans-serif">
<table border=0 width=100%>
<tr><td><p lang="fr" style="color:green;font-size:x-small">Pensez à l'environnement : avez-vous besoin d'imprimer ce message ?</p></td></tr>
<tr><td><p lang-"en" style="color:green;font-size:x-small">Think environment : Do you need to print message ?</p></td></tr>
<tr><td><p lang="en" style="color:white;font-size:x-small">.</p></td></tr>
<tr><td><p lang="fr" style="font-size:x-small">Ce courrier électronique, et éventuellement ses pièces jointes, peuvent contenir des informations confidentielles et/ou personnelles et a été envoyé uniquement à l'usage de la personne ou de l'entité citée ci-dessus. Si vous receviez ce courrier électronique par erreur, merci de bien vouloir en avertir l'expéditeur immédiatement par la réponse en retour à ce courrier et effacer l'original et détruire toute copie enregistrée dans un ordinateur, ou imprimée ou encore sauvegardée sur un disque . Toute revue, retransmission ou toute autre forme d'utilisation de ce courrier électronique par toute autre personne que le destinataire prévue est strictement interdite.</p></td></tr>
<tr><td><p lang="fr" style="font-size:x-small">L'internet ne permettant pas d'assurer l'intégrité de ce message, l'expéditeur décline toute responsabilité au cas où il aurait été intercepté ou modifié par quiconque.</p></td></tr>
<tr><td><p lang="en" style="font-size:x-small">This e-mail and possibly any attachment may contain confidential and/or privileged information and is intended only for the use of the individual or entity named above. If you have received it in error, please advise the sender immediately by reply e-mail and delete and destroy all copies including all copies stored in the recipient's computer, printed or saved to disk. . Any review , retransmission, or further use of this e-mail by persons or entities other than the intended recipient is strictly prohibited.</p></td></tr>
<tr><td><p lang="en" style="font-size:x-small">Because of the nature of the Internet the sender is not in a position to ensure the integrity of this message, therefore the sender disclaims any liability whatsoever, in the event of this message having been intercepted and/or altered.</p></td></tr>
</table>
</font>
</PRE>
Cyril DE MURCIA <cyril.de-murcia@dcnsgroup.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
On 02/08/11 10:20 AM, Tom Lane wrote:
Cyril DE MURCIA<cyril.de-murcia@dcnsgroup.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?
indeed. 7.3.2 was released in Feb 2003, 8 years ago, while 7.3.21 was
5 years later, Jan 2008.