ERROR: operator does not exist: character = integer
来源:互联网 发布:mac的office软件怎么样 编辑:程序博客网 时间:2024/06/07 18:03
错误
ERROR: operator does not exist: character = integer
原因:PostgreSQL8.3以后,取消了默认类型转换。因此需要使比较的类型保持一致。可以看cast函数。
因此需要自己转化数据库字符串类型varchar(255)为int4,但是直接在数据库上操作会报错,
只要执行一句:
ALTER TABLE jforum_role_values ALTER COLUMN role_value TYPE integer USING (role_value::integer);
即可修改成功。
0 0
- ERROR: operator does not exist: character = integer
- PostgreSQL错误处理“operator does not exist: character varying = bytea at character”
- ERROR:column "datconfig " does not exist character
- ORA-29807: specified operator does not exist
- ERROR: column "..." does not exist
- ERROR: column "..." does not exist(postgre--hibernate)
- ERROR: relation "public.userinfo" does not exist
- Error: Object INSTANCES_UTIL does not exist
- ActivityManager: Error: Activity class { 。。。} does not exist.
- ActivityManager: Error: Activity class {..} does not exist.
- ERROR:column "rolcatupdate" does not exist
- eclipse error resource does not exist
- ERROR:language "plpgsql" does not exist
- ERROR: SWT folder '' does not exist
- 【error】postgresql relation does not exist
- Virtualbox The character device /dev/vboxdrv does not exist.
- DocumentRoot does not exist
- mapreduce_shuffle does not exist
- HDU 5162
- 创业有风险,招聘需谨慎
- JAVA中类、实例与Class对象
- android Notification
- 在iOS8系统下,UITabbar上的item自定义背景色和图片问题
- ERROR: operator does not exist: character = integer
- uboot启动完成后对网络环境的配置
- 【SQL-码农】SQL 快速查看表结构 内查秘方
- HTML textarea的value 问题
- 处理字符串
- 同步传输和异步传输的区别
- window下在同一台机器上安装多个版本jdk,修改环境变量不生效问题处理办法
- NSTimer学习笔记
- iOS中几种数据持久化方案