From: MichaelDBA Vitale <michaeldba@sqlexec.com>
To: David G. Johnston <david.g.johnston@gmail.com>
To: Murthy Nunna <mnunna@fnal.gov>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: pg_upgrade failure upgrading from v10.8 to v14.4
Date: Fri, 22 Jul 2022 13:43:30 -0400 (EDT)
Message-ID: <50242238.594620.1658511810130@email.ionos.com> (raw)
In-Reply-To: <CAKFQuwamnT7AQyk4oHRKObLs+2rWxZKc8WT96ExyQwuUXKMHKQ@mail.gmail.com>
References: <DM8PR09MB667740FCD23BCFECA20E8A3CB8909@DM8PR09MB6677.namprd09.prod.outlook.com>
<CAKFQuwYKaU7eOpO2Z++TuDZX4GzVYmbgPpm0wdoRmW_O=FyGwQ@mail.gmail.com>
<1907988893.588756.1658509981368@email.ionos.com>
<DM8PR09MB6677FCDD0FD07ED0BDA0DFF4B8909@DM8PR09MB6677.namprd09.prod.outlook.com>
<CAKFQuwamnT7AQyk4oHRKObLs+2rWxZKc8WT96ExyQwuUXKMHKQ@mail.gmail.com>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
Hmmm, catalog views are in the pg_catalog schema, not the public schema.
</div>
<div class="default-style">
</div>
<div class="default-style">
Only extensions or user-defined stuff would be created in the public schema.
</div>
<blockquote type="cite">
<div>
On 07/22/2022 1:26 PM EDT David G. Johnston <david.g.johnston@gmail.com> wrote:
</div>
<div>
</div>
<div>
</div>
<div dir="ltr">
<div dir="ltr">
<div class="gmail_default" style="font-family: arial,helvetica,sans-serif;">
<span style="font-family: Arial,Helvetica,sans-serif;">On Fri, Jul 22, 2022 at 10:23 AM Murthy Nunna <<a href="mailto:mnunna@fnal.gov">mnunna@fnal.gov</a>> wrote:</span>
</div>
</div>
<div class="gmail_quote">
<blockquote>
<div style="overflow-wrap: break-word;">
<div class="gmail-m_-5348718172304268188WordSection1">
<p class="MsoNormal"><span style="font-size: 12pt;">I don’t 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 version before getting to 14.4.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 12pt;"> </span></p>
<p class="MsoNormal"><span style="font-size: 12pt;">CREATE VIEW "public"."all_tables" AS</span></p>
</div>
</div>
</blockquote>
<div>
</div>
<div>
<div class="gmail_default" style="font-family: arial,helvetica,sans-serif;">
The system doesn't create stuff in public. That is user-space.
</div>
<div class="gmail_default" style="font-family: arial,helvetica,sans-serif;">
</div>
<div class="gmail_default" style="font-family: arial,helvetica,sans-serif;">
David J.
</div>
<div class="gmail_default" style="font-family: arial,helvetica,sans-serif;">
</div>
</div>
</div>
</div>
</blockquote>
</body>
</html>
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: pgsql-admin@postgresql.org
Cc: michaeldba@sqlexec.com, david.g.johnston@gmail.com, mnunna@fnal.gov
Subject: Re: pg_upgrade failure upgrading from v10.8 to v14.4
In-Reply-To: <50242238.594620.1658511810130@email.ionos.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox