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]
