Re: Sequence Access Methods, round two

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>

To: Kirill Reshke <reshkekirill@gmail.com>

Cc: Peter Eisentraut <peter@eisentraut.org>, Peter Smith <smithpb2250@gmail.com>, Postgres hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-10-07T07:46:36Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Refactor init_params() in sequence.c to not use FormData_pg_sequence_data
- ba3d93b2e806 19 (unreleased) landed
Fix comment thinko in sequence.c
- 17a3f79f812c 17.0 landed
Group more closely cache updates for backends in sequence.c
- 6e951bf98e2e 17.0 landed
Introduce sequence_*() access functions
- 449e798c77ed 17.0 landed

Attachments

v22-0001-Integrate-addition-of-attributes-for-sequences-w.patch (text/x-diff) patch v22-0001
v22-0002-Refactor-code-for-in-core-local-sequences.patch (text/x-diff) patch v22-0002
v22-0003-Sequence-access-methods-backend-support.patch (text/x-diff) patch v22-0003
v22-0004-Sequence-access-methods-dump-restore-support.patch (text/x-diff) patch v22-0004
v22-0005-Sequence-access-methods-core-documentation.patch (text/x-diff) patch v22-0005
v22-0006-Refactor-logic-for-page-manipulations-of-sequenc.patch (text/x-diff) patch v22-0006
v22-0007-snowflake-Add-sequence-AM-based-on-it.patch (text/x-diff) patch v22-0007

On Fri, Oct 03, 2025 at 05:24:29PM +0900, Michael Paquier wrote:
> Rebased as v21 due to conflicts in the TAP tests of pg_dump.

A few more conflicts, with htup_details.h and the addition of the page
LSN to pg_get_sequence_data().  Patch set now at v22.
--
Michael