From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | pg_dump --clean w/ <= 7.2 server |
Date: | 2004-06-24 12:27:38 |
Message-ID: | Pine.BSO.4.56.0406240722080.3872@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
When running pg_dump --clean against a server that doesn't have schemas
the namespace is blank and ends up producing a dump full off things like:
DROP TABLE "".tab;
The attached patch only includes a schema if one exists. There are
numerous comments about the DROPs needing to be fully qualified to avoid
conflicting with pg_catalog, but this should be mostly safe because it
would require a user defined object to be present in a later server
version with the same name, and it is difficult to impossible to drop
system objects anyway.
Kris Jurka
Attachment | Content-Type | Size |
---|---|---|
dumpclean.patch | text/plain | 14.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-06-24 13:58:22 | Re: pg_dump --clean w/ <= 7.2 server |
Previous Message | Bruce Momjian | 2004-06-24 11:00:59 | Re: [PATCHES] Configuration patch |