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

Duplicate table name within the sme schema

From: Cyril DE MURCIA <cyril(dot)de-murcia(at)dcnsgroup(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Duplicate table name within the sme schema
Date: 2011-02-08 13:05:04
Message-ID: 29915_1297170305_4D513F81_29915_307_1_OF91DF327C.DA44FFEF-ONC1257831.004760D6-C1257831.0047D067@dcnsgroup.com (view raw or flat)
Thread:
Lists: pgsql-bugs
  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 &agrave; 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 &eacute;lectronique, et &eacute;ventuellement ses pi&egrave;ces jointes, peuvent contenir des informations confidentielles et/ou  personnelles et a &eacute;t&eacute; envoy&eacute; uniquement &agrave; l'usage de la personne ou de l'entit&eacute;  cit&eacute;e ci-dessus. Si vous receviez ce courrier &eacute;lectronique par erreur, merci de bien vouloir en avertir l'exp&eacute;diteur imm&eacute;diatement par la r&eacute;ponse en retour &agrave; ce courrier  et effacer l'original et d&eacute;truire toute copie enregistr&eacute;e dans un ordinateur, ou imprim&eacute;e ou encore sauvegard&eacute;e sur un disque . Toute  revue, retransmission ou toute autre forme d'utilisation de ce courrier &eacute;lectronique par toute autre personne que le destinataire pr&eacute;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&eacute;grit&eacute; de ce message, l'exp&eacute;diteur d&eacute;cline toute responsabilit&eacute; au cas o&ugrave; il aurait &eacute;t&eacute; intercept&eacute; ou modifi&eacute; 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>

Responses

pgsql-bugs by date

Next:From: T ZimmermanDate: 2011-02-08 14:35:36
Subject: BUG #5870: Cannot get the first popup window during install
Previous:From: David SchmittDate: 2011-02-08 07:19:37
Subject: BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases

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