| 42P23 | partition_error | 分区错误 | ✅ | ||
| 42P24 | invalid_attribute | 非法属性值 | ✅ | ||
| 42P25 | invalid_agg | 非法聚集函数 | ✅ | ||
| 42P26 | resource_pool_error | 资源池错误 | ✅ | ||
| 42P27 | plan_parent_not_found | 未找到父级计划 | ✅ | ||
| 42P28 | modify_conflicts | 更新冲突 | ✅ | ||
| 42P29 | distribution_error | 分布错误 | ✅ | ||
| 42809 | wrong_object_type | 错误的对象类型 | ✅ | ||
| 428C9 | generated_always | ✅ | |||
| 42703 | undefined_column | 未定义的字段 | ✅ | ||
| 42883 | undefined_function | 未定义的函数 | ✅ | ||
| 42P01 | undefined_table | 未定义的表 | ✅ | ||
| 42P02 | undefined_parameter | 未定义的参数 | ✅ | ||
| 42704 | undefined_object | 未定义对象 | ✅ | ||
| 42701 | duplicate_column | 重复的字段 | ✅ | ||
| 42P03 | duplicate_cursor | 重复的游标 | ✅ | ||
| 42P04 | duplicate_database | 重复的数据库 | ✅ | ||
| 42723 | duplicate_function | 重复的函数 | ✅ | ||
| 42P05 | duplicate_prepared_statement | 重复的预编译语句 | ✅ | ||
| 42P06 | duplicate_schema | 重复的模式 | ✅ | ||
| 42P07 | duplicate_table | 重复的表 | ✅ | ||
| 42712 | duplicate_alias | 重复的别名 | ✅ | ||
| 42710 | duplicate_object | 重复的对象 | ✅ | ||
| 42702 | ambiguous_column | 模糊的字段 | ✅ | ||
| 42725 | ambiguous_function | 模糊的函数 | ✅ | ||
| 42P08 | ambiguous_parameter | 模糊的参数 | ✅ | ||
| 42P09 | ambiguous_alias | 模糊的别名 | ✅ | ||
| 42P10 | invalid_column_reference | 非法字段引用 | ✅ | ||
| 42611 | invalid_column_definition | 非法字段定义 | ✅ | ||
| 42P11 | invalid_cursor_definition | 非法游标定义 | ✅ | ||
| 42P12 | invalid_database_definition | 非法数据库定义 | ✅ | ||
| 42P13 | invalid_function_definition | 非法函数定义 | ✅ | ||
| 42P14 | invalid_prepared_statement_definition | 非法预编译语句定义 | ✅ | ||
| 42P15 | invalid_schema_definition | 非法模式定义 | ✅ | ||
| 42P16 | invalid_table_definition | 非法表定义 | ✅ | ||
| 42P17 | invalid_object_definition | 非法对象定义 | ✅ | ||
| Class 44 — WITH CHECK OPTION Violation/类 44 - 违反WITH CHECK选项 | ✅ | ||||
| 44000 | with_check_option_violation | 违反WITH CHECK选项 | ✅ | ||
| Class 53 — Insufficient Resources/类 53 - 资源不足 | ✅ | ||||
| 53000 | insufficient_resources | 资源不足 | ✅ | ||
| 53100 | disk_full | 磁盘满 | ✅ | ||
| 53200 | out_of_memory | 内存耗尽 | ✅ | ||
| 53300 | too_many_connections | 太多连接 | ✅ | ||
| 53400 | configuration_limit_exceeded | 超过配置限制 | ✅ | ||
| Class 54 — Program Limit Exceeded/类 54 - 超过程序限制 | ✅ | ||||
| 54000 | program_limit_exceeded | 超过程序限制 | ✅ | ||
| 54001 | statement_too_complex | 语句太复杂 | ✅ | ||
| 54011 | too_many_columns | 字段太多 | ✅ | ||
| 54023 | too_many_arguments | 参数太多 | ✅ | ||
| Class 55 — Object Not In Prerequisite State/类 55 - 对象不在预先要求的状态 | ✅ | ||||
| 55000 | object_not_in_prerequisite_state | 对象不在预先要求的状态 | ✅ | ||
| 55006 | object_in_use | 对象在使用中(OBJECT_IN_USE) | ✅ | ||
| 55P02 | cant_change_runtime_param | 无法修改运行时参数 | ✅ | ||
| 55P03 | lock_not_available | 锁不可获得 | ✅ | ||
| 55P04 | unsafe_new_enum_value_usage | ✅ | |||
| Class 57 — Operator Intervention/类 57 - 操作者干涉 | ✅ | ||||
| 57000 | operator_intervention | 操作者干涉 | ✅ | ||
| 57014 | query_canceled | 查询被取消 | ✅ | ||
| 57015 | query_internal_cancel | 内部查询取消 | ✅ | ||
| 57P01 | admin_shutdown | 管理员关闭系统 | ✅ | ||
| 57P02 | crash_shutdown | 崩溃宕机 | ✅ | ||
| 57P03 | cannot_connect_now | 现在无法连接 | ✅ | ||
| 57P04 | database_dropped | 丢弃数据库 | ✅ | ||
| 57P05 | idle_session_timeout | ✅ | |||
| Class 58 — System Error/类 58 - 系统错误 | ✅ | ||||
| 58000 | system_error | 系统错误 | ✅ | ||
| 58030 | io_error | IO错误 | ✅ | ||
| 58P01 | undefined_file | 未定义的文件 | ✅ | ||
| 58P02 | duplicate_file | 重复的文件 | ✅ | ||
| Class 72 — Snapshot Failure | ✅ | ||||
| 72000 | snapshot_too_old | ✅ | |||
| Class F0 — Configuration File Error/类 F0 - 配置文件错误 | ✅ | ||||
| F0000 | config_file_error | 配置文件错误 | ✅ | ||
| F0001 | lock_file_exists | 锁文件存在 | ✅ | ||
| Class HV — Foreign Data Wrapper Error (SQL/MED)/类 HV - 外部数据错误（SQL/MED） | ✅ | ||||
| HV000 | fdw_error | 外部数据错误 | ✅ | ||
| HV005 | fdw_column_name_not_found | 未找到列名 | ✅ | ||
| HV002 | fdw_dynamic_parameter_value_needed | 需要动态参数值 | ✅ | ||
| HV010 | fdw_function_sequence_error | 函数序列错误 | ✅ | ||
| HV021 | fdw_inconsistent_descriptor_information | 描述信息不一致 | ✅ | ||
| HV024 | fdw_invalid_attribute_value | 非法属性值 | ✅ | ||
| HV007 | fdw_invalid_column_name | 非法列名称 | ✅ | ||
| HV008 | fdw_invalid_column_number | 非法列数 | ✅ | ||
| HV004 | fdw_invalid_data_type | 非法数据类型 | ✅ | ||
| HV006 | fdw_invalid_data_type_descriptors | 非法数据类型描述符 | ✅ | ||
| HV091 | fdw_invalid_descriptor_field_identifier | 非法字段标识符 | ✅ | ||
| HV00B | fdw_invalid_handle | 非法处理 | ✅ | ||
| HV00C | fdw_invalid_option_index | 非法索引选项 | ✅ | ||
| HV00D | fdw_invalid_option_name | 非法选项名称 | ✅ | ||
| HV090 | fdw_invalid_string_length_or_buffer_length | 非法字符串长度或缓冲区长度 | ✅ | ||
| HV00A | fdw_invalid_string_format | 非法字符长格式 | ✅ | ||
| HV009 | fdw_invalid_use_of_null_pointer | 非法使用NULL指针 | ✅ | ||
| HV014 | fdw_too_many_handles | 太多句柄 | ✅ | ||
| HV001 | fdw_out_of_memory | 内存耗尽 | ✅ | ||
| HV00P | fdw_no_schemas | 无模式 | ✅ | ||
| HV00J | fdw_option_name_not_found | 未找到选项名称 | ✅ | ||
| HV00K | fdw_reply_handle | 回复句柄 | ✅ | ||
| HV00Q | fdw_schema_not_found | 未找到模式 | ✅ | ||
| HV00R | fdw_table_not_found | 未找到表 | ✅ | ||
| HV00S | fdw_invalid_server_type | 不正确的服务器类型(FDW_INVALID_SERVER_TYPE) | ✅ | ||
| HV00L | fdw_unable_to_create_execution | 无法建立执行 | ✅ | ||
| HV00M | fdw_unable_to_create_reply | 不能创建回复 | ✅ | ||
| HV00N | fdw_unable_to_establish_connection | 无法建立连接 | ✅ | ||
| Class P0 — PL/pgSQL Error/类 P0 - PL/pgSQL错误 | ✅ | ||||
| P0000 | plpgsql_error | PLPGSQL错误 | ✅ | ||
| P0001 | raise_exception | 抛出异常 | ✅ | ||
| P0002 | no_data_found | 未找到数据 | ✅ | ||
| P0003 | too_many_rows | 行太多 | ✅ | ||
| P0004 | assert_failure | FORALL需要DML操作 | ✅ | ||
| Class XX — Internal Error/类 XX - 内部错误 | ✅ | ||||
| XX000 | internal_error | 内部错误 | ✅ | ||
| XX001 | data_corrupted | 数据损坏 | ✅ | ||
| XX002 | index_corrupted | 索引损坏 | ✅ | ||
| XX003 | stream_remote_close_socket | 关闭远程流接口 | ✅ | ||
| XX004 | unrecognized_node_type | 未知节点类型 | ✅ | ||
| XX005 | unexpected_null_value | 异常空值 | ✅ | ||
| XX006 | unexpected_node_state | 异常节点状态 | ✅ | ||
| XX007 | null_junk_attribute | JUNK列为空 | ✅ | ||
| XX008 | optimizer_inconsistent_state | 优化器状态不一致 | ✅ | ||
| XX009 | stream_duplicate_query_id | 重复查询编号 | ✅ | ||
| XX010 | invalid_buffer | 无效缓冲区 | ✅ | ||
| XX011 | invalid_buffer_reference | 无效缓冲区引用 | ✅ | ||
| XX012 | node_id_missmatch | 节点编号不匹配 | ✅ | ||
| XX013 | cannot_modify_xidbase | 不能修改xid base | ✅ | ||
| XX014 | unexpected_chunk_value | TOAST表数据损坏 | ✅ | ||
| 类 YY - SQL重试错误 | ✅ | ||||
| YY001 | connection_reset_by_peer | 对端连接重置 | ✅ | ||
| YY002 | stream_connection_reset_by_peer | 对端流重置 | ✅ | ||
| YY003 | lock_wait_timeout | 锁等待超时 | ✅ | ||
| YY004 | connection_timed_out | 连接超时 | ✅ | ||
| YY005 | set_query_error | 查询设置错误 | ✅ | ||
| YY006 | out_of_logical_memory | 超出逻辑内存 | ✅ | ||
| YY007 | sctp_memory_alloc | 通信库内存分配 | ✅ | ||
| YY008 | sctp_no_data_in_buffer | 无通信库缓存数据 | ✅ | ||
| YY009 | sctp_release_memory_close | 通信库释放内存关闭 | ✅ | ||
| YY010 | sctp_tcp_disconnect | SCTP、TCP断开 | ✅ | ||
| YY011 | sctp_disconnect | 通信库断开 | ✅ | ||
| YY012 | sctp_remote_close | 通信库远程关闭 | ✅ | ||
| YY013 | sctp_wait_poll_unknow | 等待未知通信库通信 | ✅ | ||
| YY014 | snapshot_invalid | 无效快照 | ✅ | ||
| YY015 | connection_receive_wrong | 通讯接收信息错误 | ✅ | ||
| 类SI – SPI接口错误 | ✅ | ||||
| SP000 | spi_error | SPI接口错误 | ✅ | ||
| SP001 | spi_connection_failure | SPI通讯失败 | ✅ | ||
| SP002 | spi_finish_failure | SPI完成失败 | ✅ | ||
| SP003 | spi_prepare_failure | SPI准备失败 | ✅ | ||
| SP004 | spi_cursor_open_failure | SPI游标开启失败 | ✅ | ||
| SP005 | spi_execute_failure | SPI执行失败 | ✅ | ||
| SP006 | spi_improper_call_function | SPI不当调用 | ✅ | ||
| 类RB - RBTree错误 | ✅ | ||||
| RB001 | rbtree_invalid_node_state | RBTree无效节点状态 | ✅ | ||
| RB002 | rbtree_invalid_iterator_order | RBTree无效迭代顺序 | ✅ | ||
| 类 PD - PL调试器错误 | ✅ | ||||
| D0000 | pldebugger_internal_error | PL调试器内部错误 | ✅ | ||
| D0001 | duplicate_breakpoint | 重复断点 | ✅ | ||
| D0002 | function_hash_is_not_initialized | 哈希函数没有被初始化 | ✅ | ||
| D0003 | breakpoint_is_not_present | 断点不存在 | ✅ | ||
| D0004 | debug_server_already_is_attached | 已附加调试服务器 | ✅ | ||
| D0005 | debug_server_not_attached | 未附加调试服务器 | ✅ | ||
| D0006 | debug_server_already_in_sync | 已同步调试服务器 | ✅ | ||
| D0007 | debug_target_servers_not_in_sync | 未同步调试服务器 | ✅ | ||
| D0008 | target_server_already_in_sync | 已同步目标服务 | ✅ | ||
| D0009 | non_existant_variable | 变量不存在 | ✅ | ||
| D0010 | invalid_target_session_id | 非法目标会话ID | ✅ | ||
| D0011 | invalid_operation | 非法操作 | ✅ | ||
| D0012 | maximum_number_of_debug_sessions_reached | 达到最大调试会话数 | ✅ | ||
| D0013 | maximum_number_of_breakpoints_reached | 达到最大断点数 | ✅ | ||
| 类LL - 逻辑解码错误码 | ✅ | ||||
| LL001 | logical_decode_error | 逻辑解码错误 | ✅ | ||
| LL002 | relfilenodemap | 哈希表搜索错误 | ✅ | ||
| 表 2 GaussDB Kernel CM错误码SQLSTATE值 | ✅ | ||||
| 类 c0 - 连接异常（Connection Exception） | ✅ | ||||
| c0000 | connection_exception | 连接异常 | ✅ | ||
| c0001 | connection_does_not_exist | 连接不存在 | ✅ | ||
| c0002 | connection_failure | 连接失败 | ✅ | ||
| 类 c1 - 环境异常（Environment Exception） | ✅ | ||||
| c1000 | out_of_memory | 内存不足 | ✅ | ||
| 类 c2 - 文件异常（File Exception） | ✅ | ||||
| c2000 | open_file_failure | 打开文件失败 | ✅ | ||
| c2001 | read_file_failure | 文件读取失败 | ✅ | ||
| c2002 | config_file_failure | 配置文件失败 | ✅ | ||
| 类 c3 - 参数异常（Parameter Exception） | ✅ | ||||
| c3000 | parameter_failure | 参数失败 | ✅ | ||
| c3001 | environment_variable_failure | 环境变量失败 | ✅ | ||
| 类 c4 - Etcd异常（Etcd Exception） | ✅ | ||||
| c4000 | etcd_open_failure | etcd打开失败 | ✅ | ||
| 类 c5 - 内部异常（Internal Exception） | ✅ | ||||
| c5000 | internal_error | 内部错误 | ✅ |
