Re: Postgres upgrade 12 - issues with OIDs - Mailing list pgsql-general

From David G. Johnston
Subject Re: Postgres upgrade 12 - issues with OIDs
Date
Msg-id CAKFQuwYj_x7S9Tb_9B69cMokgM7xWohxc9ysRysb86va53iTpw@mail.gmail.com
Whole thread Raw
In response to Re: Postgres upgrade 12 - issues with OIDs  (Venkata B Nagothi <nag1010@gmail.com>)
Responses Re: Postgres upgrade 12 - issues with OIDs
Re: Postgres upgrade 12 - issues with OIDs
List pgsql-general
On Saturday, May 15, 2021, Venkata B Nagothi <nag1010@gmail.com> wrote:


ERROR:  column c.relhaspkey does not exist at character 33


Below is the query generating the error :

STATEMENT:  SELECT c.relname AS table_name, c.relhaspkey AS has_primary_key FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE c.relkind = 'r' AND c.relnamespace = n.oid AND n.nspname = $1 

Any advice on how bad it is and how to get rid of it would be great.  

Figure out what is issuing the query and either fix it or upgrade to a version that has been fixed.

David J.

pgsql-general by date:

Previous
From: Venkata B Nagothi
Date:
Subject: Re: Postgres upgrade 12 - issues with OIDs
Next
From: Julien Rouhaud
Date:
Subject: Re: Empty tablespace directory after restore with psql -d dbname -f dump.sql