[Fix-17356][Dependent] error creating Dependent (#17357)

SbloodyS · web-flow · commit f81709c77b72 · 2025-07-28T10:35:57.000+08:00
diff --git a/dolphinscheduler-dao/src/main/resources/sql/dolphinscheduler_postgresql.sql b/dolphinscheduler-dao/src/main/resources/sql/dolphinscheduler_postgresql.sql
@@ -1311,7 +1311,7 @@ CREATE INDEX idx_sub_workflow_instance_id ON t_ds_relation_sub_workflow (sub_wor
 -- ----------------------------
 DROP TABLE IF EXISTS t_ds_workflow_task_lineage;
 CREATE TABLE t_ds_workflow_task_lineage (
-    id int NOT NULL,
+    id SERIAL NOT NULL,
     workflow_definition_code bigint NOT NULL DEFAULT 0,
     workflow_definition_version int NOT NULL DEFAULT 0,
     task_definition_code bigint NOT NULL DEFAULT 0,
diff --git a/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.3.1_schema/postgresql/dolphinscheduler_ddl.sql b/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.3.1_schema/postgresql/dolphinscheduler_ddl.sql
@@ -21,3 +21,17 @@ ALTER TABLE t_ds_command DROP COLUMN test_flag;
 ALTER TABLE t_ds_error_command DROP COLUMN test_flag;
 ALTER TABLE t_ds_workflow_instance DROP COLUMN test_flag;
 ALTER TABLE t_ds_task_instance DROP COLUMN test_flag;
+
+ALTER TABLE t_ds_workflow_task_lineage
+DROP CONSTRAINT t_ds_workflow_task_lineage_pkey;
+CREATE SEQUENCE t_ds_workflow_task_lineage_id_seq;
+ALTER TABLE t_ds_workflow_task_lineage
+ALTER COLUMN id TYPE integer;
+ALTER TABLE t_ds_workflow_task_lineage
+ALTER COLUMN id SET DEFAULT nextval('t_ds_workflow_task_lineage_id_seq');
+ALTER SEQUENCE t_ds_workflow_task_lineage_id_seq
+OWNED BY t_ds_workflow_task_lineage.id;
+ALTER TABLE t_ds_workflow_task_lineage
+ALTER COLUMN id SET NOT NULL;
+ALTER TABLE t_ds_workflow_task_lineage
+ADD PRIMARY KEY (id);
