can't init dbsync when table has an index on id column?

[geographit2]

I can't seem to start dbsync , initialised from the database when my table has a btree index on the id column.

CREATE TABLE my_polygon_table (
	id INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
	comment text,
	date date, 
	recorded_by text, 
	validated boolean, 
	validated_by text,
	geom geometry(Polygon,4326)
);

CREATE INDEX IF NOT EXISTS my_polygon_table_geom_gist
    ON my_polygon_table USING gist (geom);

CREATE INDEX IF NOT EXISTS my_polygon_table_id_btree
    ON my_polygon_table USING btree (id);

I get this error in dbsync :

Error: postgres cmd error: ERROR:  column "id" specified more than once
 | 
 | 
 | SQL:
 | CREATE TABLE "z_for_mergin_use_only_db_sync"."my_polygon_table" ("id" integer NOT NULL, "id" integer NOT NULL, "comment" text, "date" date, "recorded_by" text, "validated" boolean, "validated_by" text, "geom" geometry(Polygon,4326), PRIMARY KEY ("id"));

However if I do the same without creating an index it works fine.

[ValentinBuira]

Hi @geographit2 thanks for the bug report that's indeed looks bad to not be able to use btree, I'll give it a try on my end with the SQL you provided, thanks you

[wojtek19022]

Hi @ValentinBuira & @geographit2 I actually encountered the same problem but using only GIST and regular indexes. This problem didn't appear due to a use of different indexing methods. It appeared due to a use of 2 indexes. In a latest db-sync version only one index is supported on one column.