supabase / pgadmin4

Mirror of the pgAdmin 4 GIT repo. DO NOT submit pull requests here! Use the pgadmin-hackers@lists.postgresql.org mailing list. Issues should be logged at https://redmine.postgresql.org/projects/pgadmin4.
https://www.pgadmin.org
Other
12 stars 2 forks source link

Duplicate sequences for identity columns #25

Open soedirgo opened 2 years ago

soedirgo commented 2 years ago

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.