Re: Sequence Access Methods, round two - Mailing list pgsql-hackers

On Tue, Dec 23, 2025 at 02:55:45PM +0800, Chao Li wrote:
> I just started to review this patch. While reviewing 0001, I got the
> point where you now add the 3 attributes into pg_attributes, so I
> tried to test this behavior, but a basic “create sequence” command
> failed for me:
> ```
> evantest=# create sequence ts1 start with 1 increment by 1 cache 10 cycle;
> ERROR:  access method "seqlocal" does not exist
> ```
>
> Did I do something wrong?

I guess so.  0001 taken independently has no link to seqlocal.
Applying the full set of patches works here:
=# create sequence ts1 start with 1 increment by 1 cache 10 cycle;
CREATE SEQUENCE

I doubt that the regression would pass at all with this class of
failures.  You may need to clean your tree and rebuild.
--
Michael