Re: pgsql: Add --section option to pg_dump and pg_restore. - Mailing list pgsql-committers

From Thom Brown
Subject Re: pgsql: Add --section option to pg_dump and pg_restore.
Date
Msg-id CAA-aLv6aC8cvBO9dKoADiL_BePyYzE9foo3LrtWZ49QRGebBWA@mail.gmail.com
Whole thread Raw
In response to pgsql: Add --section option to pg_dump and pg_restore.  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: pgsql: Add --section option to pg_dump and pg_restore.  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-committers
On 17 December 2011 00:17, Andrew Dunstan <andrew@dunslane.net> wrote:
> Add --section option to pg_dump and pg_restore.
>
> Valid values are --pre-data, data and post-data. The option can be
> given more than once. --schema-only is equivalent to
> --section=pre-data --section=post-data. --data-only is equivalent
> to --section=data.

"Post-data items consist of definitions of indexes, triggers, rules
and constraints other than check constraints."

What about NOT VALID check constraints?  Those are required to be post-data.

--
Thom

pgsql-committers by date:

Previous
From: Andrew Dunstan
Date:
Subject: pgsql: Add --section option to pg_dump and pg_restore.
Next
From: fxjr@pgfoundry.org (User Fxjr)
Date:
Subject: npgsql - Npgsql2: Fixed a test which were leaking a datareader open.