Обсуждение: After upgrading to PG 12, \d in psql breaks with no more c.relhasoids

Поиск
Список
Период
Сортировка

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

От
Wells Oliver
Дата:
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?

--

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

От
Keith
Дата:


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

Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера