zhaowanpeng opened a new issue, #17017: URL: https://github.com/apache/dolphinscheduler/issues/17017
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar feature requirement. ### Description 官方文档中介绍： 数据库：[PostgreSQL](https://www.postgresql.org/download/) (8.2.15+) 我的postgresql：postgres (PostgreSQL) 9.2.24 然而在执行时报错： [ERROR] 2025-02-14 17:16:19.894 +0800 o.a.d.a.e.ApiExceptionHandler:[47] - Meet en unknown exception: org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: org.postgresql.util.PSQLException: 错误: 语法错误 在 "ON" 或附近的 位置：142 ### The error may exist in class path resource [org/apache/dolphinscheduler/dao/mapper/TriggerRelationMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: INSERT INTO t_ds_trigger_relation (trigger_code, trigger_type, job_id, create_time, update_time) VALUES( ?,?,?,?,?) ON CONFLICT(trigger_type,job_id,trigger_code) DO UPDATE SET update_time = ?; ### Cause: org.postgresql.util.PSQLException: 错误: 语法错误 在 "ON" 或附近的 位置：142 ; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: 错误: 语法错误 在 "ON" 或附近的 位置：142 ### Documentation Links https://dolphinscheduler.apache.org/zh-cn/docs/3.2.2/guide/installation/pseudo-cluster ### Are you willing to submit a PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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]
