How to fix "ERROR: column c.relhasoids does not exist" in Postgres?

Question

I’m trying to CREATE TABLE command in Postgresql. After creating a table, if I punch in TABLE table name, it works.

But I punch in \d table name, I keep getting an error below.

ERROR: column c.relhasoids does not exist LINE 1: ...riggers, c.relrowsecurity, c.relforcerowsecurity, c.relhasoi...

I attempted DROP DATABASE table name recreated a database and recreated a table again several times. But it didn't work.

Any suggestions would be appreciated! Thank you.

Answer 1

I am able to reproduce your error if I am using Postgres v.12 and an older client (v.11 or earlier):

[root@def /]# psql -h 172.17.0.3 psql (11.5, server 12.0) WARNING: psql major version 11, server major version 12.          Some psql features might not work. Type "help" for help.  postgres=# create table mytable (id int, name text); CREATE TABLE postgres=# table mytable;  id | name  ----+------ (0 rows)  postgres=# \d mytable; ERROR:  column c.relhasoids does not exist LINE 1: ...riggers, c.relrowsecurity, c.relforcerowsecurity, c.relhasoi...                                                              ^ postgres=#  

This is because in v. 12, table OIDs are no longer treated as special columns, and hence the relhasoids column is no longer necessary. Please make sure you're using a v. 12 psql binary so you don't encounter this error.

You may not necessarily be using psql, so the more general answer here is to make sure you’re using a compatible client.