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 1pR8Fv-0002bw-E2 for pgsql-general@arkaria.postgresql.org; Sun, 12 Feb 2023 09:02:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pR8Fu-0006Vl-8M for pgsql-general@arkaria.postgresql.org; Sun, 12 Feb 2023 09:02:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pR8Ft-0006Vb-O7 for pgsql-general@lists.postgresql.org; Sun, 12 Feb 2023 09:02:41 +0000 Received: from mail-pf1-x433.google.com ([2607:f8b0:4864:20::433]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pR8Fn-0003sW-42 for pgsql-general@postgresql.org; Sun, 12 Feb 2023 09:02:40 +0000 Received: by mail-pf1-x433.google.com with SMTP id r17so6115641pff.9 for ; Sun, 12 Feb 2023 01:02:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=subject:from:to:content-language:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=Hl2JI70lfKdBSNVZtbTob/1RSy518J0m3UBc3NfdwqI=; b=UZXOs7//zLAi9iRBLuL5zAAn04xvfr+4YMkpk7gEFEuzjxkHtpwW7OBlLKL8FeOwqY dIqDj3HZBTu/PAVgkPtmEf4QxzAdvwXUtInVuVoV6Q+ToBUcUjaYw4Y95J/XyICode1u HQOrFTePZk2+RFsQzF6tMORbFWfFqZk/NE/aucN3rGgG8m/lG1HcMeTjmol+NP+D0bHW 5XD86M6GcqHVqamlPy9hJLt5ZT5bWYRo9qwbv+WdTFQya9kH09DZNC+2C7pMHt7rW+It sgmogngUkjL7BXBAz104cBN/8Rp3CbxAajvfEWzuTKTEWNfJPBzA2eur504xtWmmpgKg Wd1A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=subject:from:to:content-language:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Hl2JI70lfKdBSNVZtbTob/1RSy518J0m3UBc3NfdwqI=; b=bhs8xA30prZwatDOi1/cyX0cGBEbeZE9aV1ANdSNAao8barAuSJcFYdGXcNr5foHs9 Lp3nBC5C2dSs4s3opNWmAGsJgf3xD5WlOULxC/HIIOoD3PQWB8SmhxOyRyWlmMCqFnA2 6h0/1W3XUY5Nry28HyjtjMzMunSbSk+vNJhfbXq2Ned0OSypjsNKgQ3F62gOCg4SFmlT aZtHrANmsS45k/Xfz4ZZSHoGi3efZ7p0fXYoTVenoGpWO45GWqboe7kKS+6i08dFKjdO 4ZbrMiJoHQ0ClLpg22nZJ4Swy75dNIM8otftf73L9o9XUMUfpR0mkcqk7PbKFMsxlGoq IlQQ== X-Gm-Message-State: AO0yUKX6ACzasb5aB9zr34c+6axgvMQfdb2887RXp0auI/2VgBXUPKTC m1TBraniL+sHR81vQofAEfsA53vdHgE= X-Google-Smtp-Source: AK7set+qVlJKhns2QLPjpYEAIuGISG/r467Hy2uDN0dFcyYqb08QUzTG15ZAKUOlvdG9HkVYUFCnLw== X-Received: by 2002:a62:8456:0:b0:5a8:adda:ffde with SMTP id k83-20020a628456000000b005a8addaffdemr814129pfd.32.1676192553463; Sun, 12 Feb 2023 01:02:33 -0800 (PST) Received: from ?IPV6:2601:681:5a00:f790:5e66:7781:391c:8aeb? ([2601:681:5a00:f790:5e66:7781:391c:8aeb]) by smtp.gmail.com with ESMTPSA id u20-20020a62ed14000000b005a879a6a21bsm3104300pfh.26.2023.02.12.01.02.32 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 12 Feb 2023 01:02:33 -0800 (PST) Content-Type: multipart/alternative; boundary="------------CtpaILJ6EY0dRs7MbF46cp2c" Message-ID: Date: Sun, 12 Feb 2023 02:02:31 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.7.1 Content-Language: en-CA To: "pgsql-general@postgresql.org" From: Rob Sargent Subject: psql "\d" no longer working 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. --------------CtpaILJ6EY0dRs7MbF46cp2c Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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. --------------CtpaILJ6EY0dRs7MbF46cp2c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

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.

--------------CtpaILJ6EY0dRs7MbF46cp2c--