Re: pg_upgrade failure upgrading from v10.8 to v14.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hmmm, catalog views are in the pg_catalog schema, not the public schema.
 
Only extensions or user-defined stuff would be created in the public schema.
On 07/22/2022 1:26 PM EDT David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
 
 
On Fri, Jul 22, 2022 at 10:23 AM Murthy Nunna <mnunna@xxxxxxxx> wrote:

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.

 

CREATE VIEW "public"."all_tables" AS

 
The system doesn't create stuff in public.  That is user-space.
 
David J.
 

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux