pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: psql "\d" no longer working
Date: Sun, 12 Feb 2023 10:49:19 -0600
Message-ID: <4c04eb58-37ed-b756-501a-287f4fbc849b@gmail.com> (raw)
In-Reply-To: <a66b305d-d9ce-ddb3-4385-2d3c567de412@gmail.com>
References: <a66b305d-d9ce-ddb3-4385-2d3c567de412@gmail.com>

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.

view thread (6+ messages)  latest in thread

Message-ID: <4c04eb58-37ed-b756-501a-287f4fbc849b@gmail.com>
Permalink:  ../4c04eb58-37ed-b756-501a-287f4fbc849b@gmail.com/
Also on:    postgresql.org/message-id/4c04eb58-37ed-b756-501a-287f4fbc849b@gmail.com

 · 

reply

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: ronljohnsonjr@gmail.com
  Subject: Re: psql "\d" no longer working
  In-Reply-To: <4c04eb58-37ed-b756-501a-287f4fbc849b@gmail.com>
  References: <a66b305d-d9ce-ddb3-4385-2d3c567de412@gmail.com> <4c04eb58-37ed-b756-501a-287f4fbc849b@gmail.com>

* 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