Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wLMP7-001jFv-0N for pgsql-bugs@arkaria.postgresql.org; Fri, 08 May 2026 14:42:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wLMP5-00A0DG-2h for pgsql-bugs@arkaria.postgresql.org; Fri, 08 May 2026 14:42:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wLMP5-00A0D8-1u for pgsql-bugs@lists.postgresql.org; Fri, 08 May 2026 14:42:11 +0000 Received: from mail-oo1-xc2a.google.com ([2607:f8b0:4864:20::c2a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wLMP3-00000000pAQ-1VE6 for pgsql-bugs@lists.postgresql.org; Fri, 08 May 2026 14:42:10 +0000 Received: by mail-oo1-xc2a.google.com with SMTP id 006d021491bc7-6949192b843so786443eaf.1 for ; Fri, 08 May 2026 07:42:09 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1778251329; cv=none; d=google.com; s=arc-20240605; b=KMW7Bbf+qdFrwtpz8bqbwrJh9z6mSVCon8QS456dN1h4oG3h8ltwOo1Nl501HxMBjl S+XTLx674c+Lfirm6jUCqZlhGokrAzWzJSCAeqFMPa+0WBlB/2L3hUxSGMv0XpjQMH3f 2GG+h8XE92ihmCSMV8PINwViloztGg+gBQLjMACWq4Py6ma2NhGlr7hk8k3o4wARPAPQ EGLXHQw8AX0/uAA9/bPJEjsXU3Jo113RpZ4Jnc2IYJn3k4eYlaF/tdnHLDa203SKF4z+ oUA+F1p+cHkme07eg1wbugpm7ChJFGHdScb46SaUvnPbKg6qRI3FmKrOpZ/qUgQgubCM G+Fg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=hOvqV9SafZmnkLkFp53o6BHSA7By3qKcrDIq2ctmTVE=; fh=k5JUhJ/vug67MM+XPc1+gtGyhSJpzXS/Zo9H6ZZ9VtY=; b=Ex3Yxq6WC7yKX9mgsaEimWtOBZbXnKN6tBzvBL1vYKWTdvt5L/Ml9m0mkX704G1N3i UDFFFa3cwriEs9aRKQvSYcN6SGBnbu7PP1j0m1vhzriQ2niAMFcrcRATUZjjnpDGYG6S 6h/hDHJZPvSN6TLpUCANLLE8QVi5Vrm4jXpzgVO+YtdiPc2I8uHvhHjW2uvEjyXQ6bS4 u/YzFqnsDCfgTpJn4Qnc4UXv7CpLq+LufihrQ2KxCONnjfx0ErVNxGKFmktacBGRFQNv 5rNthOQMl71obeJnVDpnGvmpDS1linJwAHDAeIkrzee+We8FTAtMaSaehbIrluqxOUFi KN2Q==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1778251329; x=1778856129; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=hOvqV9SafZmnkLkFp53o6BHSA7By3qKcrDIq2ctmTVE=; b=TOxszUgoSgWleoTx0MX+1frwS3+U7tzxt42sN+7DW85JdJt5nTx5Ty8mUzvtvqM6Hw P6iEhLWw2z/dLBCkUEQKanJK3T5mGPmTX1J82CmGQH9+qyq5ygyfg/ZI66IdkkhmFKKG fE7OIIGT3gHRGJcbuQH2eKVOQNUzOhRb1R98DUW+8jDkvuWEwzP+mi6A0hCFyIOAcJeZ WJUrL/GWUt8JEMRwIEYehmGdkNeOUNalEqSygT6pfols6ePTYriPqjukLGdSsjUS8FOR DbyHN6tfarVNRlyV9ck9LsCDGZkWPFi4qVeGcr0lMrHbntDxBR3T0eig/OwiYRp4rE5f DnuA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1778251329; x=1778856129; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=hOvqV9SafZmnkLkFp53o6BHSA7By3qKcrDIq2ctmTVE=; b=tEdGOS6bbo92lKPklXkH+g5Y7IUEclrOxtVsYdC04Z2t+9pN0qwLyejr7tNwuDQ0Hr ZPQT3/fEvfklLsmGgd5+fXtxUVSxi3bjjh19BOBBHfjW0KVBnzYAKbxvmZS68st+sk2h Idckp6kaoh02+/Fw4BqEWpwP++HCXbY5q91g1N2lAY2ykQ2lTIZNakaf6oq3knyXxPTC m5jbRrcSHv+etj2v8iRb8ZGpEQBbJ3uz/lctWJ8epRBwGdh7P8rhG2cv0KMeJfLS4or/ /UODgXNA35vX6UZ74+qN6nGkoH+9TLHD4/Zy4aL/ZYTm+8gI2KTUNGn0ESJYwUTQ7s3Q jQbg== X-Gm-Message-State: AOJu0YxilXYcaiZHg1Pl1bvXy1rx7OR0WBA6x4YpYYynQPybDK/CF5DS Hd4bTGdHqyAPu/LEFvRXrY36Mowv5OpBc7zxZ1tatWXX6tQXYK3y5RqAQCDrOn0AaImV3m1mo1R 21DkiKqEosADjwe6fLZRkxrrPaTKneTc= X-Gm-Gg: AeBDiesbErmRs5zGNrl1ytEp311i+X2NTDHQI7604M70dJzvXCp0Gv7tJAcdn8LLuH3 ieTMoT35VbYpXH3s8rz5qQtiZdKUHjJVUnHrrcVbql59UHsYt+gYL63yNYXm3+YX9pzwQ8wmvNE Ol3xEpKVxPAgKrSnVb+2Fyzh/3l+0o1n9layFnreJxbxjs8VFdcP07uGOiHYXMITMgvaqwyYIa9 hhT5grSnb7uE+X4TGJR4ctW5PcgnvS3Qg5HSQoOQCjbdblinRRe90i5EH8ijCitfwnq9GhbQBnT 6w9qQCYZwDeg6h6O52jUFL9ocaSXBIouOHez3kIPlrvTGE92cCs= X-Received: by 2002:a05:6820:308e:b0:683:70eb:2669 with SMTP id 006d021491bc7-69998cb62c5mr7191234eaf.13.1778251329350; Fri, 08 May 2026 07:42:09 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Fujii Masao Date: Fri, 8 May 2026 23:41:56 +0900 X-Gm-Features: AVHnY4KOpLJ2TF6Y7lEknzSa6NlYojAO4MGT0ExTwszQHe95G-O8SkME6kZTSik Message-ID: Subject: Re: pg_restore: error: could not execute query: ERROR: schema does not exist To: =?UTF-8?B?TWljaGHFgiBUxJljemE=?= Cc: "pgsql-bugs@lists.postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, May 8, 2026 at 1:30=E2=80=AFPM Micha=C5=82 T=C4=99cza 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 --=20 Fujii Masao