Error Code PortalPostgreSQL 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- 39001invalid_sqlstate_returnedinvalid sqlstate returned
invalid_sqlstate_returned (Class 39 — External Routine Invocation Exception)
PostgreSQLPostgreSQL - 39004null_value_not_allowednull value not allowed
null_value_not_allowed (Class 39 — External Routine Invocation Exception)
PostgreSQLPostgreSQL - 40000transaction_rollbacktransaction rollback
transaction_rollback (Class 40 — Transaction Rollback)
PostgreSQLPostgreSQL - 40001serialization_failureserialization failure
serialization_failure (Class 40 — Transaction Rollback)
PostgreSQLPostgreSQL - 40002transaction_integrity_constraint_violationtransaction integrity constraint violation
transaction_integrity_constraint_violation (Class 40 — Transaction Rollback)
PostgreSQLPostgreSQL - 40003statement_completion_unknownstatement completion unknown
statement_completion_unknown (Class 40 — Transaction Rollback)
PostgreSQLPostgreSQL - 42000syntax_error_or_access_rule_violationsyntax error or access rule violation
syntax_error_or_access_rule_violation (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42501insufficient_privilegeinsufficient privilege
insufficient_privilege (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42601syntax_errorsyntax error
syntax_error (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42602invalid_nameinvalid name
invalid_name (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42611invalid_column_definitioninvalid column definition
invalid_column_definition (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42622name_too_longname too long
name_too_long (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42701duplicate_columnduplicate column
duplicate_column (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42702ambiguous_columnambiguous column
ambiguous_column (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42703undefined_columnundefined column
undefined_column (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42704undefined_objectundefined object
undefined_object (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42710duplicate_objectduplicate object
duplicate_object (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42712duplicate_aliasduplicate alias
duplicate_alias (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42723duplicate_functionduplicate function
duplicate_function (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42725ambiguous_functionambiguous function
ambiguous_function (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42803grouping_errorgrouping error
grouping_error (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42804datatype_mismatchdatatype mismatch
datatype_mismatch (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42809wrong_object_typewrong object type
wrong_object_type (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42830invalid_foreign_keyinvalid foreign key
invalid_foreign_key (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42846cannot_coercecannot coerce
cannot_coerce (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42883undefined_functionundefined function
undefined_function (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 42939reserved_namereserved name
reserved_name (Class 42 — Syntax Error or Access Rule Violation)
PostgreSQLPostgreSQL - 44000with_check_option_violationwith check option violation
with_check_option_violation (Class 44 — WITH CHECK OPTION Violation)
PostgreSQLPostgreSQL - 53000insufficient_resourcesinsufficient resources
insufficient_resources (Class 53 — Insufficient Resources)
PostgreSQLPostgreSQL - 53100disk_fulldisk full
disk_full (Class 53 — Insufficient Resources)
PostgreSQLPostgreSQL - 53200out_of_memoryout of memory
out_of_memory (Class 53 — Insufficient Resources)
PostgreSQLPostgreSQL - 53300too_many_connectionstoo many connections
too_many_connections (Class 53 — Insufficient Resources)
PostgreSQLPostgreSQL - 53400configuration_limit_exceededconfiguration limit exceeded
configuration_limit_exceeded (Class 53 — Insufficient Resources)
PostgreSQLPostgreSQL - 54000program_limit_exceededprogram limit exceeded
program_limit_exceeded (Class 54 — Program Limit Exceeded)
PostgreSQLPostgreSQL - 54001statement_too_complexstatement too complex
statement_too_complex (Class 54 — Program Limit Exceeded)
PostgreSQLPostgreSQL - 54011too_many_columnstoo many columns
too_many_columns (Class 54 — Program Limit Exceeded)
PostgreSQLPostgreSQL - 54023too_many_argumentstoo many arguments
too_many_arguments (Class 54 — Program Limit Exceeded)
PostgreSQLPostgreSQL - 55000object_not_in_prerequisite_stateobject not in prerequisite state
object_not_in_prerequisite_state (Class 55 — Object Not In Prerequisite State)
PostgreSQLPostgreSQL - 55006object_in_useobject in use
object_in_use (Class 55 — Object Not In Prerequisite State)
PostgreSQLPostgreSQL - 57000operator_interventionoperator intervention
operator_intervention (Class 57 — Operator Intervention)
PostgreSQLPostgreSQL