relname | relnamespace | relpersistence --------------------------+--------------+---------------- <sequence1> | 524799410 | p <sequence2> | 524799410 | p (2 rows)
On Wed, 29 Oct 2025 at 17:28, Adrian Klaver <[email protected]> wrote: > > On 10/29/25 06:40, Colin 't Hart wrote: > > As expected the dump contains: > > > > CREATE TABLE <schema>.<tablename> ( > > <other columns>, > > id bigint NOT NULL > > ); > > > > <snip> > > > > -- > > -- Name: <sequence1>; Type: SEQUENCE; Schema: <schema>; Owner: <owner> > > -- > > > > ALTER TABLE <schema>.<tablename> ALTER COLUMN id ADD GENERATED ALWAYS > > AS IDENTITY ( > > SEQUENCE NAME <schema>.<sequence1> > > START WITH 1 > > INCREMENT BY 1 > > NO MINVALUE > > NO MAXVALUE > > CACHE 1 > > ); > > > > > > -- > > -- Name: <sequence2>; Type: SEQUENCE; Schema: <schema>; Owner: <owner> > > -- > > > > ALTER TABLE <schema>.<tablename> ALTER COLUMN id ADD GENERATED ALWAYS > > AS IDENTITY ( > > SEQUENCE NAME <schema>.<sequence2> > > START WITH 1 > > INCREMENT BY 1 > > NO MINVALUE > > NO MAXVALUE > > CACHE 1 > > ); > > Just a wild guess. Assuming <schema> is the same, what is the output of: > > SELECT > relname, > relnamespace, > relpersistence > FROM > pg_class > WHERE > relname IN ('<sequence1>', '<sequence2> ') > AND relnamespace = '<schema>'::regnamespace; > > > > > > > /Colin > > > > -- > Adrian Klaver > [email protected]
