Postgres Pro
Downloads
Home   >   mailing lists

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

From Keith
Subject Re: After upgrading to PG 12, \d in psql breaks with no more c.relhasoids
Date
Msg-id CAHw75vsStdCFxxjdzvhEJpTHvE8Ds+uBK2gkEf3bi5kcibvBTQ@mail.gmail.com
Whole thread Raw
In response to After upgrading to PG 12, \d in psql breaks with no more c.relhasoids  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view


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 by date:

Previous
From: Wells Oliver
Date:
Subject: After upgrading to PG 12, \d in psql breaks with no more c.relhasoids
Next
From: Wells Oliver
Date:
Subject: Forcing analyze on DB after upgrading?