pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
psql "\d" no longer working
6+ messages / 4 participants
[nested] [flat]

* psql "\d" no longer working
@ 2023-02-12 09:02  Rob Sargent <robjsargent@gmail.com>
  0 siblings, 2 replies; 6+ messages in thread

From: Rob Sargent @ 2023-02-12 09:02 UTC (permalink / raw)
  To: pgsql-general


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.

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: psql "\d" no longer working
@ 2023-02-12 09:24  Georg H. <georg-h@silentrunner.de>
  parent: Rob Sargent <robjsargent@gmail.com>
  1 sibling, 1 reply; 6+ messages in thread

From: Georg H. @ 2023-02-12 09:24 UTC (permalink / raw)
  To: robjsargent@gmail.com; pgsql-general

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

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: psql "\d" no longer working
@ 2023-02-12 16:19  Adrian Klaver <adrian.klaver@aklaver.com>
  parent: Georg H. <georg-h@silentrunner.de>
  0 siblings, 0 replies; 6+ messages in thread

From: Adrian Klaver @ 2023-02-12 16:19 UTC (permalink / raw)
  To: Georg H. <georg-h@silentrunner.de>; robjsargent@gmail.com; pgsql-general

On 2/12/23 01:24, Georg H. wrote:
> Hello Rob,
> 

> 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.

That would be 11 and below.
> 
> 
> kind regards
> 
> Georg
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com






^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: psql "\d" no longer working
@ 2023-02-12 16:49  Ron <ronljohnsonjr@gmail.com>
  parent: Rob Sargent <robjsargent@gmail.com>
  1 sibling, 1 reply; 6+ messages in thread

From: Ron @ 2023-02-12 16:49 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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.

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: psql "\d" no longer working
@ 2023-02-12 17:02  Adrian Klaver <adrian.klaver@aklaver.com>
  parent: Ron <ronljohnsonjr@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Adrian Klaver @ 2023-02-12 17:02 UTC (permalink / raw)
  To: Ron <ronljohnsonjr@gmail.com>; pgsql-general@lists.postgresql.org

On 2/12/23 08:49, Ron wrote:
> On 2/12/23 03:02, Rob Sargent wrote:
>>
>>

>>     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?

I doubt that is the problem as the issue is the column in the table not 
finding the table. pg_class.relhasoids no longer exists 12+, so the post 
from Georg is probably pointing in the right direction.

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

-- 
Adrian Klaver
adrian.klaver@aklaver.com






^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: psql "\d" no longer working
@ 2023-02-12 18:58  Rob Sargent <robjsargent@gmail.com>
  parent: Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Rob Sargent @ 2023-02-12 18:58 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org


> I doubt that is the problem as the issue is the column in the table 
> not finding the table. pg_class.relhasoids no longer exists 12+, so 
> the post from Georg is probably pointing in the right direction.
>


Ah, yes.  My client machine at compute centre has to be told to put 
version 14 on the path.  My session there got axed/restarted and I left 
that part out.

Thanks a ton.

rjs






^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2023-02-12 18:58 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-02-12 09:02 psql "\d" no longer working Rob Sargent <robjsargent@gmail.com>
2023-02-12 09:24 ` Georg H. <georg-h@silentrunner.de>
2023-02-12 16:19   ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-02-12 16:49 ` Ron <ronljohnsonjr@gmail.com>
2023-02-12 17:02   ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-02-12 18:58     ` Rob Sargent <robjsargent@gmail.com>

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