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

On 12/17/2011 08:13 AM, Thom Brown wrote:
> On 17 December 2011 02:32, Andrew Dunstan<andrew(at)dunslane(dot)net> wrote:
>>
>> 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?
> Well, there's object permissions too excluding ownership, but can't
> think of anything else.
>

I have qualified the sentence above to say that the exception is
"validated check constraints".

The comments in the code about when ACLs are dumped or restored appear
to be incorrect unless I'm missing something. The appear to be dumped
where they occur. (This code always makes my head hurt, I confess.)

cheers

andrew