pg_dump --clean w/ <= 7.2 server
От
Kris Jurka
Тема
pg_dump --clean w/ <= 7.2 server
Дата
Msg-id
Pine.BSO.4.56.0406240722080.3872@leary.csoft.net
Список
Дерево обсуждения
pg_dump --clean w/ <= 7.2 server Kris Jurka <books@ejurka.com>
Re: pg_dump --clean w/ <= 7.2 server Bruce Momjian <pgman@candle.pha.pa.us>
Re: pg_dump --clean w/ <= 7.2 server Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: pg_dump --clean w/ <= 7.2 server Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: pg_dump --clean w/ <= 7.2 server Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump --clean w/ <= 7.2 server Kris Jurka <books@ejurka.com>
Re: pg_dump --clean w/ <= 7.2 server Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump --clean w/ <= 7.2 server Bruce Momjian <pgman@candle.pha.pa.us>
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
В списке pgsql-patches по дате отправления