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 |
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 |