From: Georg H. <georg-h@silentrunner.de>
To: robjsargent@gmail.com
To: pgsql-general@postgresql.org
Subject: Re: psql "\d" no longer working
Date: Sun, 12 Feb 2023 10:24:04 +0100
Message-ID: <4740cc71-31c2-03b8-45fe-5ca4dff72376@silentrunner.de> (raw)
In-Reply-To: <a66b305d-d9ce-ddb3-4385-2d3c567de412@gmail.com>
References: <a66b305d-d9ce-ddb3-4385-2d3c567de412@gmail.com>
Hello Rob,
Am 12.02.2023 um 10:02 schrieb Rob Sargent:
>
>
> Seems I've lost the table definition meta-command
>
> riftehr=> \d actual_and_inf_rel_clean_final
> ERROR: column c.relhasoids does not exist
> LINE 1: ..., c.relhasindex, c.relhasrules, c.relhastriggers,
> c.relhasoi...
>
> while listing tables still works
>
> riftehr=> \dt act*
> List of relations
> Schema | Name | Type | Owner
> --------+-------------------------------------------+-------+-------
> cell | actual_and_inf_rel_clean_final | table | cell
> cell | actual_and_inf_rel_clean_final_count_rels | table | cell
> cell | actual_and_inf_rel_part1 | table | cell
> cell | actual_and_inf_rel_part1_unique | table | cell
> cell | actual_and_inf_rel_part1_unique_clean | table | cell
> cell | actual_and_inf_rel_part2 | table | cell
> cell | actual_and_inf_rel_part2_unique | table | cell
> cell | actual_and_inf_rel_part2_unique_clean | table | cell
> (8 rows)
>
> riftehr=> select version();
> version
> ---------------------------------------------------------------------------------------------------------
> PostgreSQL 14.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC)
> 8.5.0 20210514 (Red Hat 8.5.0-16), 64-bit
> (1 row)
>
> The server was restarted Friday morning (according to systemctl) and
> the log file has the complete sql statement:
>
> 2023-02-10 13:42:55.214 MST [524159] STATEMENT: SELECT
> c.relchecks, c.relkind, c.relhasindex, c.relhasrules,
> c.relhastriggers, c.relhasoids, '', c.reltablespace, CASE WHEN
> c.reloftype = 0 THEN '' ELSE
> c.reloftype::pg_catalog.regtype::pg_catalog.text END, c.relpersistence
> FROM pg_catalog.pg_class c
> LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid =
> tc.oid)
> WHERE c.oid = '219319';
> 2023-02-10 13:43:01.143 MST [524159] ERROR: column c.relhasoids
> does not exist at character 80
>
> but I don't see any other issue in the log file.
>
> I have yet to find another broken meta-command and no sql of mine has
> failed along similar lines as had "\d"
>
> Any pointers much appreciated.
>
Check the version of your psql binary. I assume it's below v13.
There was a change in pg_catalog.
Clients below 13 assume, the column is still there.
kind regards
Georg
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: georg-h@silentrunner.de, robjsargent@gmail.com
Subject: Re: psql "\d" no longer working
In-Reply-To: <4740cc71-31c2-03b8-45fe-5ca4dff72376@silentrunner.de>
References: <a66b305d-d9ce-ddb3-4385-2d3c567de412@gmail.com> <4740cc71-31c2-03b8-45fe-5ca4dff72376@silentrunner.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox