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

From David Rowley
Subject Re: Postgres upgrade 12 - issues with OIDs
Date
Msg-id CAApHDvogn441-RfRNOAwB8mPzgeWovR9gqgmBcmXq=EGhpwqkg@mail.gmail.com
Whole thread Raw
In response to Re: Postgres upgrade 12 - issues with OIDs  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
On Sun, 16 May 2021 at 13:00, David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> On Saturday, May 15, 2021, Venkata B Nagothi <nag1010@gmail.com> wrote:
>> 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_namespacen 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.

Just in addition to that, the relhaspkey column was removed in v11.
There's mention of this and a hint at what you might want to do to
work around the removal of the column in the release notes for that
version: https://www.postgresql.org/docs/release/11.0/

David



pgsql-general by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Empty tablespace directory after restore with psql -d dbname -f dump.sql
Next
From: Condor
Date:
Subject: Re: Question about integer out of range in function