Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pR8al-0003JQ-Cq for pgsql-general@arkaria.postgresql.org; Sun, 12 Feb 2023 09:24:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pR8aj-0003RI-6o for pgsql-general@arkaria.postgresql.org; Sun, 12 Feb 2023 09:24:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pR8ai-0003Nx-QP for pgsql-general@lists.postgresql.org; Sun, 12 Feb 2023 09:24:12 +0000 Received: from mout.kundenserver.de ([217.72.192.74]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pR8ad-0002ol-Q3 for pgsql-general@postgresql.org; Sun, 12 Feb 2023 09:24:12 +0000 Received: from [192.168.0.150] ([217.250.63.163]) by mrelayeu.kundenserver.de (mreue109 [212.227.15.183]) with ESMTPSA (Nemesis) id 1M5fUy-1pTsg22ECA-0079Ud; Sun, 12 Feb 2023 10:24:04 +0100 Content-Type: multipart/alternative; boundary="------------RKR7x4Bwuile9H1QPzHiYbi8" Message-ID: <4740cc71-31c2-03b8-45fe-5ca4dff72376@silentrunner.de> Date: Sun, 12 Feb 2023 10:24:04 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.7.2 Subject: Re: psql "\d" no longer working To: robjsargent@gmail.com, pgsql-general@postgresql.org References: Content-Language: de-DE From: "Georg H." In-Reply-To: X-Provags-ID: V03:K1:X7fImi0X23YtyGsnacWmDf+XvEooJE7A7bTMQ1qsHXthvcIgFqX 5IQii06BS5gwydj8QLKbSrTW0EBQMSTYHNCS54F9g5krqDGqSHjR7jILRQnkXJ9+QMz0MWI w5s+JJKbcRNsJzrErD/jIaeRGRhNEbAWyr37I9Ny/prbZaoelq1W66AEo+5vSm+EggYg4OT 5jIrWxSmZ7/RuOg9U5GuA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:/jjrJPpEzO8=;LSViMbbHa+U4CfecjAPyXy8fIPI doMREPzUiRP8peXIR5fpIdybx0jCxd/wlAsfNpboH9OPvIvSZ2TZ2gGOZBHI1T9ZrcB+ezY9g 0bgh/WZSDsHOvMEV+hhCZ+hs/kJdx/NdjgDzCUz+o66JnSxagmjp12dUChWzDhe7cqsIZzUEL i9nNpc0tXoKddy8vrjqO2kS2YkpzC53misGu15WA8yOe4xMl1SC/0Gq7yyZUuKCIp1BGFF408 kBMUuTV4RbObUM3kQqBBuG4P5p3zhQUpJjtDqW1ak9Fu1tRWH2aArnY6tvH6hC0x4p7NY65dP lXkQbQ0gSkGdxOq1Y+8iwuhtooTWky8yKnK32h0L4OEhPBi3Zc0gQvCXAdjiiZr6zKD4Jli82 wm0Z7QBfrOdGZ9r+Ot/7vIWmYW9C+NCaNTIYDzrZbrjBhWAVHXBSzkOaZa3lD1+lmehg44nHh KjZ/55SNkMX7OMUSnIc6U5o5zpLtXqLzLwIEvt+cZsN9WlIjC1Lhe3wx7QW2NrXSf48ZRxXCF M14p+Ud7ECF3nrto1vZi8ybdsiYPkrKkqnj6ZFKQM+M0656mZEBk2qbicTd4BG+9/F9xsymFs rJo9/+eN4ZIntv9Ld3prA7HHBbWdNdSEQhjie9FUpsb953ZWSA/9ljmgBKlrnafRd2m+Xfoay /PFsxeuoTDkx4fLkfqGGEUZHWXjvHYq03NkKtEd48g== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------RKR7x4Bwuile9H1QPzHiYbi8 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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 --------------RKR7x4Bwuile9H1QPzHiYbi8 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

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

--------------RKR7x4Bwuile9H1QPzHiYbi8--