Re: BUG #17753: pg_dump --if-exists bug - Mailing list pgsql-bugs

From David Rowley
Subject Re: BUG #17753: pg_dump --if-exists bug
Date
Msg-id CAApHDvq+JTtZWOrXBrY7LvquyXHoCWWq=DfPYKB4b7BuFiM_8A@mail.gmail.com
Whole thread Raw
In response to BUG #17753: pg_dump --if-exists bug  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17753: pg_dump --if-exists bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Thu, 19 Jan 2023 at 22:31, PG Bug reporting form
<noreply@postgresql.org> wrote:
> Running pg_dump with the options "--section=pre-data --no-owner
> --no-privileges --no-subscriptions --no-publications --clean --if-exists
> --file=/Users/ju5tinz/Dev/pg_pass_test/pre_data.sql" prints the warning:
> pg_dump: warning: could not find where to insert IF EXISTS in statement "--
> *not* dropping schema, since initdb creates it
> "

Are you able to share the full warning message including the statement?

David



pgsql-bugs by date:

Previous
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: DROP DATABASE deadlocks with logical replication worker in PG 15.1
Next
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: DROP DATABASE deadlocks with logical replication worker in PG 15.1