Re: Sequence Access Methods, round two

On Mon, 18 Aug 2025 at 09:49, Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>

> We could just
> reuse AlterColumn, saving from the extra sub-command. What do you
> think?

Yes, this resonates with me better.

> Rebased the rest as attached, for now.

I have a small enhancement to the patch set.
In v17-0003:
```
reshke(at)yezzey-cbdb-bench:~/cpg$ git diff
diff --git a/src/bin/psql/tab-complete.in.c b/src/bin/psql/tab-complete.in.c
index 8ac13b26fe6..84b7f55fd73 100644
--- a/src/bin/psql/tab-complete.in.c
+++ b/src/bin/psql/tab-complete.in.c
@@ -3365,7 +3365,7 @@ match_previous_words(int pattern_id,
COMPLETE_WITH("TYPE");
/* Complete "CREATE ACCESS METHOD <name> TYPE" */
else if (Matches("CREATE", "ACCESS", "METHOD", MatchAny, "TYPE"))
- COMPLETE_WITH("INDEX", "TABLE");
+ COMPLETE_WITH("INDEX", "TABLE", "SEQUENCE");
/* Complete "CREATE ACCESS METHOD <name> TYPE <type>" */
else if (Matches("CREATE", "ACCESS", "METHOD", MatchAny,
"TYPE", MatchAny))
COMPLETE_WITH("HANDLER");
```

--
Best regards,
Kirill Reshke