On Sunday, July 31, 2016, Michael Paquier <michael.paquier@gmail.com> wrote:
> On Mon, Aug 1, 2016 at 11:19 AM, <amdjachenko@gmail.com <javascript:;>>
> wrote:
> > Current output:
> > line 40: CREATE SCHEMA public;
> >
> > Fix of the problem:
> > CREATE SCHEMA IF NOT EXISTS public;
> >
> > If there is some problem to change dump generator to do this please do
> this
> > at least for --if-exist parameter.
>
> Could you describe a little bit more in details the command of pg_dump
> that you are using? It would be also good to get an exact idea of the
> dump you are seeing, what you think it should do with a detailed
> example, and what are the objects on your database at the moment of
> taking the dump.
>
>
See also...
https://www.postgresql.org/message-id/20160312230919.GA11080%40hermes.hilbert.loc
I'd say there is room for both doc and code improvement here. Not exactly
sure what.
David J.