public inbox for [email protected]
help / color / mirror / Atom feedFrom: Fujii Masao <[email protected]>
To: Michał Tęcza <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: pg_restore: error: could not execute query: ERROR: schema does not exist
Date: Fri, 8 May 2026 23:41:56 +0900
Message-ID: <CAHGQGwG=sm5McBMbEbkwrPz4uyy7DDDL8MwY7e0is_eJ_8gG-g@mail.gmail.com> (raw)
In-Reply-To: <AS4P189MB1821E9F6FCFDE0413C0A12849B3C2@AS4P189MB1821.EURP189.PROD.OUTLOOK.COM>
References: <d43e0204-fae6-45ca-a06e-55aa52558f92.1a27a959-9aa3-407c-90ac-332721986f70.48c9b43b-80b8-4ef7-9941-637b4b816290@emailsignatures365.codetwo.com>
<AS4P189MB1821E9F6FCFDE0413C0A12849B3C2@AS4P189MB1821.EURP189.PROD.OUTLOOK.COM>
On Fri, May 8, 2026 at 1:30 PM Michał Tęcza <[email protected]> wrote:
>
> When restoring a database with some specific view, pg_restore produce an error - schema does not exists.
> This behavior was reproduced on latest version - 18.3
This issue was previously reported and discussed at [1]. As mentioned there,
the --if-exists option can suppress some "does not exist" errors,
but it does not guarantee that all such errors can be avoided.
Regards,
[1] https://postgr.es/m/[email protected]
--
Fujii Masao
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: pg_restore: error: could not execute query: ERROR: schema does not exist
In-Reply-To: <CAHGQGwG=sm5McBMbEbkwrPz4uyy7DDDL8MwY7e0is_eJ_8gG-g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox