BUG #16005: cannot use \d to get description of table
The following bug has been logged on the website:
Bug reference: 16005
Logged by: mariel cherkassky
Email address: mariel.cherkassky@gmail.com
PostgreSQL version: 12beta3
Operating system: centos6
Description:
I just upgraded from 11 to 12betav3 in one of my test environments.
Whenever I try to get description of a table with \d I'm getting the
following error :
postgres=# \d backup
2019-09-12 15:35:11.165 IDT [27877] ERROR: column c.relhasoids does not
exist at character 121
2019-09-12 15:35:11.165 IDT [27877] STATEMENT: SELECT c.relchecks,
c.relkind, c.relhasindex, c.relhasrules, c.relhastriggers, c.relrowsecurity,
c.relforcerowsecurity, c.relhasoids, '', c.reltablespace, CASE WHEN
c.reloftype = 0 THEN '' ELSE
c.reloftype::pg_catalog.regtype::pg_catalog.text END, c.relpersistence,
c.relreplident
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid)
WHERE c.oid = '940549';
ERROR: column c.relhasoids does not exist
LINE 1: ...riggers, c.relrowsecurity, c.relforcerowsecurity, c.relhasoi...
On 2019-Sep-12, PG Bug reporting form wrote:
I just upgraded from 11 to 12betav3 in one of my test environments.
Whenever I try to get description of a table with \d I'm getting the
following error :
postgres=# \d backup
2019-09-12 15:35:11.165 IDT [27877] ERROR: column c.relhasoids does not
exist at character 121
That's right ... psql v11 is not able to interpret your v12 server's
catalog. You can use psql from v12. This is not a bug.
--
�lvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services