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