All SQLSTATE codes

The complete SQLSTATE directory, generated from frozen PostgreSQL release sources.

Browse the complete SQLSTATE catalogue by class, version and content depth. Each code links to reviewed English and Chinese explanations. See the coverage page for current content and runtime coverage.

Read the methodology page for the identity and evidence contract.

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