(转)PostgreSQL 数据库错误代码解释


‘54000‘: ‘超过程序限制(PROGRAM LIMIT EXCEEDED)‘,
‘54001‘: ‘语句太复杂(STATEMENT TOO COMPLEX)‘,
‘54011‘: ‘太多字段(TOO MANY COLUMNS)‘,
‘54023‘: ‘参数太多(TOO MANY ARGUMENTS)‘,
# 55 类 对象不在预先要求的状态
‘55000‘: ‘对象不在预先要求的状态(OBJECT NOT IN PREREQUISITE STATE)‘,
‘55006‘: ‘对象在使用中(OBJECT IN USE)‘,
‘55P02‘: ‘无法修改运行时参数(CANT CHANGE RUNTIME PARAM)‘,
‘55P03‘: ‘锁不可获得(LOCK NOT AVAILABLE)‘,
# 57 类 操作者干涉
‘57000‘: ‘操作者干涉(OPERATOR INTERVENTION)‘,
‘57014‘: ‘查询被取消(QUERY CANCELED)‘,
‘57P01‘: ‘管理员关机(ADMIN SHUTDOWN)‘,
‘57P02‘: ‘崩溃关机(CRASH SHUTDOWN)‘,
‘57P03‘: ‘现在无法连接(CANNOT CONNECT NOW)‘,
# 58 类 系统错误( PostgreSQL 自己内部的错误)
‘58030‘: ‘IO 错误(IO ERROR)‘,
‘58P01‘: ‘未定义的文件(UNDEFINED FILE)‘,
‘58P02‘: ‘重复的文件(DUPLICATE FILE)‘,
# F0 类 配置文件错误
‘F0000‘: ‘配置文件错误(CONFIG FILE ERROR)‘,
‘F0001‘: ‘锁文件存在(LOCK FILE EXISTS)‘,
# P0 类 PL/pgSQL 错误
‘P0000‘: ‘PLPGSQL 错误(PLPGSQL ERROR)‘,
‘P0001‘: ‘抛出例外(RAISE EXCEPTION)‘,
# XX 类 内部错误
‘XX000‘: ‘内部错误(INTERNAL ERROR)‘,
‘XX001‘: ‘数据损坏(DATA CORRUPTED)‘,
‘XX002‘: ‘索引损坏(INDEX CORRUPTED)‘
}

 

(转)PostgreSQL 数据库错误代码解释

原文:https://www.cnblogs.com/liujiacai/p/14672646.html

上一篇:CentOS 7二进制包部署MySQL 8.0


下一篇:优化sql语句