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 1wLCru-001cPg-1v for pgsql-bugs@arkaria.postgresql.org; Fri, 08 May 2026 04:31:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wLCrt-007oxV-1W for pgsql-bugs@arkaria.postgresql.org; Fri, 08 May 2026 04:31:17 +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 1wL4zV-005tUp-0c for pgsql-bugs@lists.postgresql.org; Thu, 07 May 2026 20:06:37 +0000 Received: from mail-francecentralazlp170130007.outbound.protection.outlook.com ([2a01:111:f403:c20a::7] helo=PA4PR04CU001.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wL4zR-00000000h3A-2IaM for pgsql-bugs@lists.postgresql.org; Thu, 07 May 2026 20:06:35 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=Fys+EKvNadC++LUWUiLOpi66XBGfDveL9U9lKhv9xDnIG16+jpsLpvU1P5LLFdHMV1gRbK72Tf3X+U9O+ICHWAjFMgKKNBz3Y2fTsL+m7q5wD/zlKGHSkwdqiecDZ8KOWaX02XUgpsGkgQ9hUdNLcoKs0H1zYx7d62b+d5Ois3OLUdOU39K09yuFy2OVHKdbiasKy/OPI0/jdicz6zhuJhRw61SSUpGbX3izoHtoeLdRAL1K2W7VYxUnMNuz5Tt0TaGMr76i5MrkSy79VRjZoMYu/0VikdsxyYAjkhRMZ/lPPCIKLuh1qscz0jX88235/U89WpP77YXcMdI9w1DMMA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=ptp+lA0HKZGIJEqBBU6hF1NDuPabjvaC+u8J+o7GZIM=; b=nS53Ii4Q7Mgzk4zEyj0j0NVK4z68KcOsX9WEP2PWEZ3sEhpPXEZHPOm06ZAklP6YY/WD0zE8i3fN0nlmzedVdmTxyQnxDF3HstEMeyvJD89OEFCgIMD/f6rE3Cu/0eGaMLxUtXZV6qEmer3VqGBJRtx+9VnNNz/D7svdDC84YeMSc8+uuZp5CpXTJa9jO2UrDICHOX3J1K4nlbXaXLGAL79au99bCYtkL7rFbl8bVUJnvTEVQ6PzswgMAI7cfTMGFfp0hbVcJM+sDb+wfQijihc0e50axjZ0Y4OJqtTVLSGAXBVv/U07V3C0mDkVuFkwd1DXeo0Ys7NsfIkiLDW/ZA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass (sender ip is 13.93.42.39) smtp.rcpttodomain=lists.postgresql.org smtp.mailfrom=softiq.pl; dmarc=pass (p=reject sp=reject pct=100) action=none header.from=softiq.pl; dkim=none (message not signed); arc=none (0) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=softiq.pl; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=ptp+lA0HKZGIJEqBBU6hF1NDuPabjvaC+u8J+o7GZIM=; b=HFh+tfX9W9dKMaeTQUDIMYR7VaO9w+1n3DJ3WdQgF5/cX6eq9l1f1Ns+/CYO3MIrFu9QahPO92KIjorylGsWggXGVJpsrUZL89uFvQKY1bxCZlwVKBXMvRCVzFjGE3Wj8RaEX8Xx/3hJ9mni0bjd5ljagrHsGcuhBQqRzhXcCOI= Received: from CWLP265CA0531.GBRP265.PROD.OUTLOOK.COM (2603:10a6:400:18d::23) by DB8P189MB1142.EURP189.PROD.OUTLOOK.COM (2603:10a6:10:164::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9891.15; Thu, 7 May 2026 20:06:27 +0000 Received: from AMS0EPF000001A8.eurprd05.prod.outlook.com (2603:10a6:400:18d:cafe::32) by CWLP265CA0531.outlook.office365.com (2603:10a6:400:18d::23) with Microsoft SMTP Server (version=TLS1_3, cipher=TLS_AES_256_GCM_SHA384) id 15.20.9891.17 via Frontend Transport; Thu, 7 May 2026 20:06:27 +0000 X-MS-Exchange-Authentication-Results: spf=pass (sender IP is 13.93.42.39) smtp.mailfrom=softiq.pl; dkim=none (message not signed) header.d=none;dmarc=pass action=none header.from=softiq.pl; Received-SPF: Pass (protection.outlook.com: domain of softiq.pl designates 13.93.42.39 as permitted sender) receiver=protection.outlook.com; client-ip=13.93.42.39; helo=westeu12-emailsignatures-cloud.codetwo.com; pr=C Received: from westeu12-emailsignatures-cloud.codetwo.com (13.93.42.39) by AMS0EPF000001A8.mail.protection.outlook.com (10.167.16.148) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9891.9 via Frontend Transport; Thu, 7 May 2026 20:06:27 +0000 Received: from DB3PR08CU002.outbound.protection.outlook.com (40.93.64.81) by westeu12-emailsignatures-cloud.codetwo.com with CodeTwo SMTP Server (TLS12) via SMTP; Thu, 07 May 2026 20:06:26 +0000 Received: from AS4P189MB1821.EURP189.PROD.OUTLOOK.COM (2603:10a6:20b:4c0::6) by FRWP189MB3399.EURP189.PROD.OUTLOOK.COM (2603:10a6:d10:1a2::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9891.17; Thu, 7 May 2026 20:06:24 +0000 Received: from AS4P189MB1821.EURP189.PROD.OUTLOOK.COM ([fe80::737d:15fd:a7a2:9892]) by AS4P189MB1821.EURP189.PROD.OUTLOOK.COM ([fe80::737d:15fd:a7a2:9892%6]) with mapi id 15.20.9891.019; Thu, 7 May 2026 20:06:23 +0000 From: =?iso-8859-2?Q?Micha=B3_T=EAcza?= To: "pgsql-bugs@lists.postgresql.org" Subject: pg_restore: error: could not execute query: ERROR: schema does not exist Thread-Topic: pg_restore: error: could not execute query: ERROR: schema does not exist Thread-Index: AQHc3lyQdEElX5cXkEebZRMk6Et6gw== Date: Thu, 7 May 2026 20:06:23 +0000 Message-ID: Accept-Language: pl-PL, en-US Content-Language: pl-PL X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: Authentication-Results-Original: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=softiq.pl; x-ms-traffictypediagnostic: AS4P189MB1821:EE_|FRWP189MB3399:EE_|AMS0EPF000001A8:EE_|DB8P189MB1142:EE_ X-MS-Office365-Filtering-Correlation-Id: 39d7bfb9-1405-4e93-f9e7-08deac741f18 X-MS-Exchange-SenderADCheck: 1 X-MS-Exchange-AntiSpam-Relay: 0 X-Microsoft-Antispam-Untrusted: BCL:0;ARA:13230040|1800799024|366016|376014|38070700021|3023799003|56012099003|8096899003|18002099003; X-Microsoft-Antispam-Message-Info-Original: rD2YdTIZCKwKmGyhf8ekea4Cxo31+X7zZETYVGz8UE51TNq0IXyVYUYec/XJJL1IDZVwsJiTdshmKJQM3Oxx71Ei2JKCBjmwcNrpPZT4ED9Uf1EonuGULLnhw08HJ0whjglZ2cEp/Bb1tIFw7BmtBPE5u6Lxzk/dwuPz37Hjwg2xWiZb6n3jsqsRp5sS8YTbTdeMIji0fnTj7bl+nWznWalGJ5F1BIu+Z1uy4zWVqYSDETj058U5uAGsfFLeXHnF4r0pnV3FBO1C6SgySi2Fh35eEsdeR6/yfPBNSILcdgK4ew8ZXTc95CS8uBerrplavNhmZw2DmNNsW2JKPAkIOw2hfZpliZrTbtaJ8tlIOSL9ANm1q9owhOITkwH71Lwpq0aYIdTEHa+IGkWdyc50QiS7XS4YAKuO9KxbB/6inE5s9ZQiJB0pSL/rqabisH0Cmm1jN5sjf23f6Erb4XGelGCw3CllXMT1FnkAHbFCnYQxFIgwjxzegTbgBkoJpoiGZRv+yy+Rv9a7ZPM17nDBlSM3HOaq/4ZiJuX8WdWstPXGkg8oFrsQGwaXrCg73g2tXG9+y5QN6QQhl4pr+UDFrAAovprSO7rdzoiXIIW32f+mclRnqa4L89G3+KpHfZi+NFeNutpD58CFobUR5f9sHKRP6U3e+siDA5NhZbpjwz/dLW0TTxBS70ixK4dbSoptkcUpOc/9TxPfmSEvy16uCFxiucb0ZtXK0moaIT3uj4lanOQDcAAzt5we7poilZFZ X-Forefront-Antispam-Report-Untrusted: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AS4P189MB1821.EURP189.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(366016)(376014)(38070700021)(3023799003)(56012099003)(8096899003)(18002099003);DIR:OUT;SFP:1102; Content-Type: multipart/alternative; boundary="_000_AS4P189MB1821E9F6FCFDE0413C0A12849B3C2AS4P189MB1821EURP_" MIME-Version: 1.0 X-Exchange-RoutingPolicyChecked: cJ4iR1EQ5bnvAAyOwzNzKmXIfsP1WySHhx3lvELFDXJy650vhrCOmQ0MxydvcUx7DHBnO0GR4EA2YWjpjVPDO9zeK2/HGoxml3eTbNZaLPHbDtNivcBiVHvz7NaH2HYj0F6Xw03dxBvr5UMuufxhNfr2ZOgbFL50qaZ7OhVEAEPDKmiVhUe6GwaUt+TkjQ2ycSJkm41flnsPF3r/74vXVKh66iTycAe84rj4K72ltBEEGvBCBXTNUj+MlhpTdWFRHxlbucWppha2Sb10nH5bmytCFLR2m1/X2wMY7ecQQ22Lbxhk8cpmMa/LzI3Gu3L5amG6spbgE32yQF83hS0ANg== X-MS-Exchange-Transport-CrossTenantHeadersStamped: FRWP189MB3399 X-CodeTwo-MessageID: 30c3cb74-2b8a-4e59-ae35-99ad34e4b07d.20260507200626@westeu12-emailsignatures-cloud.codetwo.com References: X-CodeTwoProcessed: true X-EOPAttributedMessage: 0 X-MS-Exchange-Transport-CrossTenantHeadersStripped: AMS0EPF000001A8.eurprd05.prod.outlook.com X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id-Prvs: 90abfaf7-6a33-4f7d-03c4-08deac741d35 X-Microsoft-Antispam: BCL:0;ARA:13230040|14060799003|82310400026|69100299015|7149299003|1800799024|7049299003|376014|3109299003|36860700016|35042699022|1032899013|13003099007|3023799003|18002099003|56012099003|8096899003|2066899003; X-Microsoft-Antispam-Message-Info: aT482WVNzfLX6YjSU4S3sR21CVpTsfYMmmsxjxOpXByuHYR/bl14Px0AGXnMm6ZKv5BNd3sdYbSosQ/B9kEedX6gFG52+jI/ioJa3vm1274IsQZTdMacnhDbxTMdaroeoiymjzLyz8T652yS7Vv0PUNMglQFDQirZXC0BloST6M1kaue56WKkJv6RwvBaromH1k58hs4LGYAzSG+f4vxBqOuKCS2zRZUjNU9GhCKG98zirXNmDV25GPl2nF/qWp+mWQI+IKlI3TI3vJTvXE7d8CMhSSHOjzXmWka2Gs/wWuO/qNQjiO8DTO48SBqxgL7C52mk8ZBGWhSxBH4kY5XSnwtHH7DYQQNQ4kEvd5+9gSS1p3NYLy00P+jIfygiElIaU+7lEQfKzcOQivKU9k5bn+So8IFnhUv+bvQa7HAIreUs6RykGjfl0vD761oexjRc/WqpOWxjqdEXy1WaSfK7u6Rim5uXy1xwy3crVQ/5bmNN5d084vxtH33YZrL3shhJy5Ms14h7/HuLsZCFhX9FLPUlvXhmc2QmGLnxS7zq+xj6zPJGV20ellgqIEXBLcF/Id7IVtT1OKew3nwR+Hes2dBrPyDXbbvObrgLmb6IEJ1vDhNCtSH6w944161/bGWJUO/N3o7WSjdtJahDq6pFVZBF6PLS4dJy0/5lvNzygaXe4QSG2En2JUcd15ysxt6 X-Forefront-Antispam-Report: CIP:13.93.42.39;CTRY:NL;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:westeu12-emailsignatures-cloud.codetwo.com;PTR:westeu12-emailsignatures-cloud.codetwo.com;CAT:NONE;SFS:(13230040)(14060799003)(82310400026)(69100299015)(7149299003)(1800799024)(7049299003)(376014)(3109299003)(36860700016)(35042699022)(1032899013)(13003099007)(3023799003)(18002099003)(56012099003)(8096899003)(2066899003);DIR:OUT;SFP:1102; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: zFS4ofC654kIqy8g2zOIcjJReEX7g7VcXzyDSgprn/mN0HJE7DYbXtZE831DRJGIwUnoKXXilxfOVuFiGUhBRSbrlo3+8+cb9MHD8xwvIQGzGdgg9iUTTycdpLe78iaWeCIOuimjLtPoL5EHTofbZpCWtXBp+ijbRiK/UNL8WAh0Ge1pV016JMJLwutToMe2+jg0dGnXuyRI4KpC/TuDmfRSi4GACs8edINJR+cKpQIgRYRPkKs5ojNUZKaAhH+2QAtJ0zALk6kLSt/c6VLlZ+7GFKQpgcnF0jKK9EY2qPwDYQGeci+ifS023/q6M6uui2BqpD7ypoc14pbRMhme9a8ob4wb7guuS4Bq8YPlYbAiY4IdU5ye3OMx91K4AYqr2V52I9D4qNiaH5eejtslAX5ljwPRQOQN/wuEJHw+1jM3vgQpZw3zFL/owmvXKmw6 X-OriginatorOrg: softiq.pl X-MS-Exchange-CrossTenant-OriginalArrivalTime: 07 May 2026 20:06:27.1006 (UTC) X-MS-Exchange-CrossTenant-Network-Message-Id: 39d7bfb9-1405-4e93-f9e7-08deac741f18 X-MS-Exchange-CrossTenant-Id: fbdbf795-629f-40d9-bf59-3b4d4dd13d16 X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=fbdbf795-629f-40d9-bf59-3b4d4dd13d16;Ip=[13.93.42.39];Helo=[westeu12-emailsignatures-cloud.codetwo.com] X-MS-Exchange-CrossTenant-AuthSource: AMS0EPF000001A8.eurprd05.prod.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Anonymous X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB8P189MB1142 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_AS4P189MB1821E9F6FCFDE0413C0A12849B3C2AS4P189MB1821EURP_ Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable When restoring a database with some specific view, pg_restore produce an er= ror - schema does not exists. This behavior was reproduced on latest version - 18.3 To reproduce the bug 1. Create file foo.sql -- begin foo.sql CREATE SCHEMA domain; CREATE SCHEMA reporting; CREATE TABLE domain.customers ( id integer NOT NULL, name text NOT NULL, email text, created_at timestamp without time zone DEFAULT now() ); CREATE SEQUENCE domain.customers_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE domain.customers_id_seq OWNED BY domain.customers.id; CREATE VIEW reporting.v_customers AS SELECT NULL::integer AS customer_id, NULL::text AS name; ALTER TABLE ONLY domain.customers ALTER COLUMN id SET DEFAULT nextval('domain.customers_id_seq'::regclass= ); ALTER TABLE ONLY domain.customers ADD CONSTRAINT customers_email_key UNIQUE (email); ALTER TABLE ONLY domain.customers ADD CONSTRAINT customers_pkey PRIMARY KEY (id); CREATE OR REPLACE VIEW reporting.v_customers AS SELECT c.id AS customer_id, c.name FROM domain.customers c GROUP BY c.id; -- end foo.sql 2. Create a database foo createdb --host=3Dlocalhost --port=3D5432 --username=3Dpostgres foo 3. Load file into database psql -U postgres -f foo.sql foo 4. create dump pg_dump --host=3Dlocalhost --port=3D5432 --username=3Dpostgres --format=3D= c --file dump foo 5. create database restore_foo createdb --host=3Dlocalhost --port=3D5432 --username=3Dpostgres restore_foo 6. restore database pg_restore -Fc --verbose --no-owner --clean --if-exists --no-privileges -d = restore_foo -U postgres dump pg_restore log: pg_restore: connecting to database for restore pg_restore: executing SELECT pg_catalog.set_config('search_path', '', false= ); pg_restore: dropping RULE v_customers _RETURN pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 3450; 2618 22119 RULE v_customers _RETURN postgr= es pg_restore: error: could not execute query: ERROR: schema "reporting" does= not exist Command was: CREATE OR REPLACE VIEW reporting.v_customers AS SELECT NULL::integer AS customer_id, NULL::text AS name; pg_restore: dropping CONSTRAINT customers customers_pkey pg_restore: dropping CONSTRAINT customers customers_email_key pg_restore: dropping DEFAULT customers id pg_restore: dropping VIEW v_customers pg_restore: dropping SEQUENCE customers_id_seq pg_restore: dropping TABLE customers pg_restore: dropping SCHEMA reporting pg_restore: dropping SCHEMA domain pg_restore: creating SCHEMA "domain" pg_restore: creating SCHEMA "reporting" pg_restore: creating TABLE "domain.customers" pg_restore: creating SEQUENCE "domain.customers_id_seq" pg_restore: creating SEQUENCE OWNED BY "domain.customers_id_seq" pg_restore: creating VIEW "reporting.v_customers" pg_restore: creating DEFAULT "domain.customers id" pg_restore: processing data for table "domain.customers" pg_restore: executing SEQUENCE SET customers_id_seq pg_restore: creating CONSTRAINT "domain.customers customers_email_key" pg_restore: creating CONSTRAINT "domain.customers customers_pkey" pg_restore: creating RULE "reporting.v_customers _RETURN" pg_restore: warning: errors ignored on restore: 1 best regards Micha=B3 T=EAcza _________________ Pozdrawiam/Best Regards Micha=B3 T=EAcza Architekt System=F3w Informatycznych IT Architect Mobile: +48 733 057 852 E-mail: michal.tecza@softiq.pl [https://softiq.pl/sig/logo.png] [https://softiq.pl/sig/footer-line.png] SOFTIQ Sp. z o.o., ul. Chorzowska 50, 44-100 Gliwice Wearesoftiq Ltd, 4 Studio Court Queensway, Bletchley, Milton Keynes, Englan= d, MK2 2DG SOFTIQ Deutschland GmbH in Gr=FCndung, Joseph-Dollinger-Bogen 14 D-80807 Mu= nich [https://softiq.pl/sig/1-social-media-icon.png] [https://softiq.pl/sig/3-social-media-icon.png] [https://softiq.pl/sig/4-social-media-icon.png= ] --_000_AS4P189MB1821E9F6FCFDE0413C0A12849B3C2AS4P189MB1821EURP_ Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable
When restoring a database with some specific view, pg_restore produce an er= ror - schema does not exists.
This behavior was reproduced on latest version - 18.3

To reproduce the bug

1. Create file foo.sql
-- begin foo.sql
CREATE SCHEMA domain;
CREATE SCHEMA reporting;

CREATE TABLE domain.customers (
    id integer NOT NULL,
    name text NOT NULL,
    email text,
    created_at timestamp without time zone DEFAULT now()
);

CREATE SEQUENCE domain.customers_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE domain.customers_id_seq OWNED BY domain.customers.id;

CREATE VIEW reporting.v_customers AS
SELECT
    NULL::integer AS customer_id,
    NULL::text AS name;

ALTER TABLE ONLY domain.customers
    ALTER COLUMN id SET DEFAULT nextval('domain.customers_id_seq'= ::regclass);

ALTER TABLE ONLY domain.customers
    ADD CONSTRAINT customers_email_key UNIQUE (email);

ALTER TABLE ONLY domain.customers
    ADD CONSTRAINT customers_pkey PRIMARY KEY (id);

CREATE OR REPLACE VIEW reporting.v_customers AS
 SELECT c.id AS customer_id,
        c.name
   FROM domain.customers c
  GROUP BY c.id;
-- end foo.sql

2. Create a database foo 

createdb --host=3Dlocalhost --port=3D5432 --username=3Dpostgres foo

3. Load file into database 

 psql -U postgres -f foo.sql foo
 
4. create dump

pg_dump  --host=3Dlocalhost --port=3D5432 --username=3Dpostgres --form= at=3Dc --file dump foo

5. create database restore_foo

createdb --host=3Dlocalhost --port=3D5432 --username=3Dpostgres restore_foo=

6. restore database

pg_restore -Fc --verbose --no-owner --clean --if-exists --no-privileges -d = restore_foo -U postgres dump

pg_restore log:

pg_restore: connecting to database for restore
pg_restore: executing SELECT pg_catalog.set_config('search_path', '', false= );
pg_restore: dropping RULE v_customers _RETURN
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 3450; 2618 22119 RULE v_customers _RETURN postgr= es
pg_restore: error: could not execute query: ERROR:  schema "repor= ting" does not exist
Command was: CREATE OR REPLACE VIEW reporting.v_customers AS
SELECT
    NULL::integer AS customer_id,
    NULL::text AS name;
pg_restore: dropping CONSTRAINT customers customers_pkey
pg_restore: dropping CONSTRAINT customers customers_email_key
pg_restore: dropping DEFAULT customers id
pg_restore: dropping VIEW v_customers
pg_restore: dropping SEQUENCE customers_id_seq
pg_restore: dropping TABLE customers
pg_restore: dropping SCHEMA reporting
pg_restore: dropping SCHEMA domain
pg_restore: creating SCHEMA "domain"
pg_restore: creating SCHEMA "reporting"
pg_restore: creating TABLE "domain.customers"
pg_restore: creating SEQUENCE "domain.customers_id_seq"
pg_restore: creating SEQUENCE OWNED BY "domain.customers_id_seq"<= /div>
pg_restore: creating VIEW "reporting.v_customers"
pg_restore: creating DEFAULT "domain.customers id"
pg_restore: processing data for table "domain.customers"
pg_restore: executing SEQUENCE SET customers_id_seq
pg_restore: creating CONSTRAINT "domain.customers customers_email_key&= quot;
pg_restore: creating CONSTRAINT "domain.customers customers_pkey"=
pg_restore: creating RULE "reporting.v_customers _RETURN"
pg_restore: warning: errors ignored on restore: 1

best regards
Micha=B3 T=EAcza
=0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A= =0A=
=0A= _________________=0A=
=0A= Pozdrawiam/Best Regards=0A=
=0A= Michał Tęcza
=0A= Architekt Systemów Informatycznych
=0A= IT Architect=0A=
=0A= Mobile: =0A= =0A=
=0A= =0A=
=0A= =0A= =0A= =0A= =0A= =0A=
=0A= SOFTIQ Sp. z o.o., ul. Chorzowska 50, 44-100 Gl= iwice
=0A= Wearesoftiq Ltd, 4 Studio Court Queensway, Bletchley, Milton Keynes, England, MK2 2DG
=0A= SOFTIQ Deutschland GmbH in Gründung, Josep= h-Dollinger-Bogen 14 D-80807 Munich
=0A= =0A= =0A=
=0A=
--_000_AS4P189MB1821E9F6FCFDE0413C0A12849B3C2AS4P189MB1821EURP_--