pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql "\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>
2023-02-12 09:24 ` Re: psql "\d" no longer working Georg H. <georg-h@silentrunner.de>
2023-02-12 16:49 ` Re: psql "\d" no longer working Ron <ronljohnsonjr@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: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 ` Re: psql "\d" no longer working Adrian Klaver <adrian.klaver@aklaver.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 09:02 psql "\d" no longer working Rob Sargent <robjsargent@gmail.com>
2023-02-12 09:24 ` Re: psql "\d" no longer working Georg H. <georg-h@silentrunner.de>
@ 2023-02-12 16:19 ` Adrian Klaver <adrian.klaver@aklaver.com>
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 09:02 psql "\d" no longer working Rob Sargent <robjsargent@gmail.com>
@ 2023-02-12 16:49 ` Ron <ronljohnsonjr@gmail.com>
2023-02-12 17:02 ` Re: psql "\d" no longer working Adrian Klaver <adrian.klaver@aklaver.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 09:02 psql "\d" no longer working Rob Sargent <robjsargent@gmail.com>
2023-02-12 16:49 ` Re: psql "\d" no longer working Ron <ronljohnsonjr@gmail.com>
@ 2023-02-12 17:02 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-02-12 18:58 ` Re: psql "\d" no longer working Rob Sargent <robjsargent@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 09:02 psql "\d" no longer working Rob Sargent <robjsargent@gmail.com>
2023-02-12 16:49 ` Re: psql "\d" no longer working Ron <ronljohnsonjr@gmail.com>
2023-02-12 17:02 ` Re: psql "\d" no longer working Adrian Klaver <adrian.klaver@aklaver.com>
@ 2023-02-12 18:58 ` Rob Sargent <robjsargent@gmail.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