Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oEwgc-0005aG-QY for pgsql-admin@arkaria.postgresql.org; Fri, 22 Jul 2022 17:43:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oEwgb-0003BP-JH for pgsql-admin@arkaria.postgresql.org; Fri, 22 Jul 2022 17:43:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oEwgb-0003B7-8n for pgsql-admin@lists.postgresql.org; Fri, 22 Jul 2022 17:43:37 +0000 Received: from mout.perfora.net ([74.208.4.196]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oEwgY-0005xm-Qg for pgsql-admin@postgresql.org; Fri, 22 Jul 2022 17:43:36 +0000 Received: from oxusgaltgw05.schlund.de ([10.72.72.51]) by mrelay.perfora.net (mreueus002 [74.208.5.2]) with ESMTPSA (Nemesis) id 0MKpGg-1oEwgU3Qi8-0005jZ; Fri, 22 Jul 2022 19:43:30 +0200 Date: Fri, 22 Jul 2022 13:43:30 -0400 (EDT) From: MichaelDBA Vitale To: "David G. Johnston" , Murthy Nunna Cc: "pgsql-admin@postgresql.org" Message-ID: <50242238.594620.1658511810130@email.ionos.com> In-Reply-To: References: <1907988893.588756.1658509981368@email.ionos.com> Subject: Re: pg_upgrade failure upgrading from v10.8 to v14.4 MIME-Version: 1.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Priority: 3 Importance: Normal X-Mailer: Open-Xchange Mailer v7.10.6-Rev18 X-Originating-Client: open-xchange-appsuite X-Provags-ID: V03:K1:2y7mXqvUJrw0CkLuV9SIBFNcQ6kYMA0Z4sa3VQD3wbCs+KIIQ4R CTdIF9w7y5gEfWJ2VLSPpMVsADh+9Dj3nu6zK6sR55dhryDTz/vfCNyHoMpp9Jtpg1I5QQS qNs2W6ipqWPYJ2Oh9mEBe6k1WnWW3t3uFbyB9XE2s52UK1nvR3vJ/N3jqljTnU+hqoU4GKf +SJ3efy6nd0PQyVw6K2Bg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:/M7SWveQr+4=:QdH+zOKSPMhlsAHsKfSln0 BzW2NcDJBMkTeBhmEVh2H4qrIYLwFD9nQgSS+BvjeUz7fyuuJEdZx9dMRKmRLhy8UnWbs3ezt 57hG/3clU5YQytQFluygyYI+h6himiS6thvBfQNlCNstA76NK4TwuWapXnMfQ/sebBvDDHTTr AMwOtk/2GsCPiUQ+es+ZO3UIeriIRUT/hXiDVCy8CMNE5wTyatOkXTQE9Gh0AkGGRtZkSXSqb r650wz9kmwS6q1iHy4mxNJGPBN4BrMRZZytudeLsMei9u3OZXN6qfXV/r2YY606vPjLGY4I9T m0+3Adlg4JdyfDNlmE4JsOqZDfP/vl4beVLVPZykfTp+SvvfDvK3EEordeMJuZvz9nkKvB653 EDbAQzCVSuUUkYJVHbozILnJenVJZrc9bRlzRPYURDEmNBAVDrVbUdLhj5Z+uMAn/2R4i0ttG vwruByv3mUporrXYpKyfj84+/j3+gfUwrstTU0bm+Kxv65WQDrcC4zkLfH14cEinjvwOo0KyO i8W3C5APjR8X2dqxqyljRZMX2dfh8z1zPgyVU8Gb8wABH8gPHKXGd1WWViF8hufCtmyWo46Rr InqYOKDHNb2a1vZWy4HMR0y4crqsUbel/RcV1ooOcxOqbx4m+GmOOwWmSYbe7HSQJ18bVehKX qvikQxwFRnMu3I1gwUJydbCgY4n1e9gDRp9ZZM6u2xEGXWc8vJkRPeH3psEbTQKXJazXN5wth IlbZO1pqM6Spb66o List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk =20 =20

Hmmm, catalog views are in the pg_catalog schema, not the public schema.

=20

Only extensions or user-defined stuff would be created in the public sch= ema.

=20

=20
On 07/22/2022 1:26 PM EDT David G. Johnston <david.g.johnston@gmail.= com> wrote:
=20

=20

=20
=20
=20
On Fri, Jul = 22, 2022 at 10:23 AM Murthy Nunna <mn= unna@fnal.gov> wrote:
=20
=20
=20
=20
=20
=20
I don=E2=80= =99t think I am failing in a user created table. Looks like the failed view= is one of the catalog views. Looks like I have to go to an intermediate ve= rsion before getting to 14.4.
=20

=20
CREATE VIEW= "public"."all_tables" AS
=20
=20
=20
=20

=20
=20
The system doesn't create stuff in public. That is user-space.
=20

=20
David J.
=20

=20
=20
=20
=20