Request a Demo
Home   >   mailing lists

Re: pg_restore: error: could not execute query: ERROR: schema does not exist - Mailing list pgsql-bugs

From Fujii Masao
Subject Re: pg_restore: error: could not execute query: ERROR: schema does not exist
Date
Msg-id CAHGQGwG=sm5McBMbEbkwrPz4uyy7DDDL8MwY7e0is_eJ_8gG-g@mail.gmail.com
Whole thread
In response to pg_restore: error: could not execute query: ERROR: schema does not exist  (Michał Tęcza <michal.tecza@softiq.pl>)
List pgsql-bugs
Tree view 
On Fri, May 8, 2026 at 1:30 PM Michał Tęcza <michal.tecza@softiq.pl> 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/b43e03eb-3997-700e-c2d4-92c31e4e31ee@dalibo.com

--
Fujii Masao

pgsql-bugs by date:

Previous
From: Richard Guo
Date:
Subject: Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34