On 12/16/2011 07:57 PM, Thom Brown wrote:
> On 17 December 2011 00:17, Andrew Dunstan<andrew(at)dunslane(dot)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.
>
Hmm, yeah. Are they the only ones?
cheers
andrew