Re: Table data exclusion patch for pg_dump - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Table data exclusion patch for pg_dump
Date
Msg-id 22327.1241206430@sss.pgh.pa.us
Whole thread Raw
In response to Re: Table data exclusion patch for pg_dump  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Table data exclusion patch for pg_dump  (Andrew Dunstan <andrew@dunslane.net>)
Re: Table data exclusion patch for pg_dump  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> Why wouldn't you just use -s ?

> You might want the whole schema and data for most but not all of the 
> tables (e.g. you might leave out a large session table for a web app).

The use-case seems pretty thin to me, and the potential for shooting
oneself in the foot rather large.  We routinely get complaints, for
example, from people who do partial dumps and then find out they don't
restore because of foreign key constraints.  This looks like mostly
a larger-gauge version of that.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Asko Oja
Date:
Subject: Re: Table data exclusion patch for pg_dump
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Throw some low-level C scutwork at me