Re: Postgres upgrade 12 - issues with OIDs

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Postgres upgrade 12 - issues with OIDs
Дата
Msg-id CAKFQuwYj_x7S9Tb_9B69cMokgM7xWohxc9ysRysb86va53iTpw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres upgrade 12 - issues with OIDs  (Venkata B Nagothi <nag1010@gmail.com>)
Ответы Re: Postgres upgrade 12 - issues with OIDs  (David Rowley <dgrowleyml@gmail.com>)
Re: Postgres upgrade 12 - issues with OIDs  (Venkata B Nagothi <nag1010@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Venkata B Nagothi
Дата:
Сообщение: Re: Postgres upgrade 12 - issues with OIDs
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Empty tablespace directory after restore with psql -d dbname -f dump.sql