Re: psql "\d" no longer working

2023-02-12 Thread Rob Sargent
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 p

Re: psql "\d" no longer working

2023-02-12 Thread Adrian Klaver
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.r

Re: psql "\d" no longer working

2023-02-12 Thread Ron
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

Re: psql "\d" no longer working

2023-02-12 Thread Adrian Klaver
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.kla...@aklaver.co

Re: psql "\d" no longer working

2023-02-12 Thread Georg H.
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 lis

psql "\d" no longer working

2023-02-12 Thread 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 rela