Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group