BUG #18731: The psql \d command does not exactly match but can be executed

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: zengman(at)halodbtech(dot)com
Subject: BUG #18731: The psql \d command does not exactly match but can be executed
Date: 2024-12-03 09:49:44
Message-ID: 18731-1d54c3fe1171a9d5@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18731
Logged by: Man Zeng
Email address: zengman(at)halodbtech(dot)com
PostgreSQL version: 16.6
Operating system: centos-8
Description:

Hi everyone,

I accidentally found that the \d command in psql does not match exactly, but
it can be executed. Just like the demo below.

[postgres(at)iZuf6hwo0wgeev4dvua4csZ postgres]$ psql
psql (16.6)
Type "help" for help.

postgres=# \dxabcdef plpgsql
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)

postgres=# \dx plpgsql
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)

postgres=# \dxabcdef
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)

Then I looked at the code, taking \dxabcdef as an example, psql only cares
about the previous \dx, so you can enhance the "exec_command_d" to match
normally.
But I don't want to introduce a lot of string matching here to solve this
problem, maybe there is a better idea.
At the same time I'm not sure if this is a known problem or a bug.
I look forward to your reply.

Thanks,
Man Zeng

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2024-12-03 12:23:01 BUG #18732: Segfault in pgbench on max_connections starvation
Previous Message Thomas Munro 2024-12-03 08:03:55 Re: BUG #18711: Attempting a connection with a database name longer than 63 characters now fails