Stephen Frost <sfr...@snowman.net> writes: > * Tom Lane (t...@sss.pgh.pa.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