pg数据库下 用户管理功能 报错,可能是字段类型不对?
### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
建议:No operator matches the given name and argument type(s). You might need to add explicit type casts.
位置:129
### The error may exist in io/platform/modules/sys/dao/SysPostDao.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,post_code,post_name,sort,status,updater,update_date,tenant_code,creator,create_date FROM sys_post WHERE (status = ? AND tenant_code = ?) ORDER BY sort ASC
### Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
建议:No operator matches the given name and argument type(s). You might need to add explicit type casts.
位置:129
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
建议:No operator matches the given name and argument type(s). You might need to add explicit type casts.
位置:129
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
建议:No operator matches the given name and argument type(s). You might need to add explicit type casts.
位置:129
### The error may exist in io/platform/modules/sys/dao/SysPostDao.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,post_code,post_name,sort,status,updater,update_date,tenant_code,creator,create_date FROM sys_post WHERE (status = ? AND tenant_code = ?) ORDER BY sort ASC
### Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
建议:No operator matches the given name and argument type(s). You might need to add explicit type casts.
位置:129
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
建议:No operator matches the given name and argument type(s). You might need to add explicit type casts.
位置:129