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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Kris Jurka <books(at)ejurka(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: pg_dump --clean w/ <= 7.2 server
Date: 2004-06-24 14:32:21
Message-ID: 13898.1088087541@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
>> 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;

Possibly the most correct solution is to assign the name "public" to the
dummy schema that pg_dump creates internally when talking to a pre-7.3
server.

I seem to recall that there was some reason for using "", but I don't
recall what exactly.

			regards, tom lane

In response to

Responses

pgsql-patches by date

Next:From: Thomas HallgrenDate: 2004-06-24 14:45:31
Subject: Re: bug in GUC
Previous:From: Tom LaneDate: 2004-06-24 14:02:08
Subject: Re: bug in GUC

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