| From: | benoit toutain <bf_toutain(at)yahoo(dot)fr> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Schema accidentaly dropped in pg_namespace table |
| Date: | 2005-07-12 15:08:40 |
| Message-ID: | 20050712150841.25268.qmail@web26504.mail.ukl.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-07-12 15:10:03 | Re: utf-8 and cultural sensitive sorting |
| Previous Message | Bruno Wolff III | 2005-07-12 15:08:37 | Re: Update more than one table |