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 1pRFXa-00058m-5Y for pgsql-general@arkaria.postgresql.org; Sun, 12 Feb 2023 16:49:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pRFXZ-0003eZ-2P for pgsql-general@arkaria.postgresql.org; Sun, 12 Feb 2023 16:49:25 +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 1pRFXY-0003eP-Hf for pgsql-general@lists.postgresql.org; Sun, 12 Feb 2023 16:49:24 +0000 Received: from mail-qt1-x82a.google.com ([2607:f8b0:4864:20::82a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pRFXV-0007eC-LV for pgsql-general@lists.postgresql.org; Sun, 12 Feb 2023 16:49:23 +0000 Received: by mail-qt1-x82a.google.com with SMTP id w3so11486271qts.7 for ; Sun, 12 Feb 2023 08:49:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=8L1Dodz3O4oH9dkKZSJPXJR2xBmpvd3FZf4s+RlC2fY=; b=D0yTPvMZYC9NR2Bff4fcgCdypz3u42xY8oOkL/mvh5J0sUq2uNFp3DFxLoDiZ4assX b4ogHf1s7/pzKt7HRafVN4yNbViuwkcNnp418Rk4//2PRLmH/We5iDgffLCfXpq6+KWy TsvmM5AXF1ntXNW1ZfOVRC7QckjKcMdP7qOwmEDALfJiVegr8IpfMn9+0q3Zl/wlMAJ8 RpWwQ6/bLbow6I8LYDYFkgqjl/Erfopa/SyJYAt3yr2+uNLjBqN4SUlw9VieHzdnmp1h Pb8Du3C9yuvOyNgxeSFNpIIMu/LbLG9A8BRmlKkMyS3mdwt2APQxUL+ge2Ob/m/TVNgB BEPw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=8L1Dodz3O4oH9dkKZSJPXJR2xBmpvd3FZf4s+RlC2fY=; b=eD9nE8kE8VCOrRToir7vXi7eAjnZdK+oft+/V8wyxl1snGDdr5ZV84Qj7bptzqZOF+ Ro4k8it1Od2u7dVP1RdlIS1y5szfVodQ1QpsxhEuTkzoQyvl714xP3EvwhAUj3i2s5PM Vc0PCZqqF0xJ7TmtR/51yYopYFZA3lQ+2g8Ccb5CeFVR/6Mcg7B9FzAHqJahV0nMbl4s dD6Pl+i9AnV2biukgDk7nutpP7rQ1/+bZmjp1y/oz5RHVcm8WLtcMTbCPZ1luDmHcQR0 PgrGrnHWxoFefcfwicpcOyHKEVjpxM+x9Dk/w8e6uPu4N4BbOxsnIh6VICmaeosnDfLM tSqA== X-Gm-Message-State: AO0yUKVo11X8JsnFRq1Xfv1ltvqRj56xAcL4hYN2Ax/gF5aeY6rpXZgD SNJ6aTtN+GbrOY81eGYnYB3hJwmwwCA= X-Google-Smtp-Source: AK7set+gfFIutbabzj7/A2is8MNWnaQ5FtLaHHvjePs63YiiAwqUstgR5qUPHtcw48c8Pv0L5eB4Cg== X-Received: by 2002:a05:622a:1206:b0:3b8:2e92:94e7 with SMTP id y6-20020a05622a120600b003b82e9294e7mr38787713qtx.44.1676220560546; Sun, 12 Feb 2023 08:49:20 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::43? ([2600:1700:bd2c:b810::43]) by smtp.googlemail.com with ESMTPSA id x62-20020a37ae41000000b0072771acaf09sm7982369qke.126.2023.02.12.08.49.19 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 12 Feb 2023 08:49:20 -0800 (PST) Content-Type: multipart/alternative; boundary="------------gOlshLuh5CTK0bS7AVRfreJm" Message-ID: <4c04eb58-37ed-b756-501a-287f4fbc849b@gmail.com> Date: Sun, 12 Feb 2023 10:49:19 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: psql "\d" no longer working Content-Language: en-US To: pgsql-general@lists.postgresql.org References: From: Ron In-Reply-To: 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. --------------gOlshLuh5CTK0bS7AVRfreJm Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 2/12/23 03:02, Rob Sargent wrote: > > > 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. > What is your search_path set to? -- Born in Arizona, moved to Babylonia. --------------gOlshLuh5CTK0bS7AVRfreJm Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 2/12/23 03:02, Rob Sargent wrote:

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.


What is your search_path set to?

--
Born in Arizona, moved to Babylonia.
--------------gOlshLuh5CTK0bS7AVRfreJm--