@Override
    public String getPrimaryKey() {
        return primaryKey;
    }
Please declare primary key for sink table when query contains update/delete record.
inlong-sort/sort-common/src/main/java/org/apache/inlong/sort/protocol/node/load/TDSQLPostgresLoadNode.java