[Doc][Module Name] Documentation bug or improvement

[zhaowanpeng]

Search before asking

• I had searched in the issues and found no similar feature requirement.

Description

官方文档中介绍：
数据库：PostgreSQL (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

• I agree to follow this project's Code of Conduct

[github-actions]

Search before asking

• I had searched in the issues and found no similar feature requirement.

Description

The official documentation introduces:
Database: PostgreSQL (8.2.15+)

My postgresql: postgres (PostgreSQL) 9.2.24

However, an error was reported during execution:
[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: Error: Syntax error in "ON" or near

Location: 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: Error: Syntax error in "ON" or near

Location: 142
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: Error: Syntax error in "ON" or near
Location: 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

• I agree to follow this project's Code of Conduct