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

On Tue, Oct 29, 2019 at 11:41 PM Wells Oliver <[email protected]>
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?
>
> --
> Wells Oliver
> [email protected] <[email protected]>
>


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