On 17 December 2011 18:11, Andrew Dunstan <[email protected]> wrote: > > > On 12/17/2011 08:13 AM, Thom Brown wrote: >> >> On 17 December 2011 02:32, Andrew Dunstan<[email protected]> wrote: >>> >>> >>> On 12/16/2011 07:57 PM, Thom Brown wrote: >>>> >>>> On 17 December 2011 00:17, Andrew Dunstan<[email protected]> 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".
Sounds good to me. > 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.) Dumped where they occur? I'm not sure I follow. -- Thom -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
