Postgres Pro
Downloads
Home   >   mailing lists

After upgrading to PG 12, \d in psql breaks with no more c.relhasoids - Mailing list pgsql-admin

From Wells Oliver
Subject After upgrading to PG 12, \d in psql breaks with no more c.relhasoids
Date
Msg-id CAOC+FBVJH139feAs-iEobHhBDE2AWzX4tcOpadgkwvBLZ5Uf0w@mail.gmail.com
Whole thread Raw
Responses Re: After upgrading to PG 12, \d in psql breaks with no more c.relhasoids  (Keith <keith@keithf4.com>)
List pgsql-admin
Tree view
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?

--

pgsql-admin by date:

Previous
From: Ian Barwick
Date:
Subject: Re: Dropping functions from pg_proc table w/ querry
Next
From: Keith
Date:
Subject: Re: After upgrading to PG 12, \d in psql breaks with no more c.relhasoids