Re: pg_dump --clean w/ <= 7.2 server

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: pg_dump --clean w/ <= 7.2 server
Date: 2004-06-24 13:58:22
Message-ID: 40DADDFE.4030106@familyhealth.com.au
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;

Since the person is dumping using 7.5 pg_dump, presumably they will be
restoring to 7.5, and it should be:

DROP TABLE "public".tab;

Chris

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-06-24 14:02:08 Re: bug in GUC
Previous Message Kris Jurka 2004-06-24 12:27:38 pg_dump --clean w/ <= 7.2 server