Inconsistency in psql output with \d+x PATTERN

Поиск
Список
Период
Сортировка
Искать

Inconsistency in psql output with \d+x PATTERN

От:
George MacKerron <george.mackerron@databricks.com>
Дата:
Hello.

While working on https://github.com/neondatabase/psql-describe, I came across what I think is minor bug in the output of psql’s `\d` with a pattern or name.

Using psql 19rc1, this command is not listed by `\?` as accepting the expanded (x) option:

```
db=# \?
...
Informational
  (options: S = show system objects, x = expanded mode, + = additional detail)
  \d[Sx+]                list tables, views, and sequences
  \d[S+]   NAME          describe table, view, sequence, or index
```

And, in general, setting the x option -- either globally with `\x on` or temporarily with `\d+x PATTERN` -- is ignored.

However, it is not ignored when describing sequences. For example:

```
db=# create table example_table (col int);
CREATE TABLE
db=# create sequence example_sequence;
CREATE SEQUENCE
db=# create index example_idx on example_table(col);
CREATE INDEX
db=# \d+x example_*
                  Index "public.example_idx"
 Column |  Type   | Key? | Definition | Storage | Stats target 
--------+---------+------+------------+---------+--------------
 col    | integer | yes  | col        | plain   | 
btree, for table "public.example_table"

Sequence "public.example_sequence"
-[ RECORD 1 ]------------------
Type      | bigint
Start     | 1
Minimum   | 1
Maximum   | 9223372036854775807
Increment | 1
Cycles?   | no
Cache     | 1

                                      Table "public.example_table"
 Column |  Type   | Collation | Nullable | Default | Storage | Compression | Stats target | Description 
--------+---------+-----------+----------+---------+---------+-------------+--------------+-------------
 col    | integer |           |          |         | plain   |             |              | 
Indexes:
    "example_idx" btree (col)
Access method: heap

```

This inconsistency seems like a bug to me.

Proximately, the bug appears to arise on line 1780 of src/bin/psql/describe.c (REL_19_RC1), where a new, shadowing `myopt` variable is created without setting `myopt.topt.expanded = false`.

History:

• In 2005, commit 3332e38189b2 disables expanded output for \d NAME.
• In 2017, commit 2a14b9609df1 redesigns sequence descriptions as a separate query and (presumably unintentionally) bypasses that disabling.
• In 2025, commit 00f4c2959d6 adds the temporary x modifier. Its regression test explicitly verifies that \d+x table remains non-expanded, but does not test a sequence.

All the best,
George



Re: Inconsistency in psql output with \d+x PATTERN

От:
Fujii Masao <masao.fujii@gmail.com>
Дата:
On Sat, Oct 17, 2026 at 1:16 AM George MacKerron
 wrote:
> This inconsistency seems like a bug to me.

Sequence descriptions have honored expanded mode since v10, so disabling it
would change longstanding behavior. Also the vertical layout seems useful
for sequence descriptions, so I'd prefer to keep the current behavior and
update the documentation instead. Thought?

We could clarify that, when a name or pattern is specified, only sequence
descriptions honor expanded mode, whether enabled globally with \x on or
\x auto, or temporarily with \d+x.

Regards,

-- 
Fujii Masao


Re: Inconsistency in psql output with \d+x PATTERN

От:
George MacKerron <george.mackerron@databricks.com>
Дата:
On 19 Oct 2026, at 11:09, Fujii Masao  wrote:

> I'd prefer to keep the current behavior and update the documentation instead. Thought?
> 
> We could clarify that, when a name or pattern is specified, only sequence descriptions honor expanded mode

Sure: I think documenting the inconsistency is a reasonable response here. Thanks.

Re: Inconsistency in psql output with \d+x PATTERN

От:
Fujii Masao <masao.fujii@gmail.com>
Дата:
Вложения:
On Mon, Oct 19, 2026 at 8:34 PM George MacKerron
 wrote:
> Sure: I think documenting the inconsistency is a reasonable response here. Thanks.

The attached patch corrects the \d+x docs for sequences. Thoughts?

Regards,

-- 
Fujii Masao

Re: Inconsistency in psql output with \d+x PATTERN

От:
shihao zhong <zhong950419@gmail.com>
Дата:
+1, I think a doc fix is good enough for this case.

Re: Inconsistency in psql output with \d+x PATTERN

От:
shihao zhong <zhong950419@gmail.com>
Дата:
Hi Fujii,

Missed your patch email, I think this patch is LGTM.

Thanks,
Shihao

Re: Inconsistency in psql output with \d+x PATTERN

От:
Fujii Masao <masao.fujii@gmail.com>
Дата:
On Tue, Oct 20, 2026 at 1:10 AM shihao zhong  wrote:
> Missed your patch email, I think this patch is LGTM.

Thanks for the review! I've pushed the patch.

Regards,

-- 
Fujii Masao


FAQ