On Sun, 16 May 2021 at 13:00, David G. Johnston <david.g.johns...@gmail.com> wrote: > > On Saturday, May 15, 2021, Venkata B Nagothi <nag1...@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_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.
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
