Re: Sequence Access Methods, round two

From: Kirill Reshke <reshkekirill(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Peter Eisentraut <peter(at)eisentraut(dot)org>, Peter Smith <smithpb2250(at)gmail(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Sequence Access Methods, round two
Date: 2025-08-19 05:14:33
Message-ID: CALdSSPj5TUM6vi=DtzUVRw9XvRwsToy4QyE2uFY=NeDiNNXmiw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 18 Aug 2025 at 18:15, I wrote:

> I have a small enhancement to the patch set.

I played with patch sets some more, trying to break things in nasty
ways (something like CREATE OPERATOR FAMILY ff USING seqlocal or other
incorrect ddl).
But I had no success. I will try some more later, maybe I will find something

But while doing so I noticed another small enhancement for the patch
set. This change is not that big, so attaching as diff.

PFA diff which describes the access method of sequence on \d+ psql
meta-command likewise we do it for tables.

Example:
```
reshke=# \d+ dd
Sequence "public.dd"
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
Access method: seqlocal

reshke=# \d+ s4
Sequence "public.s4"
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
Access method: aa
```

--
Best regards,
Kirill Reshke

Attachment Content-Type Size
describe_enhasement.diff application/octet-stream 2.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Julien Rouhaud 2025-08-19 05:15:37 Re: Plan caching and serialization for reuse across executions
Previous Message Daniil Davydov 2025-08-19 03:57:42 Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue