错误码目录 / PostgreSQL
PostgreSQL 错误码目录
本页收录 PostgreSQL 的 263 条错误码知识条目,每条均可打开独立详情页,包含错误说明、编号信息、官方文档与公开资料。
- 00000 · successful_completion — 00 Successful Completion
- 0A000 · feature_not_supported — 0A Feature Not Supported
- 0B000 · invalid_transaction_initiation — 0B Invalid Transaction Initiation
- 0F000 · locator_exception — 0F Locator Exception
- 0L000 · invalid_grantor — 0L Invalid Grantor
- 0P000 · invalid_role_specification — 0P Invalid Role Specification
- 0Z000 · diagnostics_exception — 0Z Diagnostics Exception
- F0000 · config_file_error — F0 Configuration File Error
- HV000 · fdw_error — HV Foreign Data Wrapper Error (SQL/MED)
- HV00A · fdw_invalid_string_format — HV Foreign Data Wrapper Error (SQL/MED)
- HV00B · fdw_invalid_handle — HV Foreign Data Wrapper Error (SQL/MED)
- HV00C · fdw_invalid_option_index — HV Foreign Data Wrapper Error (SQL/MED)
- HV00D · fdw_invalid_option_name — HV Foreign Data Wrapper Error (SQL/MED)
- HV00J · fdw_option_name_not_found — HV Foreign Data Wrapper Error (SQL/MED)
- HV00K · fdw_reply_handle — HV Foreign Data Wrapper Error (SQL/MED)
- HV00L · fdw_unable_to_create_execution — HV Foreign Data Wrapper Error (SQL/MED)
- HV00M · fdw_unable_to_create_reply — HV Foreign Data Wrapper Error (SQL/MED)
- HV00N · fdw_unable_to_establish_connection — HV Foreign Data Wrapper Error (SQL/MED)
- HV00P · fdw_no_schemas — HV Foreign Data Wrapper Error (SQL/MED)
- HV00Q · fdw_schema_not_found — HV Foreign Data Wrapper Error (SQL/MED)
- HV00R · fdw_table_not_found — HV Foreign Data Wrapper Error (SQL/MED)
- P0000 · plpgsql_error — P0 PL/pgSQL Error
- XX000 · internal_error — XX Internal Error
- 0F001 · invalid_locator_specification — 0F Locator Exception
- 0LP01 · invalid_grant_operation — 0L Invalid Grantor
- F0001 · lock_file_exists — F0 Configuration File Error
- HV001 · fdw_out_of_memory — HV Foreign Data Wrapper Error (SQL/MED)
- P0001 · raise_exception — P0 PL/pgSQL Error
- XX001 · data_corrupted — XX Internal Error
- 0Z002 · stacked_diagnostics_accessed_without_active_handler — 0Z Diagnostics Exception
- HV002 · fdw_dynamic_parameter_value_needed — HV Foreign Data Wrapper Error (SQL/MED)
- P0002 · no_data_found — P0 PL/pgSQL Error
- XX002 · index_corrupted — XX Internal Error
- P0003 · too_many_rows — P0 PL/pgSQL Error
- HV004 · fdw_invalid_data_type — HV Foreign Data Wrapper Error (SQL/MED)
- P0004 · assert_failure — P0 PL/pgSQL Error
- HV005 · fdw_column_name_not_found — HV Foreign Data Wrapper Error (SQL/MED)
- HV006 · fdw_invalid_data_type_descriptors — HV Foreign Data Wrapper Error (SQL/MED)
- HV007 · fdw_invalid_column_name — HV Foreign Data Wrapper Error (SQL/MED)
- HV008 · fdw_invalid_column_number — HV Foreign Data Wrapper Error (SQL/MED)
- HV009 · fdw_invalid_use_of_null_pointer — HV Foreign Data Wrapper Error (SQL/MED)
- HV010 · fdw_function_sequence_error — HV Foreign Data Wrapper Error (SQL/MED)
- HV014 · fdw_too_many_handles — HV Foreign Data Wrapper Error (SQL/MED)
- HV021 · fdw_inconsistent_descriptor_information — HV Foreign Data Wrapper Error (SQL/MED)
- HV024 · fdw_invalid_attribute_value — HV Foreign Data Wrapper Error (SQL/MED)
- HV090 · fdw_invalid_string_length_or_buffer_length — HV Foreign Data Wrapper Error (SQL/MED)
- HV091 · fdw_invalid_descriptor_field_identifier — HV Foreign Data Wrapper Error (SQL/MED)
- 0100C · dynamic_result_sets_returned — 01 Warning
- 01P01 · deprecated_feature — 01 Warning
- 2BP01 · dependent_objects_still_exist — 2B Dependent Privilege Descriptors Still Exist
- 08P01 · protocol_violation — 08 Connection Exception
- 01000 · warning — 01 Warning
- 01003 · null_value_eliminated_in_set_function — 01 Warning
- 01004 · string_data_right_truncation — 01 Warning
- 01006 · privilege_not_revoked — 01 Warning
- 01007 · privilege_not_granted — 01 Warning
- 01008 · implicit_zero_bit_padding — 01 Warning
- 02000 · no_data — 02 No Data (this is also a warning class per the SQL standard)
- 2B000 · dependent_privilege_descriptors_still_exist — 2B Dependent Privilege Descriptors Still Exist
- 2D000 · invalid_transaction_termination — 2D Invalid Transaction Termination
- 2F000 · sql_routine_exception — 2F SQL Routine Exception
- 02001 · no_additional_dynamic_result_sets_returned — 02 No Data (this is also a warning class per the SQL standard)
- 2F002 · modifying_sql_data_not_permitted — 2F SQL Routine Exception
- 2F003 · prohibited_sql_statement_attempted — 2F SQL Routine Exception
- 2F004 · reading_sql_data_not_permitted — 2F SQL Routine Exception
- 2F005 · function_executed_no_return_statement — 2F SQL Routine Exception
- 2200B · escape_character_conflict — 22 Data Exception
- 2200C · invalid_use_of_escape_character — 22 Data Exception
- 2200D · invalid_escape_octet — 22 Data Exception
- 2200F · zero_length_character_string — 22 Data Exception
- 2200G · most_specific_type_mismatch — 22 Data Exception
- 2200H · sequence_generator_limit_exceeded — 22 Data Exception
- 2200L · not_an_xml_document — 22 Data Exception
- 2200M · invalid_xml_document — 22 Data Exception
- 2200N · invalid_xml_content — 22 Data Exception
- 2200S · invalid_xml_comment — 22 Data Exception
- 2200T · invalid_xml_processing_instruction — 22 Data Exception
- 2201B · invalid_regular_expression — 22 Data Exception
- 2201E · invalid_argument_for_logarithm — 22 Data Exception
- 2201F · invalid_argument_for_power_function — 22 Data Exception
- 2201G · invalid_argument_for_width_bucket_function — 22 Data Exception
- 2201W · invalid_row_count_in_limit_clause — 22 Data Exception
- 2201X · invalid_row_count_in_result_offset_clause — 22 Data Exception
- 22P01 · floating_point_exception — 22 Data Exception
- 2202E · array_subscript_error — 22 Data Exception
- 2202G · invalid_tablesample_repeat — 22 Data Exception
- 2202H · invalid_tablesample_argument — 22 Data Exception
- 22P02 · invalid_text_representation — 22 Data Exception
- 2203A · sql_json_member_not_found — 22 Data Exception
- 2203B · sql_json_number_not_found — 22 Data Exception
- 2203C · sql_json_object_not_found — 22 Data Exception
- 2203D · too_many_json_array_elements — 22 Data Exception
- 2203E · too_many_json_object_members — 22 Data Exception
- 2203F · sql_json_scalar_required — 22 Data Exception
- 2203G · sql_json_item_cannot_be_cast_to_target_type — 22 Data Exception
- 22P03 · invalid_binary_representation — 22 Data Exception
- 22P04 · bad_copy_file_format — 22 Data Exception
- 22P05 · untranslatable_character — 22 Data Exception
- 22P06 · nonstandard_use_of_escape_character — 22 Data Exception
- 22P07 · datum_version_mismatch — 22 Data Exception
- 23P01 · exclusion_violation — 23 Integrity Constraint Violation
- 25P01 · no_active_sql_transaction — 25 Invalid Transaction State
- 25P02 · in_failed_sql_transaction — 25 Invalid Transaction State
- 25P03 · idle_in_transaction_session_timeout — 25 Invalid Transaction State
- 25P04 · transaction_timeout — 25 Invalid Transaction State
- 28P01 · invalid_password — 28 Invalid Authorization Specification
- 03000 · sql_statement_not_yet_complete — 03 SQL Statement Not Yet Complete
- 3B000 · savepoint_exception — 3B Savepoint Exception
- 3D000 · invalid_catalog_name — 3D Invalid Catalog Name
- 3F000 · invalid_schema_name — 3F Invalid Schema Name
- 3B001 · invalid_savepoint_specification — 3B Savepoint Exception
- 39P01 · trigger_protocol_violated — 39 External Routine Invocation Exception
- 39P02 · srf_protocol_violated — 39 External Routine Invocation Exception
- 39P03 · event_trigger_protocol_violated — 39 External Routine Invocation Exception
- 40P01 · deadlock_detected — 40 Transaction Rollback
- 42P01 · undefined_table — 42 Syntax Error or Access Rule Violation
- 42P02 · undefined_parameter — 42 Syntax Error or Access Rule Violation
- 42P03 · duplicate_cursor — 42 Syntax Error or Access Rule Violation
- 42P04 · duplicate_database — 42 Syntax Error or Access Rule Violation
- 42P05 · duplicate_prepared_statement — 42 Syntax Error or Access Rule Violation
- 42P06 · duplicate_schema — 42 Syntax Error or Access Rule Violation
- 42P07 · duplicate_table — 42 Syntax Error or Access Rule Violation
- 42P08 · ambiguous_parameter — 42 Syntax Error or Access Rule Violation
- 42P09 · ambiguous_alias — 42 Syntax Error or Access Rule Violation
- 42P10 · invalid_column_reference — 42 Syntax Error or Access Rule Violation
- 42P11 · invalid_cursor_definition — 42 Syntax Error or Access Rule Violation
- 42P12 · invalid_database_definition — 42 Syntax Error or Access Rule Violation
- 42P13 · invalid_function_definition — 42 Syntax Error or Access Rule Violation
- 42P14 · invalid_prepared_statement_definition — 42 Syntax Error or Access Rule Violation
- 42P15 · invalid_schema_definition — 42 Syntax Error or Access Rule Violation
- 42P16 · invalid_table_definition — 42 Syntax Error or Access Rule Violation
- 42P17 · invalid_object_definition — 42 Syntax Error or Access Rule Violation
- 42P18 · indeterminate_datatype — 42 Syntax Error or Access Rule Violation
- 42P19 · invalid_recursion — 42 Syntax Error or Access Rule Violation
- 42P20 · windowing_error — 42 Syntax Error or Access Rule Violation
- 42P21 · collation_mismatch — 42 Syntax Error or Access Rule Violation
- 42P22 · indeterminate_collation — 42 Syntax Error or Access Rule Violation
- 428C9 · generated_always — 42 Syntax Error or Access Rule Violation
- 55P02 · cant_change_runtime_param — 55 Object Not In Prerequisite State
- 55P03 · lock_not_available — 55 Object Not In Prerequisite State
- 55P04 · unsafe_new_enum_value_usage — 55 Object Not In Prerequisite State
- 57P01 · admin_shutdown — 57 Operator Intervention
- 57P02 · crash_shutdown — 57 Operator Intervention
- 57P03 · cannot_connect_now — 57 Operator Intervention
- 57P04 · database_dropped — 57 Operator Intervention
- 57P05 · idle_session_timeout — 57 Operator Intervention
- 58P01 · undefined_file — 57 Operator Intervention
- 58P02 · duplicate_file — 57 Operator Intervention
- 58P03 · file_name_too_long — 57 Operator Intervention
- 08000 · connection_exception — 08 Connection Exception
- 08001 · sqlclient_unable_to_establish_sqlconnection — 08 Connection Exception
- 08003 · connection_does_not_exist — 08 Connection Exception
- 08004 · sqlserver_rejected_establishment_of_sqlconnection — 08 Connection Exception
- 08006 · connection_failure — 08 Connection Exception
- 08007 · transaction_resolution_unknown — 08 Connection Exception
- 09000 · triggered_action_exception — 09 Triggered Action Exception
- 10608 · invalid_argument_for_xquery — 10 XQuery Error
- 20000 · case_not_found — 20 Case Not Found
- 21000 · cardinality_violation — 21 Cardinality Violation
- 22000 · data_exception — 22 Data Exception
- 22001 · string_data_right_truncation — 22 Data Exception
- 22002 · null_value_no_indicator_parameter — 22 Data Exception
- 22003 · numeric_value_out_of_range — 22 Data Exception
- 22004 · null_value_not_allowed — 22 Data Exception
- 22005 · error_in_assignment — 22 Data Exception
- 22007 · invalid_datetime_format — 22 Data Exception
- 22008 · datetime_field_overflow — 22 Data Exception
- 22009 · invalid_time_zone_displacement_value — 22 Data Exception
- 22010 · invalid_indicator_parameter_value — 22 Data Exception
- 22011 · substring_error — 22 Data Exception
- 22012 · division_by_zero — 22 Data Exception
- 22013 · invalid_preceding_or_following_size — 22 Data Exception
- 22014 · invalid_argument_for_ntile_function — 22 Data Exception
- 22015 · interval_field_overflow — 22 Data Exception
- 22016 · invalid_argument_for_nth_value_function — 22 Data Exception
- 22018 · invalid_character_value_for_cast — 22 Data Exception
- 22019 · invalid_escape_character — 22 Data Exception
- 22021 · character_not_in_repertoire — 22 Data Exception
- 22022 · indicator_overflow — 22 Data Exception
- 22023 · invalid_parameter_value — 22 Data Exception
- 22024 · unterminated_c_string — 22 Data Exception
- 22025 · invalid_escape_sequence — 22 Data Exception
- 22026 · string_data_length_mismatch — 22 Data Exception
- 22027 · trim_error — 22 Data Exception
- 22030 · duplicate_json_object_key_value — 22 Data Exception
- 22031 · invalid_argument_for_sql_json_datetime_function — 22 Data Exception
- 22032 · invalid_json_text — 22 Data Exception
- 22033 · invalid_sql_json_subscript — 22 Data Exception
- 22034 · more_than_one_sql_json_item — 22 Data Exception
- 22035 · no_sql_json_item — 22 Data Exception
- 22036 · non_numeric_sql_json_item — 22 Data Exception
- 22037 · non_unique_keys_in_a_json_object — 22 Data Exception
- 22038 · singleton_sql_json_item_required — 22 Data Exception
- 22039 · sql_json_array_not_found — 22 Data Exception
- 23000 · integrity_constraint_violation — 23 Integrity Constraint Violation
- 23001 · restrict_violation — 23 Integrity Constraint Violation
- 23502 · not_null_violation — 23 Integrity Constraint Violation
- 23503 · foreign_key_violation — 23 Integrity Constraint Violation
- 23505 · unique_violation — 23 Integrity Constraint Violation
- 23514 · check_violation — 23 Integrity Constraint Violation
- 24000 · invalid_cursor_state — 24 Invalid Cursor State
- 25000 · invalid_transaction_state — 25 Invalid Transaction State
- 25001 · active_sql_transaction — 25 Invalid Transaction State
- 25002 · branch_transaction_already_active — 25 Invalid Transaction State
- 25003 · inappropriate_access_mode_for_branch_transaction — 25 Invalid Transaction State
- 25004 · inappropriate_isolation_level_for_branch_transaction — 25 Invalid Transaction State
- 25005 · no_active_sql_transaction_for_branch_transaction — 25 Invalid Transaction State
- 25006 · read_only_sql_transaction — 25 Invalid Transaction State
- 25007 · schema_and_data_statement_mixing_not_supported — 25 Invalid Transaction State
- 25008 · held_cursor_requires_same_isolation_level — 25 Invalid Transaction State
- 26000 · invalid_sql_statement_name — 26 Invalid SQL Statement Name
- 27000 · triggered_data_change_violation — 27 Triggered Data Change Violation
- 28000 · invalid_authorization_specification — 28 Invalid Authorization Specification
- 34000 · invalid_cursor_name — 34 Invalid Cursor Name
- 38000 · external_routine_exception — 38 External Routine Exception
- 38001 · containing_sql_not_permitted — 38 External Routine Exception
- 38002 · modifying_sql_data_not_permitted — 38 External Routine Exception
- 38003 · prohibited_sql_statement_attempted — 38 External Routine Exception
- 38004 · reading_sql_data_not_permitted — 38 External Routine Exception
- 39000 · external_routine_invocation_exception — 39 External Routine Invocation Exception
- 39001 · invalid_sqlstate_returned — 39 External Routine Invocation Exception
- 39004 · null_value_not_allowed — 39 External Routine Invocation Exception
- 40000 · transaction_rollback — 40 Transaction Rollback
- 40001 · serialization_failure — 40 Transaction Rollback
- 40002 · transaction_integrity_constraint_violation — 40 Transaction Rollback
- 40003 · statement_completion_unknown — 40 Transaction Rollback
- 42000 · syntax_error_or_access_rule_violation — 42 Syntax Error or Access Rule Violation
- 42501 · insufficient_privilege — 42 Syntax Error or Access Rule Violation
- 42601 · syntax_error — 42 Syntax Error or Access Rule Violation
- 42602 · invalid_name — 42 Syntax Error or Access Rule Violation
- 42611 · invalid_column_definition — 42 Syntax Error or Access Rule Violation
- 42622 · name_too_long — 42 Syntax Error or Access Rule Violation
- 42701 · duplicate_column — 42 Syntax Error or Access Rule Violation
- 42702 · ambiguous_column — 42 Syntax Error or Access Rule Violation
- 42703 · undefined_column — 42 Syntax Error or Access Rule Violation
- 42704 · undefined_object — 42 Syntax Error or Access Rule Violation
- 42710 · duplicate_object — 42 Syntax Error or Access Rule Violation
- 42712 · duplicate_alias — 42 Syntax Error or Access Rule Violation
- 42723 · duplicate_function — 42 Syntax Error or Access Rule Violation
- 42725 · ambiguous_function — 42 Syntax Error or Access Rule Violation
- 42803 · grouping_error — 42 Syntax Error or Access Rule Violation
- 42804 · datatype_mismatch — 42 Syntax Error or Access Rule Violation
- 42809 · wrong_object_type — 42 Syntax Error or Access Rule Violation
- 42830 · invalid_foreign_key — 42 Syntax Error or Access Rule Violation
- 42846 · cannot_coerce — 42 Syntax Error or Access Rule Violation
- 42883 · undefined_function — 42 Syntax Error or Access Rule Violation
- 42939 · reserved_name — 42 Syntax Error or Access Rule Violation
- 44000 · with_check_option_violation — 44 WITH CHECK OPTION Violation
- 53000 · insufficient_resources — 53 Insufficient Resources
- 53100 · disk_full — 53 Insufficient Resources
- 53200 · out_of_memory — 53 Insufficient Resources
- 53300 · too_many_connections — 53 Insufficient Resources
- 53400 · configuration_limit_exceeded — 53 Insufficient Resources
- 54000 · program_limit_exceeded — 54 Program Limit Exceeded
- 54001 · statement_too_complex — 54 Program Limit Exceeded
- 54011 · too_many_columns — 54 Program Limit Exceeded
- 54023 · too_many_arguments — 54 Program Limit Exceeded
- 55000 · object_not_in_prerequisite_state — 55 Object Not In Prerequisite State
- 55006 · object_in_use — 55 Object Not In Prerequisite State
- 57000 · operator_intervention — 57 Operator Intervention
- 57014 · query_canceled — 57 Operator Intervention
- 58000 · system_error — 57 Operator Intervention
- 58030 · io_error — 57 Operator Intervention