全部 SQLSTATE 错误码
根据冻结的 PostgreSQL 发布源码生成的完整 SQLSTATE 目录。
按类别、版本和内容深度筛选全部 SQLSTATE。每个错误码都链接到已审阅的中英文说明;当前内容与运行核验范围见覆盖报告。
身份和证据约定请看方法页面。
| 错误码 | 类别 | 条件名 | 状态 | 已知存在于 | 正式版本 | 预发行 | 深度 |
|---|---|---|---|---|---|---|---|
00000 |
00 |
successful_completion |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
01000 |
01 |
warning |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
01003 |
01 |
null_value_eliminated_in_set_function |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
01004 |
01 |
string_data_right_truncation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
01006 |
01 |
privilege_not_revoked |
有效 |
8.0.0 |
all 16 formal |
all 1 preview |
参考 |
01007 |
01 |
privilege_not_granted |
有效 |
8.0.0 |
all 16 formal |
all 1 preview |
参考 |
01008 |
01 |
implicit_zero_bit_padding |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
0100C |
01 |
dynamic_result_sets_returned |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
01P01 |
01 |
deprecated_feature |
有效 |
8.0.0 |
all 16 formal |
all 1 preview |
参考 |
02000 |
02 |
no_data |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
02001 |
02 |
no_additional_dynamic_result_sets_returned |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
03000 |
03 |
sql_statement_not_yet_complete |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
08000 |
08 |
connection_exception |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
08001 |
08 |
sqlclient_unable_to_establish_sqlconnection |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
08003 |
08 |
connection_does_not_exist |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
08004 |
08 |
sqlserver_rejected_establishment_of_sqlconnection |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
08006 |
08 |
connection_failure |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
08007 |
08 |
transaction_resolution_unknown |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
08P01 |
08 |
protocol_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
09000 |
09 |
triggered_action_exception |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
0A000 |
0A |
feature_not_supported |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
0B000 |
0B |
invalid_transaction_initiation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
0F000 |
0F |
locator_exception |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
0F001 |
0F |
invalid_locator_specification |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
0L000 |
0L |
invalid_grantor |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
0LP01 |
0L |
invalid_grant_operation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
0P000 |
0P |
invalid_role_specification |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
0Z000 |
0Z |
diagnostics_exception |
有效 |
9.2.0 |
9.2.24 → 18.6 (14) |
all 1 preview |
参考 |
0Z002 |
0Z |
stacked_diagnostics_accessed_without_active_handler |
有效 |
9.2.0 |
9.2.24 → 18.6 (14) |
all 1 preview |
参考 |
10608 |
10 |
invalid_argument_for_xquery |
有效 |
18.0 |
18.6 |
all 1 preview |
参考 |
20000 |
20 |
case_not_found |
有效 |
8.4.0 |
all 16 formal |
all 1 preview |
参考 |
21000 |
21 |
cardinality_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
22000 |
22 |
data_exception |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22001 |
22 |
string_data_right_truncation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
22002 |
22 |
null_value_no_indicator_parameter |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22003 |
22 |
numeric_value_out_of_range |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
22004 |
22 |
null_value_not_allowed |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
22005 |
22 |
error_in_assignment |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22007 |
22 |
invalid_datetime_format |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
22008 |
22 |
datetime_field_overflow |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22009 |
22 |
invalid_time_zone_displacement_value |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2200B |
22 |
escape_character_conflict |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2200C |
22 |
invalid_use_of_escape_character |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2200D |
22 |
invalid_escape_octet |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2200F |
22 |
zero_length_character_string |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2200G |
22 |
most_specific_type_mismatch |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2200H |
22 |
sequence_generator_limit_exceeded |
有效 |
10.0 |
10.23 → 18.6 (9) |
all 1 preview |
参考 |
2200L |
22 |
not_an_xml_document |
有效 |
8.3.0 |
all 16 formal |
all 1 preview |
参考 |
2200M |
22 |
invalid_xml_document |
有效 |
8.3.0 |
all 16 formal |
all 1 preview |
参考 |
2200N |
22 |
invalid_xml_content |
有效 |
8.3.0 |
all 16 formal |
all 1 preview |
参考 |
2200S |
22 |
invalid_xml_comment |
有效 |
8.3.0 |
all 16 formal |
all 1 preview |
参考 |
2200T |
22 |
invalid_xml_processing_instruction |
有效 |
8.3.0 |
all 16 formal |
all 1 preview |
参考 |
22010 |
22 |
invalid_indicator_parameter_value |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22011 |
22 |
substring_error |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22012 |
22 |
division_by_zero |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
22013 |
22 |
invalid_preceding_or_following_size |
有效 |
11.0 |
11.22 → 18.6 (8) |
all 1 preview |
参考 |
22014 |
22 |
invalid_argument_for_ntile_function |
有效 |
8.4.0 |
all 16 formal |
all 1 preview |
参考 |
22015 |
22 |
interval_field_overflow |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22016 |
22 |
invalid_argument_for_nth_value_function |
有效 |
8.4.0 |
all 16 formal |
all 1 preview |
参考 |
22018 |
22 |
invalid_character_value_for_cast |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22019 |
22 |
invalid_escape_character |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2201B |
22 |
invalid_regular_expression |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2201E |
22 |
invalid_argument_for_logarithm |
有效 |
8.0.0 |
all 16 formal |
all 1 preview |
参考 |
2201F |
22 |
invalid_argument_for_power_function |
有效 |
8.0.0 |
all 16 formal |
all 1 preview |
参考 |
2201G |
22 |
invalid_argument_for_width_bucket_function |
有效 |
8.0.0 |
all 16 formal |
all 1 preview |
参考 |
2201W |
22 |
invalid_row_count_in_limit_clause |
有效 |
8.4.0 |
all 16 formal |
all 1 preview |
参考 |
2201X |
22 |
invalid_row_count_in_result_offset_clause |
有效 |
8.4.0 |
all 16 formal |
all 1 preview |
参考 |
22021 |
22 |
character_not_in_repertoire |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22022 |
22 |
indicator_overflow |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22023 |
22 |
invalid_parameter_value |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
22024 |
22 |
unterminated_c_string |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22025 |
22 |
invalid_escape_sequence |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22026 |
22 |
string_data_length_mismatch |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22027 |
22 |
trim_error |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2202E |
22 |
array_subscript_error |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
2202G |
22 |
invalid_tablesample_repeat |
有效 |
9.5.0 |
9.5.25 → 18.6 (11) |
all 1 preview |
参考 |
2202H |
22 |
invalid_tablesample_argument |
有效 |
9.5.0 |
9.5.25 → 18.6 (11) |
all 1 preview |
参考 |
22030 |
22 |
duplicate_json_object_key_value |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
22031 |
22 |
invalid_argument_for_sql_json_datetime_function |
有效 |
13.0 |
13.23 → 18.6 (6) |
all 1 preview |
参考 |
22032 |
22 |
invalid_json_text |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
22033 |
22 |
invalid_sql_json_subscript |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
22034 |
22 |
more_than_one_sql_json_item |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
22035 |
22 |
no_sql_json_item |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
22036 |
22 |
non_numeric_sql_json_item |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
22037 |
22 |
non_unique_keys_in_a_json_object |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
22038 |
22 |
singleton_sql_json_item_required |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
22039 |
22 |
sql_json_array_not_found |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
2203A |
22 |
sql_json_member_not_found |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
2203B |
22 |
sql_json_number_not_found |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
2203C |
22 |
sql_json_object_not_found |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
2203D |
22 |
too_many_json_array_elements |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
2203E |
22 |
too_many_json_object_members |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
2203F |
22 |
sql_json_scalar_required |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
2203G |
22 |
sql_json_item_cannot_be_cast_to_target_type |
有效 |
15.0 |
15.19 → 18.6 (4) |
all 1 preview |
参考 |
22P01 |
22 |
floating_point_exception |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22P02 |
22 |
invalid_text_representation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
22P03 |
22 |
invalid_binary_representation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22P04 |
22 |
bad_copy_file_format |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22P05 |
22 |
untranslatable_character |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
22P06 |
22 |
nonstandard_use_of_escape_character |
有效 |
8.1.0 |
all 16 formal |
all 1 preview |
参考 |
23000 |
23 |
integrity_constraint_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
23001 |
23 |
restrict_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
23502 |
23 |
not_null_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
23503 |
23 |
foreign_key_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
23505 |
23 |
unique_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
23514 |
23 |
check_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
23P01 |
23 |
exclusion_violation |
有效 |
9.0.0 |
all 16 formal |
all 1 preview |
完整 |
24000 |
24 |
invalid_cursor_state |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
25000 |
25 |
invalid_transaction_state |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
25001 |
25 |
active_sql_transaction |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
25002 |
25 |
branch_transaction_already_active |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
25003 |
25 |
inappropriate_access_mode_for_branch_transaction |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
25004 |
25 |
inappropriate_isolation_level_for_branch_transaction |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
25005 |
25 |
no_active_sql_transaction_for_branch_transaction |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
25006 |
25 |
read_only_sql_transaction |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
25007 |
25 |
schema_and_data_statement_mixing_not_supported |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
25008 |
25 |
held_cursor_requires_same_isolation_level |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
25P01 |
25 |
no_active_sql_transaction |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
25P02 |
25 |
in_failed_sql_transaction |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
25P03 |
25 |
idle_in_transaction_session_timeout |
有效 |
9.6.0 |
9.6.24 → 18.6 (10) |
all 1 preview |
完整 |
25P04 |
25 |
transaction_timeout |
有效 |
17.0 |
17.11 → 18.6 (2) |
all 1 preview |
完整 |
26000 |
26 |
invalid_sql_statement_name |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
27000 |
27 |
triggered_data_change_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
28000 |
28 |
invalid_authorization_specification |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
28P01 |
28 |
invalid_password |
有效 |
9.0.0 |
all 16 formal |
all 1 preview |
完整 |
2B000 |
2B |
dependent_privilege_descriptors_still_exist |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2BP01 |
2B |
dependent_objects_still_exist |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
2D000 |
2D |
invalid_transaction_termination |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2F000 |
2F |
sql_routine_exception |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2F002 |
2F |
modifying_sql_data_not_permitted |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2F003 |
2F |
prohibited_sql_statement_attempted |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2F004 |
2F |
reading_sql_data_not_permitted |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
2F005 |
2F |
function_executed_no_return_statement |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
34000 |
34 |
invalid_cursor_name |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
38000 |
38 |
external_routine_exception |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
38001 |
38 |
containing_sql_not_permitted |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
38002 |
38 |
modifying_sql_data_not_permitted |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
38003 |
38 |
prohibited_sql_statement_attempted |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
38004 |
38 |
reading_sql_data_not_permitted |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
39000 |
39 |
external_routine_invocation_exception |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
39001 |
39 |
invalid_sqlstate_returned |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
39004 |
39 |
null_value_not_allowed |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
39P01 |
39 |
trigger_protocol_violated |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
39P02 |
39 |
srf_protocol_violated |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
39P03 |
39 |
event_trigger_protocol_violated |
有效 |
9.5.0 |
9.5.25 → 18.6 (11) |
all 1 preview |
参考 |
3B000 |
3B |
savepoint_exception |
有效 |
8.0.0 |
all 16 formal |
all 1 preview |
参考 |
3B001 |
3B |
invalid_savepoint_specification |
有效 |
8.0.0 |
all 16 formal |
all 1 preview |
参考 |
3D000 |
3D |
invalid_catalog_name |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
3F000 |
3F |
invalid_schema_name |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
40000 |
40 |
transaction_rollback |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
40001 |
40 |
serialization_failure |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
40002 |
40 |
transaction_integrity_constraint_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
40003 |
40 |
statement_completion_unknown |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
40P01 |
40 |
deadlock_detected |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42000 |
42 |
syntax_error_or_access_rule_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42501 |
42 |
insufficient_privilege |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42601 |
42 |
syntax_error |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42602 |
42 |
invalid_name |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42611 |
42 |
invalid_column_definition |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42622 |
42 |
name_too_long |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42701 |
42 |
duplicate_column |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42702 |
42 |
ambiguous_column |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42703 |
42 |
undefined_column |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42704 |
42 |
undefined_object |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42710 |
42 |
duplicate_object |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42712 |
42 |
duplicate_alias |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42723 |
42 |
duplicate_function |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42725 |
42 |
ambiguous_function |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42803 |
42 |
grouping_error |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42804 |
42 |
datatype_mismatch |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42809 |
42 |
wrong_object_type |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42830 |
42 |
invalid_foreign_key |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42846 |
42 |
cannot_coerce |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42883 |
42 |
undefined_function |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
428C9 |
42 |
generated_always |
有效 |
10.0 |
10.23 → 18.6 (9) |
all 1 preview |
完整 |
42939 |
42 |
reserved_name |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42P01 |
42 |
undefined_table |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42P02 |
42 |
undefined_parameter |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42P03 |
42 |
duplicate_cursor |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42P04 |
42 |
duplicate_database |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42P05 |
42 |
duplicate_prepared_statement |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42P06 |
42 |
duplicate_schema |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42P07 |
42 |
duplicate_table |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42P08 |
42 |
ambiguous_parameter |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42P09 |
42 |
ambiguous_alias |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42P10 |
42 |
invalid_column_reference |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42P11 |
42 |
invalid_cursor_definition |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42P12 |
42 |
invalid_database_definition |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42P13 |
42 |
invalid_function_definition |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42P14 |
42 |
invalid_prepared_statement_definition |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42P15 |
42 |
invalid_schema_definition |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42P16 |
42 |
invalid_table_definition |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42P17 |
42 |
invalid_object_definition |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
42P18 |
42 |
indeterminate_datatype |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
42P19 |
42 |
invalid_recursion |
有效 |
8.4.0 |
all 16 formal |
all 1 preview |
参考 |
42P20 |
42 |
windowing_error |
有效 |
8.4.0 |
all 16 formal |
all 1 preview |
参考 |
42P21 |
42 |
collation_mismatch |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
42P22 |
42 |
indeterminate_collation |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
44000 |
44 |
with_check_option_violation |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
53000 |
53 |
insufficient_resources |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
53100 |
53 |
disk_full |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
53200 |
53 |
out_of_memory |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
53300 |
53 |
too_many_connections |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
53400 |
53 |
configuration_limit_exceeded |
有效 |
9.2.0 |
9.2.24 → 18.6 (14) |
all 1 preview |
完整 |
54000 |
54 |
program_limit_exceeded |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
54001 |
54 |
statement_too_complex |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
54011 |
54 |
too_many_columns |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
54023 |
54 |
too_many_arguments |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
55000 |
55 |
object_not_in_prerequisite_state |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
55006 |
55 |
object_in_use |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
55P02 |
55 |
cant_change_runtime_param |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
55P03 |
55 |
lock_not_available |
有效 |
8.0.0 |
all 16 formal |
all 1 preview |
完整 |
55P04 |
55 |
unsafe_new_enum_value_usage |
有效 |
12.0 |
12.22 → 18.6 (7) |
all 1 preview |
参考 |
57000 |
57 |
operator_intervention |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
57014 |
57 |
query_canceled |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
57P01 |
57 |
admin_shutdown |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
57P02 |
57 |
crash_shutdown |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
57P03 |
57 |
cannot_connect_now |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
57P04 |
57 |
database_dropped |
有效 |
9.0.4 |
all 16 formal |
all 1 preview |
参考 |
57P05 |
57 |
idle_session_timeout |
有效 |
14.0 |
14.24 → 18.6 (5) |
all 1 preview |
完整 |
58000 |
58 |
system_error |
有效 |
9.2.0 |
9.2.24 → 18.6 (14) |
all 1 preview |
参考 |
58030 |
58 |
io_error |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
58P01 |
58 |
undefined_file |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
58P02 |
58 |
duplicate_file |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
58P03 |
58 |
file_name_too_long |
有效 |
18.0 |
18.6 |
all 1 preview |
完整 |
72000 |
72 |
snapshot_too_old |
已移除 |
9.6.0 |
9.6.24 → 16.15 (8) |
— |
完整 |
F0000 |
F0 |
config_file_error |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
F0001 |
F0 |
lock_file_exists |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
HV000 |
HV |
fdw_error |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV001 |
HV |
fdw_out_of_memory |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV002 |
HV |
fdw_dynamic_parameter_value_needed |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV004 |
HV |
fdw_invalid_data_type |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV005 |
HV |
fdw_column_name_not_found |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV006 |
HV |
fdw_invalid_data_type_descriptors |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV007 |
HV |
fdw_invalid_column_name |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV008 |
HV |
fdw_invalid_column_number |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV009 |
HV |
fdw_invalid_use_of_null_pointer |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00A |
HV |
fdw_invalid_string_format |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00B |
HV |
fdw_invalid_handle |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00C |
HV |
fdw_invalid_option_index |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00D |
HV |
fdw_invalid_option_name |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00J |
HV |
fdw_option_name_not_found |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00K |
HV |
fdw_reply_handle |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00L |
HV |
fdw_unable_to_create_execution |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00M |
HV |
fdw_unable_to_create_reply |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00N |
HV |
fdw_unable_to_establish_connection |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00P |
HV |
fdw_no_schemas |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00Q |
HV |
fdw_schema_not_found |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV00R |
HV |
fdw_table_not_found |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV010 |
HV |
fdw_function_sequence_error |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV014 |
HV |
fdw_too_many_handles |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV021 |
HV |
fdw_inconsistent_descriptor_information |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV024 |
HV |
fdw_invalid_attribute_value |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV090 |
HV |
fdw_invalid_string_length_or_buffer_length |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
HV091 |
HV |
fdw_invalid_descriptor_field_identifier |
有效 |
9.1.0 |
9.1.24 → 18.6 (15) |
all 1 preview |
参考 |
P0000 |
P0 |
plpgsql_error |
有效 |
8.0.0 |
all 16 formal |
all 1 preview |
参考 |
P0001 |
P0 |
raise_exception |
有效 |
8.0.0 |
all 16 formal |
all 1 preview |
完整 |
P0002 |
P0 |
no_data_found |
有效 |
8.2.0 |
all 16 formal |
all 1 preview |
参考 |
P0003 |
P0 |
too_many_rows |
有效 |
8.2.0 |
all 16 formal |
all 1 preview |
参考 |
P0004 |
P0 |
assert_failure |
有效 |
9.5.0 |
9.5.25 → 18.6 (11) |
all 1 preview |
完整 |
XX000 |
XX |
internal_error |
有效 |
7.4 |
all 16 formal |
all 1 preview |
参考 |
XX001 |
XX |
data_corrupted |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |
XX002 |
XX |
index_corrupted |
有效 |
7.4 |
all 16 formal |
all 1 preview |
完整 |