Bug report
To Reproduce
On source:
create table t(id int8 generated by default as identity);
Diff with target:
CREATE SEQUENCE IF NOT EXISTS public.t_id_seq
INCREMENT 1
START 1
MINVALUE 1
MAXVALUE 9223372036854775807
CACHE 1;
ALTER SEQUENCE public.t_id_seq
OWNER TO postgres;
CREATE TABLE IF NOT EXISTS public.t
(
id bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1 )
)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public.t
OWNER to postgres;
\ds after running the above on target:
postgres=# \ds
List of relations
Schema | Name | Type | Owner
--------+-----------+----------+----------
public | t_id_seq | sequence | postgres
public | t_id_seq1 | sequence | postgres
(2 rows)
Expected behavior
The CREATE SEQUENCE ... part shouldn't exist.
Bug report
To Reproduce
On
source:Diff with
target:\dsafter running the above ontarget:Expected behavior
The
CREATE SEQUENCE ...part shouldn't exist.