# 全部 SQLSTATE 错误码

> 根据冻结的 PostgreSQL 发布源码生成的完整 SQLSTATE 目录。
---

按类别、版本和内容深度筛选全部 SQLSTATE。每个错误码都链接到已审阅的中英文说明；当前内容与运行核验范围见[覆盖报告](../coverage/)。

身份和证据约定请看[方法](../methodology/)页面。

<form class="sqlstate-code-filters" data-code-filter-panel>
  <label>类别 <select data-code-filter="class"><option value="">全部</option></select></label>
  <label>正式版本 <select data-code-filter="formal"><option value="">全部</option></select></label>
  <label>预发行 <select data-code-filter="preview"><option value="">全部</option></select></label>
  <label>深度 <select data-code-filter="depth"><option value="">全部</option></select></label>
  <button type="reset" data-code-filter-reset>重置</button>
</form>

<!-- BEGIN SQLSTATE INDEX: generated by scripts/generate.py; do not edit -->

| 错误码 | 类别 | 条件名 | 状态 | 已知存在于 | 正式版本 | 预发行 | 深度 |
| --- | --- | --- | --- | --- | --- | --- | --- |
| [`00000`](../00000/) | `00` | `successful_completion` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`01000`](../01000/) | `01` | `warning` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`01003`](../01003/) | `01` | `null_value_eliminated_in_set_function` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`01004`](../01004/) | `01` | `string_data_right_truncation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`01006`](../01006/) | `01` | `privilege_not_revoked` | `有效` | `8.0.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`01007`](../01007/) | `01` | `privilege_not_granted` | `有效` | `8.0.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`01008`](../01008/) | `01` | `implicit_zero_bit_padding` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`0100C`](../0100c/) | `01` | `dynamic_result_sets_returned` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`01P01`](../01p01/) | `01` | `deprecated_feature` | `有效` | `8.0.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`02000`](../02000/) | `02` | `no_data` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`02001`](../02001/) | `02` | `no_additional_dynamic_result_sets_returned` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`03000`](../03000/) | `03` | `sql_statement_not_yet_complete` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`08000`](../08000/) | `08` | `connection_exception` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`08001`](../08001/) | `08` | `sqlclient_unable_to_establish_sqlconnection` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`08003`](../08003/) | `08` | `connection_does_not_exist` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`08004`](../08004/) | `08` | `sqlserver_rejected_establishment_of_sqlconnection` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`08006`](../08006/) | `08` | `connection_failure` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`08007`](../08007/) | `08` | `transaction_resolution_unknown` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`08P01`](../08p01/) | `08` | `protocol_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`09000`](../09000/) | `09` | `triggered_action_exception` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`0A000`](../0a000/) | `0A` | `feature_not_supported` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`0B000`](../0b000/) | `0B` | `invalid_transaction_initiation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`0F000`](../0f000/) | `0F` | `locator_exception` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`0F001`](../0f001/) | `0F` | `invalid_locator_specification` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`0L000`](../0l000/) | `0L` | `invalid_grantor` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`0LP01`](../0lp01/) | `0L` | `invalid_grant_operation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`0P000`](../0p000/) | `0P` | `invalid_role_specification` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`0Z000`](../0z000/) | `0Z` | `diagnostics_exception` | `有效` | `9.2.0` | `9.2.24 → 18.6 (14)` | `all 1 preview` | `参考` |
| [`0Z002`](../0z002/) | `0Z` | `stacked_diagnostics_accessed_without_active_handler` | `有效` | `9.2.0` | `9.2.24 → 18.6 (14)` | `all 1 preview` | `参考` |
| [`10608`](../10608/) | `10` | `invalid_argument_for_xquery` | `有效` | `18.0` | `18.6` | `all 1 preview` | `参考` |
| [`20000`](../20000/) | `20` | `case_not_found` | `有效` | `8.4.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`21000`](../21000/) | `21` | `cardinality_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`22000`](../22000/) | `22` | `data_exception` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22001`](../22001/) | `22` | `string_data_right_truncation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`22002`](../22002/) | `22` | `null_value_no_indicator_parameter` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22003`](../22003/) | `22` | `numeric_value_out_of_range` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`22004`](../22004/) | `22` | `null_value_not_allowed` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`22005`](../22005/) | `22` | `error_in_assignment` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22007`](../22007/) | `22` | `invalid_datetime_format` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`22008`](../22008/) | `22` | `datetime_field_overflow` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22009`](../22009/) | `22` | `invalid_time_zone_displacement_value` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2200B`](../2200b/) | `22` | `escape_character_conflict` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2200C`](../2200c/) | `22` | `invalid_use_of_escape_character` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2200D`](../2200d/) | `22` | `invalid_escape_octet` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2200F`](../2200f/) | `22` | `zero_length_character_string` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2200G`](../2200g/) | `22` | `most_specific_type_mismatch` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2200H`](../2200h/) | `22` | `sequence_generator_limit_exceeded` | `有效` | `10.0` | `10.23 → 18.6 (9)` | `all 1 preview` | `参考` |
| [`2200L`](../2200l/) | `22` | `not_an_xml_document` | `有效` | `8.3.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2200M`](../2200m/) | `22` | `invalid_xml_document` | `有效` | `8.3.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2200N`](../2200n/) | `22` | `invalid_xml_content` | `有效` | `8.3.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2200S`](../2200s/) | `22` | `invalid_xml_comment` | `有效` | `8.3.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2200T`](../2200t/) | `22` | `invalid_xml_processing_instruction` | `有效` | `8.3.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22010`](../22010/) | `22` | `invalid_indicator_parameter_value` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22011`](../22011/) | `22` | `substring_error` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22012`](../22012/) | `22` | `division_by_zero` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`22013`](../22013/) | `22` | `invalid_preceding_or_following_size` | `有效` | `11.0` | `11.22 → 18.6 (8)` | `all 1 preview` | `参考` |
| [`22014`](../22014/) | `22` | `invalid_argument_for_ntile_function` | `有效` | `8.4.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22015`](../22015/) | `22` | `interval_field_overflow` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22016`](../22016/) | `22` | `invalid_argument_for_nth_value_function` | `有效` | `8.4.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22018`](../22018/) | `22` | `invalid_character_value_for_cast` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22019`](../22019/) | `22` | `invalid_escape_character` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2201B`](../2201b/) | `22` | `invalid_regular_expression` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2201E`](../2201e/) | `22` | `invalid_argument_for_logarithm` | `有效` | `8.0.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2201F`](../2201f/) | `22` | `invalid_argument_for_power_function` | `有效` | `8.0.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2201G`](../2201g/) | `22` | `invalid_argument_for_width_bucket_function` | `有效` | `8.0.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2201W`](../2201w/) | `22` | `invalid_row_count_in_limit_clause` | `有效` | `8.4.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2201X`](../2201x/) | `22` | `invalid_row_count_in_result_offset_clause` | `有效` | `8.4.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22021`](../22021/) | `22` | `character_not_in_repertoire` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22022`](../22022/) | `22` | `indicator_overflow` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22023`](../22023/) | `22` | `invalid_parameter_value` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`22024`](../22024/) | `22` | `unterminated_c_string` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22025`](../22025/) | `22` | `invalid_escape_sequence` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22026`](../22026/) | `22` | `string_data_length_mismatch` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22027`](../22027/) | `22` | `trim_error` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2202E`](../2202e/) | `22` | `array_subscript_error` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`2202G`](../2202g/) | `22` | `invalid_tablesample_repeat` | `有效` | `9.5.0` | `9.5.25 → 18.6 (11)` | `all 1 preview` | `参考` |
| [`2202H`](../2202h/) | `22` | `invalid_tablesample_argument` | `有效` | `9.5.0` | `9.5.25 → 18.6 (11)` | `all 1 preview` | `参考` |
| [`22030`](../22030/) | `22` | `duplicate_json_object_key_value` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`22031`](../22031/) | `22` | `invalid_argument_for_sql_json_datetime_function` | `有效` | `13.0` | `13.23 → 18.6 (6)` | `all 1 preview` | `参考` |
| [`22032`](../22032/) | `22` | `invalid_json_text` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`22033`](../22033/) | `22` | `invalid_sql_json_subscript` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`22034`](../22034/) | `22` | `more_than_one_sql_json_item` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`22035`](../22035/) | `22` | `no_sql_json_item` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`22036`](../22036/) | `22` | `non_numeric_sql_json_item` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`22037`](../22037/) | `22` | `non_unique_keys_in_a_json_object` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`22038`](../22038/) | `22` | `singleton_sql_json_item_required` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`22039`](../22039/) | `22` | `sql_json_array_not_found` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`2203A`](../2203a/) | `22` | `sql_json_member_not_found` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`2203B`](../2203b/) | `22` | `sql_json_number_not_found` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`2203C`](../2203c/) | `22` | `sql_json_object_not_found` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`2203D`](../2203d/) | `22` | `too_many_json_array_elements` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`2203E`](../2203e/) | `22` | `too_many_json_object_members` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`2203F`](../2203f/) | `22` | `sql_json_scalar_required` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`2203G`](../2203g/) | `22` | `sql_json_item_cannot_be_cast_to_target_type` | `有效` | `15.0` | `15.19 → 18.6 (4)` | `all 1 preview` | `参考` |
| [`22P01`](../22p01/) | `22` | `floating_point_exception` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22P02`](../22p02/) | `22` | `invalid_text_representation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`22P03`](../22p03/) | `22` | `invalid_binary_representation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22P04`](../22p04/) | `22` | `bad_copy_file_format` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22P05`](../22p05/) | `22` | `untranslatable_character` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`22P06`](../22p06/) | `22` | `nonstandard_use_of_escape_character` | `有效` | `8.1.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`23000`](../23000/) | `23` | `integrity_constraint_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`23001`](../23001/) | `23` | `restrict_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`23502`](../23502/) | `23` | `not_null_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`23503`](../23503/) | `23` | `foreign_key_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`23505`](../23505/) | `23` | `unique_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`23514`](../23514/) | `23` | `check_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`23P01`](../23p01/) | `23` | `exclusion_violation` | `有效` | `9.0.0` | `all 16 formal` | `all 1 preview` | `完整` |
| [`24000`](../24000/) | `24` | `invalid_cursor_state` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`25000`](../25000/) | `25` | `invalid_transaction_state` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`25001`](../25001/) | `25` | `active_sql_transaction` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`25002`](../25002/) | `25` | `branch_transaction_already_active` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`25003`](../25003/) | `25` | `inappropriate_access_mode_for_branch_transaction` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`25004`](../25004/) | `25` | `inappropriate_isolation_level_for_branch_transaction` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`25005`](../25005/) | `25` | `no_active_sql_transaction_for_branch_transaction` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`25006`](../25006/) | `25` | `read_only_sql_transaction` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`25007`](../25007/) | `25` | `schema_and_data_statement_mixing_not_supported` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`25008`](../25008/) | `25` | `held_cursor_requires_same_isolation_level` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`25P01`](../25p01/) | `25` | `no_active_sql_transaction` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`25P02`](../25p02/) | `25` | `in_failed_sql_transaction` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`25P03`](../25p03/) | `25` | `idle_in_transaction_session_timeout` | `有效` | `9.6.0` | `9.6.24 → 18.6 (10)` | `all 1 preview` | `完整` |
| [`25P04`](../25p04/) | `25` | `transaction_timeout` | `有效` | `17.0` | `17.11 → 18.6 (2)` | `all 1 preview` | `完整` |
| [`26000`](../26000/) | `26` | `invalid_sql_statement_name` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`27000`](../27000/) | `27` | `triggered_data_change_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`28000`](../28000/) | `28` | `invalid_authorization_specification` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`28P01`](../28p01/) | `28` | `invalid_password` | `有效` | `9.0.0` | `all 16 formal` | `all 1 preview` | `完整` |
| [`2B000`](../2b000/) | `2B` | `dependent_privilege_descriptors_still_exist` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2BP01`](../2bp01/) | `2B` | `dependent_objects_still_exist` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`2D000`](../2d000/) | `2D` | `invalid_transaction_termination` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2F000`](../2f000/) | `2F` | `sql_routine_exception` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2F002`](../2f002/) | `2F` | `modifying_sql_data_not_permitted` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2F003`](../2f003/) | `2F` | `prohibited_sql_statement_attempted` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2F004`](../2f004/) | `2F` | `reading_sql_data_not_permitted` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`2F005`](../2f005/) | `2F` | `function_executed_no_return_statement` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`34000`](../34000/) | `34` | `invalid_cursor_name` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`38000`](../38000/) | `38` | `external_routine_exception` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`38001`](../38001/) | `38` | `containing_sql_not_permitted` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`38002`](../38002/) | `38` | `modifying_sql_data_not_permitted` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`38003`](../38003/) | `38` | `prohibited_sql_statement_attempted` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`38004`](../38004/) | `38` | `reading_sql_data_not_permitted` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`39000`](../39000/) | `39` | `external_routine_invocation_exception` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`39001`](../39001/) | `39` | `invalid_sqlstate_returned` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`39004`](../39004/) | `39` | `null_value_not_allowed` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`39P01`](../39p01/) | `39` | `trigger_protocol_violated` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`39P02`](../39p02/) | `39` | `srf_protocol_violated` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`39P03`](../39p03/) | `39` | `event_trigger_protocol_violated` | `有效` | `9.5.0` | `9.5.25 → 18.6 (11)` | `all 1 preview` | `参考` |
| [`3B000`](../3b000/) | `3B` | `savepoint_exception` | `有效` | `8.0.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`3B001`](../3b001/) | `3B` | `invalid_savepoint_specification` | `有效` | `8.0.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`3D000`](../3d000/) | `3D` | `invalid_catalog_name` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`3F000`](../3f000/) | `3F` | `invalid_schema_name` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`40000`](../40000/) | `40` | `transaction_rollback` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`40001`](../40001/) | `40` | `serialization_failure` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`40002`](../40002/) | `40` | `transaction_integrity_constraint_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`40003`](../40003/) | `40` | `statement_completion_unknown` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`40P01`](../40p01/) | `40` | `deadlock_detected` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42000`](../42000/) | `42` | `syntax_error_or_access_rule_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42501`](../42501/) | `42` | `insufficient_privilege` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42601`](../42601/) | `42` | `syntax_error` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42602`](../42602/) | `42` | `invalid_name` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42611`](../42611/) | `42` | `invalid_column_definition` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42622`](../42622/) | `42` | `name_too_long` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42701`](../42701/) | `42` | `duplicate_column` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42702`](../42702/) | `42` | `ambiguous_column` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42703`](../42703/) | `42` | `undefined_column` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42704`](../42704/) | `42` | `undefined_object` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42710`](../42710/) | `42` | `duplicate_object` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42712`](../42712/) | `42` | `duplicate_alias` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42723`](../42723/) | `42` | `duplicate_function` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42725`](../42725/) | `42` | `ambiguous_function` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42803`](../42803/) | `42` | `grouping_error` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42804`](../42804/) | `42` | `datatype_mismatch` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42809`](../42809/) | `42` | `wrong_object_type` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42830`](../42830/) | `42` | `invalid_foreign_key` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42846`](../42846/) | `42` | `cannot_coerce` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42883`](../42883/) | `42` | `undefined_function` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`428C9`](../428c9/) | `42` | `generated_always` | `有效` | `10.0` | `10.23 → 18.6 (9)` | `all 1 preview` | `完整` |
| [`42939`](../42939/) | `42` | `reserved_name` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42P01`](../42p01/) | `42` | `undefined_table` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42P02`](../42p02/) | `42` | `undefined_parameter` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42P03`](../42p03/) | `42` | `duplicate_cursor` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42P04`](../42p04/) | `42` | `duplicate_database` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42P05`](../42p05/) | `42` | `duplicate_prepared_statement` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42P06`](../42p06/) | `42` | `duplicate_schema` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42P07`](../42p07/) | `42` | `duplicate_table` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42P08`](../42p08/) | `42` | `ambiguous_parameter` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42P09`](../42p09/) | `42` | `ambiguous_alias` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42P10`](../42p10/) | `42` | `invalid_column_reference` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42P11`](../42p11/) | `42` | `invalid_cursor_definition` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42P12`](../42p12/) | `42` | `invalid_database_definition` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42P13`](../42p13/) | `42` | `invalid_function_definition` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42P14`](../42p14/) | `42` | `invalid_prepared_statement_definition` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42P15`](../42p15/) | `42` | `invalid_schema_definition` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42P16`](../42p16/) | `42` | `invalid_table_definition` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42P17`](../42p17/) | `42` | `invalid_object_definition` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42P18`](../42p18/) | `42` | `indeterminate_datatype` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`42P19`](../42p19/) | `42` | `invalid_recursion` | `有效` | `8.4.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42P20`](../42p20/) | `42` | `windowing_error` | `有效` | `8.4.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`42P21`](../42p21/) | `42` | `collation_mismatch` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`42P22`](../42p22/) | `42` | `indeterminate_collation` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`44000`](../44000/) | `44` | `with_check_option_violation` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`53000`](../53000/) | `53` | `insufficient_resources` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`53100`](../53100/) | `53` | `disk_full` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`53200`](../53200/) | `53` | `out_of_memory` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`53300`](../53300/) | `53` | `too_many_connections` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`53400`](../53400/) | `53` | `configuration_limit_exceeded` | `有效` | `9.2.0` | `9.2.24 → 18.6 (14)` | `all 1 preview` | `完整` |
| [`54000`](../54000/) | `54` | `program_limit_exceeded` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`54001`](../54001/) | `54` | `statement_too_complex` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`54011`](../54011/) | `54` | `too_many_columns` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`54023`](../54023/) | `54` | `too_many_arguments` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`55000`](../55000/) | `55` | `object_not_in_prerequisite_state` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`55006`](../55006/) | `55` | `object_in_use` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`55P02`](../55p02/) | `55` | `cant_change_runtime_param` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`55P03`](../55p03/) | `55` | `lock_not_available` | `有效` | `8.0.0` | `all 16 formal` | `all 1 preview` | `完整` |
| [`55P04`](../55p04/) | `55` | `unsafe_new_enum_value_usage` | `有效` | `12.0` | `12.22 → 18.6 (7)` | `all 1 preview` | `参考` |
| [`57000`](../57000/) | `57` | `operator_intervention` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`57014`](../57014/) | `57` | `query_canceled` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`57P01`](../57p01/) | `57` | `admin_shutdown` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`57P02`](../57p02/) | `57` | `crash_shutdown` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`57P03`](../57p03/) | `57` | `cannot_connect_now` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`57P04`](../57p04/) | `57` | `database_dropped` | `有效` | `9.0.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`57P05`](../57p05/) | `57` | `idle_session_timeout` | `有效` | `14.0` | `14.24 → 18.6 (5)` | `all 1 preview` | `完整` |
| [`58000`](../58000/) | `58` | `system_error` | `有效` | `9.2.0` | `9.2.24 → 18.6 (14)` | `all 1 preview` | `参考` |
| [`58030`](../58030/) | `58` | `io_error` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`58P01`](../58p01/) | `58` | `undefined_file` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`58P02`](../58p02/) | `58` | `duplicate_file` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`58P03`](../58p03/) | `58` | `file_name_too_long` | `有效` | `18.0` | `18.6` | `all 1 preview` | `完整` |
| [`72000`](../72000/) | `72` | `snapshot_too_old` | `已移除` | `9.6.0` | `9.6.24 → 16.15 (8)` | `—` | `完整` |
| [`F0000`](../f0000/) | `F0` | `config_file_error` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`F0001`](../f0001/) | `F0` | `lock_file_exists` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`HV000`](../hv000/) | `HV` | `fdw_error` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV001`](../hv001/) | `HV` | `fdw_out_of_memory` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV002`](../hv002/) | `HV` | `fdw_dynamic_parameter_value_needed` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV004`](../hv004/) | `HV` | `fdw_invalid_data_type` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV005`](../hv005/) | `HV` | `fdw_column_name_not_found` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV006`](../hv006/) | `HV` | `fdw_invalid_data_type_descriptors` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV007`](../hv007/) | `HV` | `fdw_invalid_column_name` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV008`](../hv008/) | `HV` | `fdw_invalid_column_number` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV009`](../hv009/) | `HV` | `fdw_invalid_use_of_null_pointer` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00A`](../hv00a/) | `HV` | `fdw_invalid_string_format` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00B`](../hv00b/) | `HV` | `fdw_invalid_handle` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00C`](../hv00c/) | `HV` | `fdw_invalid_option_index` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00D`](../hv00d/) | `HV` | `fdw_invalid_option_name` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00J`](../hv00j/) | `HV` | `fdw_option_name_not_found` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00K`](../hv00k/) | `HV` | `fdw_reply_handle` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00L`](../hv00l/) | `HV` | `fdw_unable_to_create_execution` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00M`](../hv00m/) | `HV` | `fdw_unable_to_create_reply` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00N`](../hv00n/) | `HV` | `fdw_unable_to_establish_connection` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00P`](../hv00p/) | `HV` | `fdw_no_schemas` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00Q`](../hv00q/) | `HV` | `fdw_schema_not_found` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV00R`](../hv00r/) | `HV` | `fdw_table_not_found` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV010`](../hv010/) | `HV` | `fdw_function_sequence_error` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV014`](../hv014/) | `HV` | `fdw_too_many_handles` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV021`](../hv021/) | `HV` | `fdw_inconsistent_descriptor_information` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV024`](../hv024/) | `HV` | `fdw_invalid_attribute_value` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV090`](../hv090/) | `HV` | `fdw_invalid_string_length_or_buffer_length` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`HV091`](../hv091/) | `HV` | `fdw_invalid_descriptor_field_identifier` | `有效` | `9.1.0` | `9.1.24 → 18.6 (15)` | `all 1 preview` | `参考` |
| [`P0000`](../p0000/) | `P0` | `plpgsql_error` | `有效` | `8.0.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`P0001`](../p0001/) | `P0` | `raise_exception` | `有效` | `8.0.0` | `all 16 formal` | `all 1 preview` | `完整` |
| [`P0002`](../p0002/) | `P0` | `no_data_found` | `有效` | `8.2.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`P0003`](../p0003/) | `P0` | `too_many_rows` | `有效` | `8.2.0` | `all 16 formal` | `all 1 preview` | `参考` |
| [`P0004`](../p0004/) | `P0` | `assert_failure` | `有效` | `9.5.0` | `9.5.25 → 18.6 (11)` | `all 1 preview` | `完整` |
| [`XX000`](../xx000/) | `XX` | `internal_error` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `参考` |
| [`XX001`](../xx001/) | `XX` | `data_corrupted` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |
| [`XX002`](../xx002/) | `XX` | `index_corrupted` | `有效` | `7.4` | `all 16 formal` | `all 1 preview` | `完整` |

<!-- END SQLSTATE INDEX -->

---

反链：

- [SQLSTATE 大典](/zh/)
