# PostgreSQL SQLSTATE Atlas > Find a PostgreSQL SQLSTATE, understand the failure stage, and find diagnosis and recovery guidance. --- Start with the five-character code from a driver exception or server log. The catalogue keeps the SQLSTATE uppercase as its stable identity; URLs use lowercase where a letter is present. Search covers condition names, macros, translated names, and verified message templates. ## Browse the atlas {#browse} | Entry point | Use it for | | --- | --- | | [All codes](codes/) | The complete deduplicated SQLSTATE directory | | [Classes](classes/) | Shared meaning and members of a class | | [Common codes](common/) | A curated incident-oriented starting list | | [Topics](topics/) | Constraint, authentication, transaction, timeout, and resource paths | | [Versions](versions/) | Presence and evidence-backed changes by PostgreSQL release | | [Guides](guides/) | Reading diagnostics, transaction recovery, retry, and client handling | ## Evidence contract {#evidence} Each accepted entry separates directory identity, implementation paths, documented behavior, and local runtime observations. A source-only fact is labelled as such; a runtime claim names its case and run result. Preview releases are kept in their own version view and do not inflate the formal release count. The directory contains all 263 frozen SQLSTATE identities as paired English and Chinese pages. Coverage reports distinguish full explanations, source-backed references, editorial review, and selected runtime outcomes; a source-backed reference does not claim a runtime diagnosis without a retained case result. ## Coverage {#coverage} See [coverage](coverage/) for the version matrix and [methodology](methodology/) for collection boundaries, evidence states, and translation rules. --- Section pages: - [All SQLSTATE codes](/codes/): The complete SQLSTATE directory, generated from frozen PostgreSQL release sources. - [SQLSTATE classes](/classes/): Browse PostgreSQL conditions by the first two characters of SQLSTATE. - [Common codes](/common/): A curated list of SQLSTATE values useful during incident triage. - [Topics](/topics/): Start from an operational problem and find its SQLSTATE paths. - [PostgreSQL versions](/versions/): Compare SQLSTATE definitions and documented changes across releases. - [Guides](/guides/): Shared methods for reading PostgreSQL diagnostics, recovering transaction state, and choosing client boundaries. - [Coverage](/coverage/): Version, language, content-depth, and evidence coverage for the atlas. - [Methodology](/methodology/): Scope, source locking, evidence states, and translation maintenance for the SQLSTATE atlas. - [00000 — successful_completion](/00000/): PostgreSQL SQLSTATE 00000 represents successful completion and is not a normal error condition. - [01000 — warning](/01000/): PostgreSQL uses SQLSTATE 01000 for the generic warning condition. Separate directory classification from the actual WARNING or NOTICE severity, then diagnose the emitting subsystem. - [01003 — null_value_eliminated_in_set_function](/01003/): PostgreSQL SQLSTATE 01003 names a warning for null values eliminated by a set function; the fixed core scan provides no emitting path. - [01004 — string_data_right_truncation](/01004/): PostgreSQL SQLSTATE 01004 names a warning-category string truncation condition; the fixed core scan provides no emitting path. - [01006 — privilege_not_revoked](/01006/): PostgreSQL SQLSTATE 01006 is emitted as a WARNING when a REVOKE operation removes none or not all of the requested privileges. - [01007 — privilege_not_granted](/01007/): PostgreSQL SQLSTATE 01007 is emitted as a WARNING when a GRANT operation grants none or not all of the requested privileges. - [01008 — implicit_zero_bit_padding](/01008/): PostgreSQL SQLSTATE 01008 names a warning for implicit zero-bit padding; the fixed core scan provides no emitting path. - [0100C — dynamic_result_sets_returned](/0100c/): PostgreSQL SQLSTATE 0100C names a warning for dynamic result sets returned; the fixed core scan provides no emitting path. - [01P01 — deprecated_feature](/01p01/): PostgreSQL SQLSTATE 01P01 is a WARNING used to announce a deprecated feature; PostgreSQL 18.6 has a fixed MD5-password path. - [02000 — no_data](/02000/): PostgreSQL SQLSTATE 02000 is a no-data condition; PostgreSQL 18.6 has DEBUG diagnostics in amcheck, not a rule that every zero-row SELECT raises it. - [02001 — no_additional_dynamic_result_sets_returned](/02001/): PostgreSQL SQLSTATE 02001 names a no-additional-dynamic-result-sets condition; the fixed core scan provides no emitting path. - [03000 — sql_statement_not_yet_complete](/03000/): PostgreSQL SQLSTATE 03000 names an incomplete SQL-statement condition; the fixed core scan provides no resolved emitter. - [08000 — connection_exception](/08000/): PostgreSQL SQLSTATE 08000: connection_exception, source-backed diagnosis and recovery guidance. - [08001 — sqlclient_unable_to_establish_sqlconnection](/08001/): PostgreSQL SQLSTATE 08001: sqlclient_unable_to_establish_sqlconnection, source-backed diagnosis and recovery guidance. - [08003 — connection_does_not_exist](/08003/): PostgreSQL SQLSTATE 08003: connection_does_not_exist, source-backed diagnosis and recovery guidance. - [08004 — sqlserver_rejected_establishment_of_sqlconnection](/08004/): PostgreSQL SQLSTATE 08004: sqlserver_rejected_establishment_of_sqlconnection, source-backed diagnosis and recovery guidance. - [08006 — connection_failure](/08006/): PostgreSQL SQLSTATE 08006: connection_failure, source-backed diagnosis and recovery guidance. - [08007 — transaction_resolution_unknown](/08007/): PostgreSQL SQLSTATE 08007: transaction_resolution_unknown, source-backed diagnosis and recovery guidance. - [08P01 — protocol_violation](/08p01/): PostgreSQL SQLSTATE 08P01: protocol_violation, source-backed diagnosis and recovery guidance. - [09000 — triggered_action_exception](/09000/): Source-backed reference for PostgreSQL SQLSTATE 09000. - [0A000 — feature_not_supported](/0a000/): PostgreSQL SQLSTATE 0A000: feature_not_supported, source-backed diagnosis and recovery guidance. - [0B000 — invalid_transaction_initiation](/0b000/): Source-bounded reference for PostgreSQL SQLSTATE 0B000. - [0F000 — locator_exception](/0f000/): Source-bounded reference for PostgreSQL SQLSTATE 0F000. - [0F001 — invalid_locator_specification](/0f001/): Source-bounded reference for PostgreSQL SQLSTATE 0F001. - [0L000 — invalid_grantor](/0l000/): PostgreSQL SQLSTATE 0L000: invalid_grantor, source-backed diagnosis and recovery guidance. - [0LP01 — invalid_grant_operation](/0lp01/): PostgreSQL SQLSTATE 0LP01: invalid_grant_operation, source-backed diagnosis and recovery guidance. - [0P000 — invalid_role_specification](/0p000/): PostgreSQL SQLSTATE 0P000: invalid_role_specification, source-backed diagnosis and recovery guidance. - [0Z000 — diagnostics_exception](/0z000/): Source-bounded reference for PostgreSQL SQLSTATE 0Z000. - [0Z002 — stacked_diagnostics_accessed_without_active_handler](/0z002/): Source-backed reference for PostgreSQL SQLSTATE 0Z002. - [10608 — invalid_argument_for_xquery](/10608/): Source-backed reference for PostgreSQL SQLSTATE 10608. - [20000 — case_not_found](/20000/): Source-backed reference for PostgreSQL SQLSTATE 20000. - [21000 — cardinality_violation](/21000/): PostgreSQL SQLSTATE 21000: cardinality_violation, with source-backed scalar-subquery and command-level diagnostics. - [22000 — data_exception](/22000/): Source-backed reference for PostgreSQL SQLSTATE 22000. - [22001 — string_data_right_truncation](/22001/): Source-backed reference for PostgreSQL SQLSTATE 22001. - [22002 — null_value_no_indicator_parameter](/22002/): Source-backed reference for PostgreSQL SQLSTATE 22002. - [22003 — numeric_value_out_of_range](/22003/): Source-backed reference for PostgreSQL SQLSTATE 22003. - [22004 — null_value_not_allowed](/22004/): Source-backed reference for PostgreSQL SQLSTATE 22004. - [22005 — error_in_assignment](/22005/): Source-backed reference for PostgreSQL SQLSTATE 22005. - [22007 — invalid_datetime_format](/22007/): Source-backed reference for PostgreSQL SQLSTATE 22007. - [22008 — datetime_field_overflow](/22008/): Source-backed reference for PostgreSQL SQLSTATE 22008. - [22009 — invalid_time_zone_displacement_value](/22009/): Source-backed reference for PostgreSQL SQLSTATE 22009. - [2200B — escape_character_conflict](/2200b/): Source-backed reference for PostgreSQL SQLSTATE 2200B. - [2200C — invalid_use_of_escape_character](/2200c/): Source-backed reference for PostgreSQL SQLSTATE 2200C. - [2200D — invalid_escape_octet](/2200d/): Source-backed reference for PostgreSQL SQLSTATE 2200D. - [2200F — zero_length_character_string](/2200f/): Source-backed reference for PostgreSQL SQLSTATE 2200F. - [2200G — most_specific_type_mismatch](/2200g/): Source-backed reference for PostgreSQL SQLSTATE 2200G. - [2200H — sequence_generator_limit_exceeded](/2200h/): Source-backed reference for PostgreSQL SQLSTATE 2200H. - [2200L — not_an_xml_document](/2200l/): Source-backed reference for PostgreSQL SQLSTATE 2200L. - [2200M — invalid_xml_document](/2200m/): Source-backed reference for PostgreSQL SQLSTATE 2200M. - [2200N — invalid_xml_content](/2200n/): Source-backed reference for PostgreSQL SQLSTATE 2200N. - [2200S — invalid_xml_comment](/2200s/): Source-backed reference for PostgreSQL SQLSTATE 2200S. - [2200T — invalid_xml_processing_instruction](/2200t/): Source-backed reference for PostgreSQL SQLSTATE 2200T. - [22010 — invalid_indicator_parameter_value](/22010/): Source-backed reference for PostgreSQL SQLSTATE 22010. - [22011 — substring_error](/22011/): Source-backed reference for PostgreSQL SQLSTATE 22011. - [22012 — division_by_zero](/22012/): Source-backed reference for PostgreSQL SQLSTATE 22012. - [22013 — invalid_preceding_or_following_size](/22013/): Source-backed reference for PostgreSQL SQLSTATE 22013. - [22014 — invalid_argument_for_ntile_function](/22014/): Source-backed reference for PostgreSQL SQLSTATE 22014. - [22015 — interval_field_overflow](/22015/): Source-backed reference for PostgreSQL SQLSTATE 22015. - [22016 — invalid_argument_for_nth_value_function](/22016/): Source-backed reference for PostgreSQL SQLSTATE 22016. - [22018 — invalid_character_value_for_cast](/22018/): Source-backed reference for PostgreSQL SQLSTATE 22018. - [22019 — invalid_escape_character](/22019/): Source-backed reference for PostgreSQL SQLSTATE 22019. - [2201B — invalid_regular_expression](/2201b/): Source-backed reference for PostgreSQL SQLSTATE 2201B. - [2201E — invalid_argument_for_logarithm](/2201e/): Source-backed reference for PostgreSQL SQLSTATE 2201E. - [2201F — invalid_argument_for_power_function](/2201f/): Source-backed reference for PostgreSQL SQLSTATE 2201F. - [2201G — invalid_argument_for_width_bucket_function](/2201g/): Source-backed reference for PostgreSQL SQLSTATE 2201G. - [2201W — invalid_row_count_in_limit_clause](/2201w/): Source-backed reference for PostgreSQL SQLSTATE 2201W. - [2201X — invalid_row_count_in_result_offset_clause](/2201x/): Source-backed reference for PostgreSQL SQLSTATE 2201X. - [22021 — character_not_in_repertoire](/22021/): Source-backed reference for PostgreSQL SQLSTATE 22021. - [22022 — indicator_overflow](/22022/): Source-backed reference for PostgreSQL SQLSTATE 22022. - [22023 — invalid_parameter_value](/22023/): Source-backed reference for PostgreSQL SQLSTATE 22023. - [22024 — unterminated_c_string](/22024/): Source-backed reference for PostgreSQL SQLSTATE 22024. - [22025 — invalid_escape_sequence](/22025/): Source-backed reference for PostgreSQL SQLSTATE 22025. - [22026 — string_data_length_mismatch](/22026/): Source-backed reference for PostgreSQL SQLSTATE 22026. - [22027 — trim_error](/22027/): Source-backed reference for PostgreSQL SQLSTATE 22027. - [2202E — array_subscript_error](/2202e/): PostgreSQL uses SQLSTATE 2202E for array subscript and shape errors. Separate an out-of-bounds read that returns NULL from assignment, slice, constructor, and concatenation paths that validate array dimensions. - [2202G — invalid_tablesample_repeat](/2202g/): Source-backed reference for PostgreSQL SQLSTATE 2202G. - [2202H — invalid_tablesample_argument](/2202h/): Source-backed reference for PostgreSQL SQLSTATE 2202H. - [22030 — duplicate_json_object_key_value](/22030/): Source-backed reference for PostgreSQL SQLSTATE 22030. - [22031 — invalid_argument_for_sql_json_datetime_function](/22031/): Source-backed reference for PostgreSQL SQLSTATE 22031. - [22032 — invalid_json_text](/22032/): Source-backed reference for PostgreSQL SQLSTATE 22032. - [22033 — invalid_sql_json_subscript](/22033/): Source-backed reference for PostgreSQL SQLSTATE 22033. - [22034 — more_than_one_sql_json_item](/22034/): Source-backed reference for PostgreSQL SQLSTATE 22034. - [22035 — no_sql_json_item](/22035/): Source-backed reference for PostgreSQL SQLSTATE 22035. - [22036 — non_numeric_sql_json_item](/22036/): Source-backed reference for PostgreSQL SQLSTATE 22036. - [22037 — non_unique_keys_in_a_json_object](/22037/): Source-backed reference for PostgreSQL SQLSTATE 22037. - [22038 — singleton_sql_json_item_required](/22038/): Source-backed reference for PostgreSQL SQLSTATE 22038. - [22039 — sql_json_array_not_found](/22039/): Source-backed reference for PostgreSQL SQLSTATE 22039. - [2203A — sql_json_member_not_found](/2203a/): Source-backed reference for PostgreSQL SQLSTATE 2203A. - [2203B — sql_json_number_not_found](/2203b/): Source-backed reference for PostgreSQL SQLSTATE 2203B. - [2203C — sql_json_object_not_found](/2203c/): Source-backed reference for PostgreSQL SQLSTATE 2203C. - [2203D — too_many_json_array_elements](/2203d/): Source-backed reference for PostgreSQL SQLSTATE 2203D. - [2203E — too_many_json_object_members](/2203e/): Source-backed reference for PostgreSQL SQLSTATE 2203E. - [2203F — sql_json_scalar_required](/2203f/): Source-backed reference for PostgreSQL SQLSTATE 2203F. - [2203G — sql_json_item_cannot_be_cast_to_target_type](/2203g/): Source-backed reference for PostgreSQL SQLSTATE 2203G. - [22P01 — floating_point_exception](/22p01/): Source-backed reference for PostgreSQL SQLSTATE 22P01. - [22P02 — Invalid text representation](/22p02/): PostgreSQL SQLSTATE 22P02: Invalid text representation (invalid_text_representation), source-backed diagnosis and recovery guidance. - [22P03 — invalid_binary_representation](/22p03/): Source-backed reference for PostgreSQL SQLSTATE 22P03. - [22P04 — bad_copy_file_format](/22p04/): Source-backed reference for PostgreSQL SQLSTATE 22P04. - [22P05 — untranslatable_character](/22p05/): Source-backed reference for PostgreSQL SQLSTATE 22P05. - [22P06 — nonstandard_use_of_escape_character](/22p06/): Source-backed reference for PostgreSQL SQLSTATE 22P06. - [23000 — integrity_constraint_violation](/23000/): PostgreSQL SQLSTATE 23000: the Class 23 integrity_constraint_violation umbrella and its concrete descendants. - [23001 — restrict_violation](/23001/): PostgreSQL SQLSTATE 23001: restrict_violation from an immediate foreign-key RESTRICT action. - [23502 — not_null_violation](/23502/): PostgreSQL SQLSTATE 23502: not_null_violation with column-aware diagnosis and repair boundaries. - [23503 — foreign_key_violation](/23503/): PostgreSQL reports SQLSTATE 23503 for a child foreign-key violation and some ordinary parent actions. Identify the action, relation, and constraint, then repair the data or transaction boundary. - [23505 — unique_violation](/23505/): PostgreSQL reports 23505 when a row or index operation violates a unique invariant. Diagnose the named object, recover the transaction, and choose a business-safe repair. - [23514 — check_violation](/23514/): PostgreSQL SQLSTATE 23514: check_violation with CHECK and partition validation boundaries. - [23P01 — exclusion_violation](/23p01/): PostgreSQL SQLSTATE 23P01: exclusion_violation for conflicting exclusion-constraint operators. - [24000 — invalid_cursor_state](/24000/): PostgreSQL SQLSTATE 24000: invalid_cursor_state for a cursor that is not positioned on a row. - [25000 — invalid_transaction_state](/25000/): PostgreSQL SQLSTATE 25000: the broad invalid_transaction_state condition and its internal parallel-operation boundary. - [25001 — active_sql_transaction](/25001/): PostgreSQL SQLSTATE 25001: active_sql_transaction and the explicit transaction boundary required by utility commands. - [25002 — branch_transaction_already_active](/25002/): PostgreSQL SQLSTATE 25002: the narrow branch_transaction_already_active definition. - [25003 — inappropriate_access_mode_for_branch_transaction](/25003/): PostgreSQL SQLSTATE 25003: the branch-transaction access-mode condition, with a conservative source boundary. - [25004 — inappropriate_isolation_level_for_branch_transaction](/25004/): PostgreSQL SQLSTATE 25004: the branch-transaction isolation-level condition, with a fixed source boundary. - [25005 — no_active_sql_transaction_for_branch_transaction](/25005/): PostgreSQL SQLSTATE 25005: the branch-transaction no-active-transaction condition and its source-only boundary. - [25006 — read_only_sql_transaction](/25006/): PostgreSQL SQLSTATE 25006: read-only transaction failures, diagnostics, and the transaction boundary needed for repair. - [25007 — schema_and_data_statement_mixing_not_supported](/25007/): PostgreSQL SQLSTATE 25007: the schema/data statement mixing condition and its conservative source boundary. - [25008 — held_cursor_requires_same_isolation_level](/25008/): PostgreSQL SQLSTATE 25008: the held-cursor isolation-level condition and its source-only boundary. - [25P01 — no_active_sql_transaction](/25p01/): PostgreSQL SQLSTATE 25P01: operations such as SAVEPOINT require an explicit transaction block. - [25P02 — in_failed_sql_transaction](/25p02/): PostgreSQL SQLSTATE 25P02: the secondary transaction state after an earlier statement error. - [25P03 — idle_in_transaction_session_timeout](/25p03/): PostgreSQL SQLSTATE 25P03: diagnosing and recovering from server termination of a session idle inside an open transaction. - [25P04 — transaction_timeout](/25p04/): PostgreSQL SQLSTATE 25P04: session termination when an explicit or implicit transaction exceeds transaction_timeout. - [26000 — invalid_sql_statement_name](/26000/): PostgreSQL SQLSTATE 26000: named prepared statement lookup, session affinity, and recovery. - [27000 — triggered_data_change_violation](/27000/): Source-backed reference for PostgreSQL SQLSTATE 27000, with explicit mechanism boundaries. - [28000 — invalid_authorization_specification](/28000/): PostgreSQL SQLSTATE 28000: invalid_authorization_specification, source-backed diagnosis and recovery guidance. - [28P01 — invalid_password](/28p01/): PostgreSQL reports SQLSTATE 28P01 when password authentication fails during connection startup. Check the matched pg_hba.conf rule and role secret, then prove recovery with a fresh connection. - [2B000 — dependent_privilege_descriptors_still_exist](/2b000/): Source-backed reference for PostgreSQL SQLSTATE 2B000, with explicit mechanism boundaries. - [2BP01 — dependent_objects_still_exist](/2bp01/): PostgreSQL SQLSTATE 2BP01: dependency-aware DROP diagnostics and repair. - [2D000 — invalid_transaction_termination](/2d000/): Source-backed reference for PostgreSQL SQLSTATE 2D000, with explicit mechanism boundaries. - [2F000 — sql_routine_exception](/2f000/): Source-bounded reference for PostgreSQL SQLSTATE 2F000. - [2F002 — modifying_sql_data_not_permitted](/2f002/): Source-bounded reference for PostgreSQL SQLSTATE 2F002. - [2F003 — prohibited_sql_statement_attempted](/2f003/): Source-backed reference for PostgreSQL SQLSTATE 2F003. - [2F004 — reading_sql_data_not_permitted](/2f004/): Source-backed reference for PostgreSQL SQLSTATE 2F004. - [2F005 — function_executed_no_return_statement](/2f005/): Source-backed reference for PostgreSQL SQLSTATE 2F005. - [34000 — invalid_cursor_name](/34000/): PostgreSQL SQLSTATE 34000: cursor lifecycle, session affinity, and recovery. - [38000 — external_routine_exception](/38000/): Source-backed reference for PostgreSQL SQLSTATE 38000. - [38001 — containing_sql_not_permitted](/38001/): Source-backed reference for PostgreSQL SQLSTATE 38001. - [38002 — modifying_sql_data_not_permitted](/38002/): Source-backed reference for PostgreSQL SQLSTATE 38002. - [38003 — prohibited_sql_statement_attempted](/38003/): Source-backed reference for PostgreSQL SQLSTATE 38003. - [38004 — reading_sql_data_not_permitted](/38004/): Source-backed reference for PostgreSQL SQLSTATE 38004. - [39000 — external_routine_invocation_exception](/39000/): Source-backed reference for PostgreSQL SQLSTATE 39000. - [39001 — invalid_sqlstate_returned](/39001/): Source-backed reference for PostgreSQL SQLSTATE 39001. - [39004 — null_value_not_allowed](/39004/): Source-backed reference for PostgreSQL SQLSTATE 39004. - [39P01 — trigger_protocol_violated](/39p01/): Source-backed reference for PostgreSQL SQLSTATE 39P01. - [39P02 — srf_protocol_violated](/39p02/): Source-backed reference for PostgreSQL SQLSTATE 39P02. - [39P03 — event_trigger_protocol_violated](/39p03/): Source-backed reference for PostgreSQL SQLSTATE 39P03. - [3B000 — savepoint_exception](/3b000/): Source-backed reference for PostgreSQL SQLSTATE 3B000, with explicit mechanism boundaries. - [3B001 — invalid_savepoint_specification](/3b001/): PostgreSQL SQLSTATE 3B001: missing savepoints, transaction state, and recovery. - [3D000 — invalid_catalog_name](/3d000/): PostgreSQL SQLSTATE 3D000: invalid_catalog_name, source-backed diagnosis and recovery guidance. - [3F000 — invalid_schema_name](/3f000/): PostgreSQL SQLSTATE 3F000: invalid_schema_name, source-backed diagnosis and recovery guidance. - [40000 — transaction_rollback](/40000/): Source-backed reference for PostgreSQL SQLSTATE 40000, with explicit mechanism boundaries. - [40001 — serialization_failure](/40001/): PostgreSQL reports SQLSTATE 40001 when a serializable transaction cannot be committed consistently with a concurrent update. Roll back and retry the complete transaction from a fresh snapshot. - [40002 — transaction_integrity_constraint_violation](/40002/): Source-backed reference for PostgreSQL SQLSTATE 40002, with explicit mechanism boundaries. - [40003 — statement_completion_unknown](/40003/): Source-backed reference for PostgreSQL SQLSTATE 40003, with explicit mechanism boundaries. - [40P01 — deadlock_detected](/40p01/): PostgreSQL reports SQLSTATE 40P01 when transactions form a lock cycle. Roll back the victim, keep lock order consistent, and retry the complete operation only when its business semantics permit it. - [42000 — syntax_error_or_access_rule_violation](/42000/): PostgreSQL SQLSTATE 42000: syntax_error_or_access_rule_violation, source-backed diagnosis and recovery guidance. - [42501 — insufficient_privilege](/42501/): PostgreSQL SQLSTATE 42501: insufficient_privilege, source-backed diagnosis and recovery guidance. - [42601 — syntax_error](/42601/): PostgreSQL SQLSTATE 42601: syntax_error, source-backed diagnosis and recovery guidance. - [42602 — invalid_name](/42602/): PostgreSQL SQLSTATE 42602: invalid_name, source-backed diagnosis and recovery guidance. - [42611 — invalid_column_definition](/42611/): PostgreSQL SQLSTATE 42611: invalid_column_definition, source-backed diagnosis and recovery guidance. - [42622 — name_too_long](/42622/): PostgreSQL SQLSTATE 42622: name_too_long, source-backed diagnosis and recovery guidance. - [42701 — duplicate_column](/42701/): PostgreSQL SQLSTATE 42701: duplicate_column, source-backed diagnosis and recovery guidance. - [42702 — ambiguous_column](/42702/): PostgreSQL SQLSTATE 42702: ambiguous_column, source-backed diagnosis and recovery guidance. - [42703 — undefined_column](/42703/): PostgreSQL SQLSTATE 42703: undefined_column, source-backed diagnosis and recovery guidance. - [42704 — undefined_object](/42704/): PostgreSQL SQLSTATE 42704: undefined_object, source-backed diagnosis and recovery guidance. - [42710 — Duplicate object](/42710/): PostgreSQL SQLSTATE 42710: Duplicate object (duplicate_object), source-backed diagnosis and recovery guidance. - [42712 — Duplicate alias](/42712/): PostgreSQL SQLSTATE 42712: Duplicate alias (duplicate_alias), source-backed diagnosis and recovery guidance. - [42723 — Duplicate function](/42723/): PostgreSQL SQLSTATE 42723: Duplicate function (duplicate_function), source-backed diagnosis and recovery guidance. - [42725 — Ambiguous function](/42725/): PostgreSQL SQLSTATE 42725: Ambiguous function (ambiguous_function), source-backed diagnosis and recovery guidance. - [42803 — Grouping error](/42803/): PostgreSQL SQLSTATE 42803: Grouping error (grouping_error), source-backed diagnosis and recovery guidance. - [42804 — Datatype mismatch](/42804/): PostgreSQL SQLSTATE 42804: Datatype mismatch (datatype_mismatch), source-backed diagnosis and recovery guidance. - [42809 — Wrong object type](/42809/): PostgreSQL SQLSTATE 42809: Wrong object type (wrong_object_type), source-backed diagnosis and recovery guidance. - [42830 — Invalid foreign key](/42830/): PostgreSQL SQLSTATE 42830: Invalid foreign key (invalid_foreign_key), source-backed diagnosis and recovery guidance. - [42846 — Cannot coerce](/42846/): PostgreSQL SQLSTATE 42846: Cannot coerce (cannot_coerce), source-backed diagnosis and recovery guidance. - [42883 — Undefined function](/42883/): PostgreSQL SQLSTATE 42883: Undefined function (undefined_function), source-backed diagnosis and recovery guidance. - [428C9 — Generated-always column assignment](/428c9/): PostgreSQL SQLSTATE 428C9: Generated-always column assignment (generated_always), source-backed diagnosis and recovery guidance. - [42939 — Reserved name](/42939/): PostgreSQL SQLSTATE 42939: Reserved name (reserved_name), source-backed diagnosis and recovery guidance. - [42P01 — undefined_table](/42p01/): PostgreSQL reports SQLSTATE 42P01 when a referenced relation cannot be resolved. Check schema qualification, search_path, quoting, and migrations before creating or renaming objects. - [42P02 — Undefined parameter](/42p02/): PostgreSQL SQLSTATE 42P02: Undefined parameter (undefined_parameter), source-backed diagnosis and recovery guidance. - [42P03 — Duplicate cursor](/42p03/): PostgreSQL SQLSTATE 42P03: Duplicate cursor (duplicate_cursor), source-backed diagnosis and recovery guidance. - [42P04 — Duplicate database](/42p04/): PostgreSQL SQLSTATE 42P04: Duplicate database (duplicate_database), source-backed diagnosis and recovery guidance. - [42P05 — Duplicate prepared statement](/42p05/): PostgreSQL SQLSTATE 42P05: Duplicate prepared statement (duplicate_prepared_statement), source-backed diagnosis and recovery guidance. - [42P06 — Duplicate schema](/42p06/): PostgreSQL SQLSTATE 42P06: Duplicate schema (duplicate_schema), source-backed diagnosis and recovery guidance. - [42P07 — Duplicate table or relation definition](/42p07/): PostgreSQL SQLSTATE 42P07: Duplicate table or relation definition (duplicate_table), source-backed diagnosis and recovery guidance. - [42P08 — Ambiguous parameter type](/42p08/): PostgreSQL SQLSTATE 42P08: Ambiguous parameter type (ambiguous_parameter), source-backed diagnosis and recovery guidance. - [42P09 — Ambiguous table alias](/42p09/): PostgreSQL SQLSTATE 42P09: Ambiguous table alias (ambiguous_alias), source-backed diagnosis and recovery guidance. - [42P10 — Invalid column reference](/42p10/): Source-backed reference for PostgreSQL SQLSTATE 42P10. - [42P11 — Invalid cursor definition](/42p11/): Source-backed reference for PostgreSQL SQLSTATE 42P11. - [42P12 — Invalid database definition](/42p12/): Source-backed reference for PostgreSQL SQLSTATE 42P12. - [42P13 — Invalid function definition](/42p13/): Source-backed reference for PostgreSQL SQLSTATE 42P13. - [42P14 — Invalid prepared statement definition](/42p14/): Source-backed reference for PostgreSQL SQLSTATE 42P14. - [42P15 — Invalid schema definition](/42p15/): Source-backed reference for PostgreSQL SQLSTATE 42P15. - [42P16 — Invalid table definition](/42p16/): Source-backed reference for PostgreSQL SQLSTATE 42P16. - [42P17 — Invalid object definition](/42p17/): Source-backed reference for PostgreSQL SQLSTATE 42P17. - [42P18 — Indeterminate datatype](/42p18/): Source-backed reference for PostgreSQL SQLSTATE 42P18. - [42P19 — Invalid recursion](/42p19/): Source-backed reference for PostgreSQL SQLSTATE 42P19. - [42P20 — Windowing error](/42p20/): Source-backed reference for PostgreSQL SQLSTATE 42P20. - [42P21 — Collation mismatch](/42p21/): Source-backed reference for PostgreSQL SQLSTATE 42P21. - [42P22 — Indeterminate collation](/42p22/): Source-backed reference for PostgreSQL SQLSTATE 42P22. - [44000 — with_check_option_violation](/44000/): PostgreSQL SQLSTATE 44000: view WITH CHECK OPTION diagnostics and repair. - [53000 — insufficient_resources](/53000/): Source-backed reference for PostgreSQL SQLSTATE 53000. - [53100 — disk_full](/53100/): Source-backed reference for PostgreSQL SQLSTATE 53100. - [53200 — out_of_memory](/53200/): Source-backed reference for PostgreSQL SQLSTATE 53200. - [53300 — too_many_connections](/53300/): PostgreSQL reports SQLSTATE 53300 when a connection cannot be admitted because a connection limit is exhausted. Identify the role, database, or server limit and verify a fresh connection after capacity is restored. - [53400 — configuration_limit_exceeded](/53400/): Source-backed reference for PostgreSQL SQLSTATE 53400. - [54000 — program_limit_exceeded](/54000/): Source-backed reference for PostgreSQL SQLSTATE 54000. - [54001 — statement_too_complex](/54001/): Source-backed reference for PostgreSQL SQLSTATE 54001. - [54011 — too_many_columns](/54011/): Source-backed reference for PostgreSQL SQLSTATE 54011. - [54023 — too_many_arguments](/54023/): Source-backed reference for PostgreSQL SQLSTATE 54023. - [55000 — Object not in prerequisite state](/55000/): PostgreSQL SQLSTATE 55000: Object not in prerequisite state (object_not_in_prerequisite_state), source-backed diagnosis and recovery guidance. - [55006 — Object in use](/55006/): PostgreSQL SQLSTATE 55006: Object in use (object_in_use), source-backed diagnosis and recovery guidance. - [55P02 — cant_change_runtime_param](/55p02/): Source-backed reference for PostgreSQL SQLSTATE 55P02. - [55P03 — lock_not_available](/55p03/): Source-backed full entry for PostgreSQL SQLSTATE 55P03. - [55P04 — unsafe_new_enum_value_usage](/55p04/): Source-backed reference for PostgreSQL SQLSTATE 55P04. - [57000 — operator_intervention](/57000/): Source-backed reference entry for PostgreSQL SQLSTATE 57000. - [57014 — query_canceled](/57014/): PostgreSQL reports SQLSTATE 57014 when a running statement is canceled, including by statement_timeout. Classify the cancel source, verify transaction state, and confirm that a follow-up operation is safe. - [57P01 — admin_shutdown](/57p01/): Source-backed full entry for PostgreSQL SQLSTATE 57P01. - [57P02 — crash_shutdown](/57p02/): Source-backed reference entry for PostgreSQL SQLSTATE 57P02. - [57P03 — cannot_connect_now](/57p03/): Source-backed full entry for PostgreSQL SQLSTATE 57P03. - [57P04 — database_dropped](/57p04/): Source-backed reference entry for PostgreSQL SQLSTATE 57P04. - [57P05 — idle_session_timeout](/57p05/): Source-backed full entry for PostgreSQL SQLSTATE 57P05. - [58000 — system_error](/58000/): Source-backed reference entry for PostgreSQL SQLSTATE 58000. - [58030 — io_error](/58030/): Source-backed full reference for PostgreSQL SQLSTATE 58030. - [58P01 — undefined_file](/58p01/): Source-backed full reference for PostgreSQL SQLSTATE 58P01. - [58P02 — duplicate_file](/58p02/): Source-backed reference for PostgreSQL SQLSTATE 58P02. - [58P03 — file_name_too_long](/58p03/): Source-backed full reference for PostgreSQL SQLSTATE 58P03. - [72000 — snapshot_too_old](/72000/): Source-backed historical reference for PostgreSQL SQLSTATE 72000. - [Class 00 — Successful Completion](/classes/00/): Members and evidence boundaries for PostgreSQL SQLSTATE class 00. - [Class 01 — Warning](/classes/01/): Members and evidence boundaries for PostgreSQL SQLSTATE class 01. - [Class 02 — No Data (this is also a warning class per the SQL standard)](/classes/02/): Members and evidence boundaries for PostgreSQL SQLSTATE class 02. - [Class 03 — SQL Statement Not Yet Complete](/classes/03/): Members and evidence boundaries for PostgreSQL SQLSTATE class 03. - [Class 08 — Connection Exception](/classes/08/): Members and evidence boundaries for PostgreSQL SQLSTATE class 08. - [Class 09 — Triggered Action Exception](/classes/09/): Members and evidence boundaries for PostgreSQL SQLSTATE class 09. - [Class 0A — Feature Not Supported](/classes/0a/): Members and evidence boundaries for PostgreSQL SQLSTATE class 0A. - [Class 0B — Invalid Transaction Initiation](/classes/0b/): Members and evidence boundaries for PostgreSQL SQLSTATE class 0B. - [Class 0F — Locator Exception](/classes/0f/): Members and evidence boundaries for PostgreSQL SQLSTATE class 0F. - [Class 0L — Invalid Grantor](/classes/0l/): Members and evidence boundaries for PostgreSQL SQLSTATE class 0L. - [Class 0P — Invalid Role Specification](/classes/0p/): Members and evidence boundaries for PostgreSQL SQLSTATE class 0P. - [Class 0Z — Diagnostics Exception](/classes/0z/): Members and evidence boundaries for PostgreSQL SQLSTATE class 0Z. - [Class 10 — XQuery Error](/classes/10/): Members and evidence boundaries for PostgreSQL SQLSTATE class 10. - [Class 20 — Case Not Found](/classes/20/): Members and evidence boundaries for PostgreSQL SQLSTATE class 20. - [Class 21 — Cardinality Violation](/classes/21/): Members and evidence boundaries for PostgreSQL SQLSTATE class 21. - [Class 22 — Data Exception](/classes/22/): Members and evidence boundaries for PostgreSQL SQLSTATE class 22. - [Class 23 — Integrity Constraint Violation](/classes/23/): Members and evidence boundaries for PostgreSQL SQLSTATE class 23. - [Class 24 — Invalid Cursor State](/classes/24/): Members and evidence boundaries for PostgreSQL SQLSTATE class 24. - [Class 25 — Invalid Transaction State](/classes/25/): Members and evidence boundaries for PostgreSQL SQLSTATE class 25. - [Class 26 — Invalid SQL Statement Name](/classes/26/): Members and evidence boundaries for PostgreSQL SQLSTATE class 26. - [Class 27 — Triggered Data Change Violation](/classes/27/): Members and evidence boundaries for PostgreSQL SQLSTATE class 27. - [Class 28 — Invalid Authorization Specification](/classes/28/): Members and evidence boundaries for PostgreSQL SQLSTATE class 28. - [Class 2B — Dependent Privilege Descriptors Still Exist](/classes/2b/): Members and evidence boundaries for PostgreSQL SQLSTATE class 2B. - [Class 2D — Invalid Transaction Termination](/classes/2d/): Members and evidence boundaries for PostgreSQL SQLSTATE class 2D. - [Class 2F — SQL Routine Exception](/classes/2f/): Members and evidence boundaries for PostgreSQL SQLSTATE class 2F. - [Class 34 — Invalid Cursor Name](/classes/34/): Members and evidence boundaries for PostgreSQL SQLSTATE class 34. - [Class 38 — External Routine Exception](/classes/38/): Members and evidence boundaries for PostgreSQL SQLSTATE class 38. - [Class 39 — External Routine Invocation Exception](/classes/39/): Members and evidence boundaries for PostgreSQL SQLSTATE class 39. - [Class 3B — Savepoint Exception](/classes/3b/): Members and evidence boundaries for PostgreSQL SQLSTATE class 3B. - [Class 3D — Invalid Catalog Name](/classes/3d/): Members and evidence boundaries for PostgreSQL SQLSTATE class 3D. - [Class 3F — Invalid Schema Name](/classes/3f/): Members and evidence boundaries for PostgreSQL SQLSTATE class 3F. - [Class 40 — Transaction Rollback](/classes/40/): Members and evidence boundaries for PostgreSQL SQLSTATE class 40. - [Class 42 — Syntax Error or Access Rule Violation](/classes/42/): Members and evidence boundaries for PostgreSQL SQLSTATE class 42. - [Class 44 — WITH CHECK OPTION Violation](/classes/44/): Members and evidence boundaries for PostgreSQL SQLSTATE class 44. - [Class 53 — Insufficient Resources](/classes/53/): Members and evidence boundaries for PostgreSQL SQLSTATE class 53. - [Class 54 — Program Limit Exceeded](/classes/54/): Members and evidence boundaries for PostgreSQL SQLSTATE class 54. - [Class 55 — Object Not In Prerequisite State](/classes/55/): Members and evidence boundaries for PostgreSQL SQLSTATE class 55. - [Class 57 — Operator Intervention](/classes/57/): Members and evidence boundaries for PostgreSQL SQLSTATE class 57. - [Class 58 — System Error (errors external to PostgreSQL itself)](/classes/58/): Members and evidence boundaries for PostgreSQL SQLSTATE class 58. - [Class 72 — Snapshot Failure](/classes/72/): Members and evidence boundaries for PostgreSQL SQLSTATE class 72. - [Class F0 — Configuration File Error](/classes/f0/): Members and evidence boundaries for PostgreSQL SQLSTATE class F0. - [Class HV — Foreign Data Wrapper Error (SQL/MED)](/classes/hv/): Members and evidence boundaries for PostgreSQL SQLSTATE class HV. - [Class P0 — PL/pgSQL Error](/classes/p0/): Members and evidence boundaries for PostgreSQL SQLSTATE class P0. - [Class XX — Internal Error](/classes/xx/): Members and evidence boundaries for PostgreSQL SQLSTATE class XX. - [F0000 — config_file_error](/f0000/): Source-backed full reference for PostgreSQL SQLSTATE F0000. - [F0001 — lock_file_exists](/f0001/): Source-backed full reference for PostgreSQL SQLSTATE F0001. - [HV000 — fdw_error](/hv000/): PostgreSQL SQLSTATE HV000 is the SQL/MED foreign-data-wrapper error condition. Identify the wrapper callback and any remote diagnostic before deciding how to recover. - [HV001 — fdw_out_of_memory](/hv001/): PostgreSQL SQLSTATE HV001 reports an FDW-side allocation failure. PostgreSQL's bundled dblink and postgres_fdw paths use it while obtaining libpq connection options. - [HV002 — fdw_dynamic_parameter_value_needed](/hv002/): PostgreSQL SQLSTATE HV002 reports a required FDW parameter that is unavailable. file_fdw raises it when a foreign table has neither filename nor program. - [HV004 — fdw_invalid_data_type](/hv004/): PostgreSQL SQLSTATE HV004 denotes a foreign-data-wrapper data type mismatch. Confirm the wrapper's type mapping and the local foreign-table definition. - [HV005 — fdw_column_name_not_found](/hv005/): PostgreSQL SQLSTATE HV005 denotes a foreign column name that the FDW cannot find. Check the wrapper's remote descriptor and name mapping. - [HV006 — fdw_invalid_data_type_descriptors](/hv006/): PostgreSQL SQLSTATE HV006 denotes inconsistent or unusable FDW data-type descriptors. Inspect the wrapper metadata contract before changing SQL. - [HV007 — fdw_invalid_column_name](/hv007/): PostgreSQL SQLSTATE HV007 denotes an invalid column name passed through an FDW descriptor or callback. Check wrapper naming rules and quoting. - [HV008 — fdw_invalid_column_number](/hv008/): PostgreSQL SQLSTATE HV008 denotes an invalid foreign-column ordinal. Inspect the wrapper descriptor and local-to-remote column mapping. - [HV009 — fdw_invalid_use_of_null_pointer](/hv009/): PostgreSQL SQLSTATE HV009 denotes an FDW null-pointer contract violation. Identify the wrapper callback and preserve the failure context. - [HV00A — fdw_invalid_string_format](/hv00a/): PostgreSQL SQLSTATE HV00A denotes a string format that an FDW cannot accept. Confirm the wrapper's format grammar and the operation phase. - [HV00B — fdw_invalid_handle](/hv00b/): PostgreSQL SQLSTATE HV00B identifies an invalid handle at an FDW or SQL/MED boundary. The actual handle owner and lifecycle must come from the installed wrapper. - [HV00C — fdw_invalid_option_index](/hv00c/): PostgreSQL SQLSTATE HV00C identifies an invalid FDW option index. Confirm the wrapper's option array and index contract before changing server options. - [HV00D — fdw_invalid_option_name](/hv00d/): PostgreSQL SQLSTATE HV00D reports an option name that the FDW implementation does not accept. file_fdw and postgres_fdw provide concrete validation messages and hints. - [HV00J — fdw_option_name_not_found](/hv00j/): PostgreSQL SQLSTATE HV00J is dblink's option-name-not-found condition. It is separate from FDW option validation in postgres_fdw and file_fdw. - [HV00K — fdw_reply_handle](/hv00k/): PostgreSQL SQLSTATE HV00K identifies an FDW reply-handle condition. The reply lifecycle and operation phase must be read from the installed wrapper. - [HV00L — fdw_unable_to_create_execution](/hv00l/): PostgreSQL SQLSTATE HV00L identifies an FDW failure to create an execution object. Inspect the wrapper's remote execution setup and resource contract. - [HV00M — fdw_unable_to_create_reply](/hv00m/): PostgreSQL SQLSTATE HV00M identifies an FDW failure to create a reply object. Diagnose the wrapper's result-channel setup separately from execution creation. - [HV00N — fdw_unable_to_establish_connection](/hv00n/): PostgreSQL SQLSTATE HV00N identifies an FDW connection-establishment failure. The actual connection layer and diagnostic must come from the wrapper. - [HV00P — fdw_no_schemas](/hv00p/): PostgreSQL SQLSTATE HV00P reports that an FDW does not support IMPORT FOREIGN SCHEMA. The core command checks the wrapper callback directly. - [HV00Q — fdw_schema_not_found](/hv00q/): PostgreSQL SQLSTATE HV00Q reports that postgres_fdw cannot find the requested remote schema during IMPORT FOREIGN SCHEMA. - [HV00R — fdw_table_not_found](/hv00r/): PostgreSQL SQLSTATE HV00R names a table-not-found condition at an FDW boundary; the installed wrapper determines which table lookup and diagnostic are involved. - [HV010 — fdw_function_sequence_error](/hv010/): PostgreSQL SQLSTATE HV010 names an FDW function-sequence condition; the wrapper and callback phase must be identified from the actual implementation. - [HV014 — fdw_too_many_handles](/hv014/): PostgreSQL SQLSTATE HV014 names an FDW handle-limit condition; the resource owner and limit come from the installed wrapper. - [HV021 — fdw_inconsistent_descriptor_information](/hv021/): PostgreSQL SQLSTATE HV021 names an FDW descriptor-consistency condition; the descriptor and producer must be identified from the wrapper implementation. - [HV024 — fdw_invalid_attribute_value](/hv024/): PostgreSQL SQLSTATE HV024 names an invalid FDW attribute value; the relevant attribute and validator are implementation-specific. - [HV090 — fdw_invalid_string_length_or_buffer_length](/hv090/): PostgreSQL SQLSTATE HV090 names an FDW string or buffer length condition; the buffer owner and valid bounds come from the actual wrapper or driver. - [HV091 — fdw_invalid_descriptor_field_identifier](/hv091/): PostgreSQL SQLSTATE HV091 names an invalid FDW descriptor field identifier; the descriptor API and field namespace must come from the implementation. - [P0000 — plpgsql_error](/p0000/): Source-backed reference for PostgreSQL SQLSTATE P0000. - [P0001 — raise_exception](/p0001/): PostgreSQL uses SQLSTATE P0001 for a PL/pgSQL RAISE EXCEPTION with no explicit condition or SQLSTATE. Diagnose the application control flow and recover at the correct transaction boundary. - [P0002 — no_data_found](/p0002/): Source-backed reference for PostgreSQL SQLSTATE P0002. - [P0003 — too_many_rows](/p0003/): Source-backed reference for PostgreSQL SQLSTATE P0003. - [P0004 — assert_failure](/p0004/): Source-backed reference for PostgreSQL SQLSTATE P0004. - [PostgreSQL 10.23 — formal](/versions/10/): SQLSTATE definition snapshot and evidence members for PostgreSQL 10.23. - [PostgreSQL 11.22 — formal](/versions/11/): SQLSTATE definition snapshot and evidence members for PostgreSQL 11.22. - [PostgreSQL 12.22 — formal](/versions/12/): SQLSTATE definition snapshot and evidence members for PostgreSQL 12.22. - [PostgreSQL 13.23 — formal](/versions/13/): SQLSTATE definition snapshot and evidence members for PostgreSQL 13.23. - [PostgreSQL 14.24 — formal](/versions/14/): SQLSTATE definition snapshot and evidence members for PostgreSQL 14.24. - [PostgreSQL 15.19 — formal](/versions/15/): SQLSTATE definition snapshot and evidence members for PostgreSQL 15.19. - [PostgreSQL 16.15 — formal](/versions/16/): SQLSTATE definition snapshot and evidence members for PostgreSQL 16.15. - [PostgreSQL 17.11 — formal](/versions/17/): SQLSTATE definition snapshot and evidence members for PostgreSQL 17.11. - [PostgreSQL 18.6 — formal](/versions/18/): SQLSTATE definition snapshot and evidence members for PostgreSQL 18.6. - [PostgreSQL 19beta3 — preview](/versions/19/): SQLSTATE definition snapshot and evidence members for PostgreSQL 19beta3. - [PostgreSQL 9.0.23 — formal](/versions/9.0/): SQLSTATE definition snapshot and evidence members for PostgreSQL 9.0.23. - [PostgreSQL 9.1.24 — formal](/versions/9.1/): SQLSTATE definition snapshot and evidence members for PostgreSQL 9.1.24. - [PostgreSQL 9.2.24 — formal](/versions/9.2/): SQLSTATE definition snapshot and evidence members for PostgreSQL 9.2.24. - [PostgreSQL 9.3.25 — formal](/versions/9.3/): SQLSTATE definition snapshot and evidence members for PostgreSQL 9.3.25. - [PostgreSQL 9.4.26 — formal](/versions/9.4/): SQLSTATE definition snapshot and evidence members for PostgreSQL 9.4.26. - [PostgreSQL 9.5.25 — formal](/versions/9.5/): SQLSTATE definition snapshot and evidence members for PostgreSQL 9.5.25. - [PostgreSQL 9.6.24 — formal](/versions/9.6/): SQLSTATE definition snapshot and evidence members for PostgreSQL 9.6.24. - [XX000 — internal_error](/xx000/): PostgreSQL uses SQLSTATE XX000 for internal-error paths and as the default code for an ERROR without an explicit code. Preserve the full diagnostic and investigate the exact subsystem; XX000 alone does not prove corruption. - [XX001 — data_corrupted](/xx001/): Source-backed full reference for PostgreSQL SQLSTATE XX001. - [XX002 — index_corrupted](/xx002/): Source-backed full reference for PostgreSQL SQLSTATE XX002.