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- 2203Fsql_json_scalar_requiredsql json scalar required
sql_json_scalar_required (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 2203Gsql_json_item_cannot_be_cast_to_target_typesql json item cannot be cast to target type
sql_json_item_cannot_be_cast_to_target_type (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22P01floating_point_exceptionfloating point exception
floating_point_exception (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22P02invalid_text_representationinvalid text representation
invalid_text_representation (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22P03invalid_binary_representationinvalid binary representation
invalid_binary_representation (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22P04bad_copy_file_formatbad copy file format
bad_copy_file_format (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22P05untranslatable_characteruntranslatable character
untranslatable_character (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 22P06nonstandard_use_of_escape_characternonstandard use of escape character
nonstandard_use_of_escape_character (Class 22 — Data Exception)
PostgreSQLPostgreSQL - 23P01exclusion_violationexclusion violation
exclusion_violation (Class 23 — Integrity Constraint Violation)
PostgreSQLPostgreSQL - 25P01no_active_sql_transactionno active sql transaction
no_active_sql_transaction (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 25P02in_failed_sql_transactionin failed sql transaction
in_failed_sql_transaction (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 25P03idle_in_transaction_session_timeoutidle in transaction session timeout
idle_in_transaction_session_timeout (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 25P04transaction_timeouttransaction timeout
transaction_timeout (Class 25 — Invalid Transaction State)
PostgreSQLPostgreSQL - 28P01invalid_passwordinvalid password
invalid_password (Class 28 — Invalid Authorization Specification)
PostgreSQLPostgreSQL - 2B000dependent_privilege_descriptors_still_existdependent privilege descriptors still exist
dependent_privilege_descriptors_still_exist (Class 2B — Dependent Privilege Descriptors Still Exist)
PostgreSQLPostgreSQL - 2BP01dependent_objects_still_existdependent objects still exist
dependent_objects_still_exist (Class 2B — Dependent Privilege Descriptors Still Exist)
PostgreSQLPostgreSQL - 2D000invalid_transaction_terminationinvalid transaction termination
invalid_transaction_termination (Class 2D — Invalid Transaction Termination)
PostgreSQLPostgreSQL - 2F000sql_routine_exceptionsql routine exception
sql_routine_exception (Class 2F — SQL Routine Exception)
PostgreSQLPostgreSQL - 2F002modifying_sql_data_not_permittedmodifying sql data not permitted
modifying_sql_data_not_permitted (Class 2F — SQL Routine Exception)
PostgreSQLPostgreSQL - 2F003prohibited_sql_statement_attemptedprohibited sql statement attempted
prohibited_sql_statement_attempted (Class 2F — SQL Routine Exception)
PostgreSQLPostgreSQL - 2F004reading_sql_data_not_permittedreading sql data not permitted
reading_sql_data_not_permitted (Class 2F — SQL Routine Exception)
PostgreSQLPostgreSQL - 2F005function_executed_no_return_statementfunction executed no return statement
function_executed_no_return_statement (Class 2F — SQL Routine Exception)
PostgreSQLPostgreSQL - 39P01trigger_protocol_violatedtrigger protocol violated
trigger_protocol_violated (Class 39 — External Routine Invocation Exception)
PostgreSQLPostgreSQL - 39P02srf_protocol_violatedsrf protocol violated
srf_protocol_violated (Class 39 — External Routine Invocation Exception)
PostgreSQLPostgreSQL - 39P03event_trigger_protocol_violatedevent trigger protocol violated
event_trigger_protocol_violated (Class 39 — External Routine Invocation Exception)
PostgreSQLPostgreSQL - 3B000savepoint_exceptionsavepoint exception
savepoint_exception (Class 3B — Savepoint Exception)
PostgreSQLPostgreSQL - 3B001invalid_savepoint_specificationinvalid savepoint specification
invalid_savepoint_specification (Class 3B — Savepoint Exception)
PostgreSQLPostgreSQL - 3D000invalid_catalog_nameinvalid catalog name
invalid_catalog_name (Class 3D — Invalid Catalog Name)
PostgreSQLPostgreSQL - 3F000invalid_schema_nameinvalid schema name
invalid_schema_name (Class 3F — Invalid Schema Name)
PostgreSQLPostgreSQL - 40P01deadlock_detecteddeadlock detected
deadlock_detected (Class 40 — Transaction Rollback)
PostgreSQLPostgreSQL - 428C9generated_alwaysgenerated always
generated_always (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42P01undefined_tableundefined table
undefined_table (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42P02undefined_parameterundefined parameter
undefined_parameter (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42P03duplicate_cursorduplicate cursor
duplicate_cursor (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42P04duplicate_databaseduplicate database
duplicate_database (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42P05duplicate_prepared_statementduplicate prepared statement
duplicate_prepared_statement (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42P06duplicate_schemaduplicate schema
duplicate_schema (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42P07duplicate_tableduplicate table
duplicate_table (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42P08ambiguous_parameterambiguous parameter
ambiguous_parameter (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42P09ambiguous_aliasambiguous alias
ambiguous_alias (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL