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-09-04T03:15:24Z

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

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

On Mon, Sep 01, 2025 at 01:33:45PM +0900, Michael Paquier wrote:
> Another rebase required due to the business with BufferGetPage() in
> 710e6c4301ee.
> 
> By the way, I have remembered the reason why I have introduced
> AT_AddColumnToSequence as a new ALTER TABLE subcommands: ACL check for
> sequences.  Like views, this simplifies the object type check a lot.

Rebased as v20 due to the GUC changes in 63599896545c.
--
Michael