PostgreSQL error codes
Search by code or error message to find official explanations and troubleshooting or diagnostic links.
Search runs in your browser. The same number can have different meanings in different products.
PostgreSQL Code
261 results- 22024unterminated_c_stringunterminated c string
unterminated_c_string (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22025invalid_escape_sequenceinvalid escape sequence
invalid_escape_sequence (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22026string_data_length_mismatchstring data length mismatch
string_data_length_mismatch (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22027trim_errortrim error
trim_error (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22030duplicate_json_object_key_valueduplicate json object key value
duplicate_json_object_key_value (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22031invalid_argument_for_sql_json_datetime_functioninvalid argument for sql json datetime function
invalid_argument_for_sql_json_datetime_function (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22032invalid_json_textinvalid json text
invalid_json_text (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22033invalid_sql_json_subscriptinvalid sql json subscript
invalid_sql_json_subscript (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22034more_than_one_sql_json_itemmore than one sql json item
more_than_one_sql_json_item (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22035no_sql_json_itemno sql json item
no_sql_json_item (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22036non_numeric_sql_json_itemnon numeric sql json item
non_numeric_sql_json_item (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22037non_unique_keys_in_a_json_objectnon unique keys in a json object
non_unique_keys_in_a_json_object (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22038singleton_sql_json_item_requiredsingleton sql json item required
singleton_sql_json_item_required (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22039sql_json_array_not_foundsql json array not found
sql_json_array_not_found (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 23000integrity_constraint_violationintegrity constraint violation
integrity_constraint_violation (Class 23 — Integrity Constraint Violation)
PostgreSQLPostgreSQL - 23001restrict_violationrestrict violation
restrict_violation (Class 23 — Integrity Constraint Violation)
PostgreSQLPostgreSQL - 23502not_null_violationnot null violation
not_null_violation (Class 23 — Integrity Constraint Violation)
PostgreSQLPostgreSQL - 23503foreign_key_violationforeign key violation
foreign_key_violation (Class 23 — Integrity Constraint Violation)
PostgreSQLPostgreSQL - 23505unique_violationunique violation
unique_violation (Class 23 — Integrity Constraint Violation)
PostgreSQLPostgreSQL - 23514check_violationcheck violation
check_violation (Class 23 — Integrity Constraint Violation)
PostgreSQLPostgreSQL - 24000invalid_cursor_stateinvalid cursor state
invalid_cursor_state (Class 24 — Invalid Cursor State)
PostgreSQLPostgreSQL - 25000invalid_transaction_stateinvalid transaction state
invalid_transaction_state (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 25001active_sql_transactionactive sql transaction
active_sql_transaction (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 25002branch_transaction_already_activebranch transaction already active
branch_transaction_already_active (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 25003inappropriate_access_mode_for_branch_transactioninappropriate access mode for branch transaction
inappropriate_access_mode_for_branch_transaction (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 25004inappropriate_isolation_level_for_branch_transactioninappropriate isolation level for branch transaction
inappropriate_isolation_level_for_branch_transaction (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 25005no_active_sql_transaction_for_branch_transactionno active sql transaction for branch transaction
no_active_sql_transaction_for_branch_transaction (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 25006read_only_sql_transactionread only sql transaction
read_only_sql_transaction (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 25007schema_and_data_statement_mixing_not_supportedschema and data statement mixing not supported
schema_and_data_statement_mixing_not_supported (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 25008held_cursor_requires_same_isolation_levelheld cursor requires same isolation level
held_cursor_requires_same_isolation_level (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 26000invalid_sql_statement_nameinvalid sql statement name
invalid_sql_statement_name (Class 26 — Invalid SQL Statement Name)
PostgreSQLPostgreSQL - 27000triggered_data_change_violationtriggered data change violation
triggered_data_change_violation (Class 27 — Triggered Data Change Violation)
PostgreSQLPostgreSQL - 28000invalid_authorization_specificationinvalid authorization specification
invalid_authorization_specification (Class 28 — Invalid Authorization Specification)
PostgreSQLPostgreSQL - 34000invalid_cursor_nameinvalid cursor name
invalid_cursor_name (Class 34 — Invalid Cursor Name)
PostgreSQLPostgreSQL - 38000external_routine_exceptionexternal routine exception
external_routine_exception (Class 38 — External Routine Exception)
PostgreSQLPostgreSQL - 38001containing_sql_not_permittedcontaining sql not permitted
containing_sql_not_permitted (Class 38 — External Routine Exception)
PostgreSQLPostgreSQL - 38002modifying_sql_data_not_permittedmodifying sql data not permitted
modifying_sql_data_not_permitted (Class 38 — External Routine Exception)
PostgreSQLPostgreSQL - 38003prohibited_sql_statement_attemptedprohibited sql statement attempted
prohibited_sql_statement_attempted (Class 38 — External Routine Exception)
PostgreSQLPostgreSQL - 38004reading_sql_data_not_permittedreading sql data not permitted
reading_sql_data_not_permitted (Class 38 — External Routine Exception)
PostgreSQLPostgreSQL - 39000external_routine_invocation_exceptionexternal routine invocation exception
external_routine_invocation_exception (Class 39 — External Routine Invocation Exception)
PostgreSQLPostgreSQL