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

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: After upgrading to PG 12, \d in psql breaks with no more c.relhasoids
Date: 2019-10-30 03:40:42
Message-ID: CAOC+FBVJH139feAs-iEobHhBDE2AWzX4tcOpadgkwvBLZ5Uf0w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2019-10-30 03:52:47 Re: After upgrading to PG 12, \d in psql breaks with no more c.relhasoids
Previous Message Ian Barwick 2019-10-30 03:26:46 Re: Dropping functions from pg_proc table w/ querry