Re: After upgrading to PG 12, \d in psql breaks with no more c.relhasoids

Поиск
Список
Период
Сортировка
От Keith
Тема Re: After upgrading to PG 12, \d in psql breaks with no more c.relhasoids
Дата
Msg-id CAHw75vsStdCFxxjdzvhEJpTHvE8Ds+uBK2gkEf3bi5kcibvBTQ@mail.gmail.com
обсуждение исходный текст
Ответ на After upgrading to PG 12, \d in psql breaks with no more c.relhasoids  (Wells Oliver <wells.oliver@gmail.com>)
Список pgsql-admin
Дерево обсуждения


On Tue, Oct 29, 2019 at 11:41 PM Wells Oliver <wells.oliver@gmail.com> wrote:
In psql, doing \d on a table after doing that SET WITH NO OIDS thing you need to do, breaks with:

mydb=# \d schema.table
ERROR:  column c.relhasoids does not exist
LINE 1: ...riggers, c.relrowsecurity, c.relforcerowsecurity, c.relhasoi...

Is there a clean way to fix this and restore the functionality on tables that had OIDs removed?

--


Make sure you're using the version 12 of the psql client. Old versions of the client are likely to throw this error if you run it on a 12 server since I believe the definitions of the queries used in the \d commands are stored in the client binary.

psql --version

Keith

В списке pgsql-admin по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: After upgrading to PG 12, \d in psql breaks with no more c.relhasoids
Следующее
От: Wells Oliver
Дата:
Сообщение: Forcing analyze on DB after upgrading?