PostgreSQL 12 ERROR: column "relhasoids" does not exist

[denisorlov]

PostgreSQL 12.1

Error SQL:

ERROR:  column "relhasoids" does not exist
LINE 1: SELECT relhasoids FROM pg_catalog.pg_class WHERE relname='us...
               ^
In operator:

SELECT relhasoids FROM pg_catalog.pg_class WHERE relname='user'
			AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname='usersm')

cause:
https://stackoverflow.com/questions/58461178/how-to-fix-error-column-c-relhasoids-does-not-exist-in-postgres

solution commited:
phppgadmin/phppgadmin@418b7e1

Can you fix it please?

[wapmorgan]

Should be fixed with new PhpPgAdmin (#4)

[atkrad]

@denisorlov @wapmorgan Please see my comment: #4 (comment)

[mainangethe]

A simpler explanation for future Googlers.

TLD

This occurs when you're most likely reviewing a table made from v12+ but reviewing it in a psql/ Postgres client that is below that version (v11-).
Solution is to ensure your client is at least 12+.

Root Cause

OIDs column types are no longer special columns in v12+, hence the break
Reference Site