Eric-YBC commented on issue #17318:
URL:
https://github.com/apache/dolphinscheduler/issues/17318#issuecomment-3031431770
Yes , I have tried to modify the pg ddl and let our devops to create the
table again.
Now I can add the dependent task but still can not delete the task
new DDL :
DROP TABLE IF EXISTS t_ds_workflow_task_lineage;
CREATE TABLE t_ds_workflow_task_lineage (
id bigserial 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,
task_definition_version int NOT NULL DEFAULT 0,
dept_project_code bigint NOT NULL DEFAULT 0,
dept_workflow_definition_code bigint NOT NULL DEFAULT 0,
dept_task_definition_code bigint NOT NULL DEFAULT 0,
create_time timestamp NOT NULL DEFAULT current_timestamp,
update_time timestamp NOT NULL DEFAULT current_timestamp,
PRIMARY KEY (id)
);
create index idx_workflow_code_version on t_ds_workflow_task_lineage
(workflow_definition_code,workflow_definition_version);
create index idx_task_code_version on t_ds_workflow_task_lineage
(task_definition_code,task_definition_version);
create index idx_dept_code on t_ds_workflow_task_lineage
(dept_project_code,dept_workflow_definition_code,dept_task_definition_code);
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
