|From:||Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>|
|To:||Stephen Frost <sfrost(at)snowman(dot)net>|
|Cc:||"David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Fabrízio Mello <fabriziomello(at)gmail(dot)com>, Robins Tharakan <tharakan(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, David Fetter <david(at)fetter(dot)org>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>|
|Subject:||Re: [HACKERS] Patch: Add --no-comments to skip COMMENTs with pg_dump|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
Stephen Frost <sfrost(at)snowman(dot)net> writes:
> * Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
>> In further testing of that, I noticed that it made the behavior of our
>> other bugaboo, the public schema, rather inconsistent. With this
>> builtin-extensions hack, the plpgsql extension doesn't get dumped,
>> whether or not you say "clean". But the public schema does get
>> dropped and recreated if you say "clean". That's not helpful for
>> non-superuser users of pg_dump, so I think we should try to fix it.
> I'm not entirely sure about trying to also support --clean for
> non-superusers.. We've long had that the public schema is dropped and
> recreated with --clean and it seems likely that at least some users are
> depending on us doing that. In any case, it's certainly not a change
> that I think we could backpatch. Perhaps we could just change it moving
> forward (which would make me happier, really, since what I think we do
> with these initdb-time things currently is a bit bizarre).
Sure, I was not proposing this for back-patch --- it depends on the
other stuff we've committed recently, anyway.
> Yes, having that in getNamespaces() isn't correct but we need to do
> something there, and I've been trying to figure out what.
I claim this is what ;-)
regards, tom lane
|Next Message||Robert Haas||2018-01-24 18:11:22||Re: pgsql: Add parallel-aware hash joins.|
|Previous Message||Ryan Murphy||2018-01-24 17:59:47||Re: Is it valid to have logical replication between 2 databases on the same postgres server?|