Schema accidentaly dropped in pg_namespace table - Mailing list pgsql-general

From benoit toutain
Subject Schema accidentaly dropped in pg_namespace table
Date
Msg-id 20050712150841.25268.qmail@web26504.mail.ukl.yahoo.com
Whole thread Raw
List pgsql-general
Hi all,

I've dropped a schema in my database with this command
:

delete from pg_namespace where nspname = "toto";

I know ... I 've done a big mistake :( . I will prefer
"drop schema toto" the next time.

Now I can't do a pg_dump because some objects of the
removed schema are still referenced in pg_* tables.
pg_dump does not know what to do in this case and
returns an error message.

My questions are the following :
- Is there a cleaning tool that allow me to find and
delete objects that references the removed schema ?
- Is there a document that graphically shows the
postgresql internal tables model ?
- Any other ideas ... ?

Thanks by advance,

Benoit






___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Update more than one table
Next
From: Richard Huxton
Date:
Subject: Re: utf-8 and cultural sensitive sorting