error codes list of All messages emitted by the PostgreSQL server are assigned five-character error codes that follow the SQL standard's conventions for SQLSTATE codes. Applications that need to know which error condition has occurred should usually test the error code, rather than looking at the textual error message. The error codes are less likely to change across PostgreSQL releases, and also are not subject to change due to localization of error messages. Note that some, but not all, of the error codes produced by PostgreSQL are defined by the SQL standard; some additional error codes for conditions not defined by the standard have been invented or borrowed from other databases. According to the standard, the first two characters of an error code denote a class of errors, while the last three characters indicate a specific condition within that class. Thus, an application that does not recognize the specific error code may still be able to infer what to do from the error class. lists all the error codes defined in PostgreSQL &version;. (Some are not actually used at present, but are defined by the SQL standard.) The error classes are also shown. For each error class there is a standard error code having the last three characters 000. This code is used only for error conditions that fall within the class but do not have any more-specific code assigned. The PL/pgSQL condition name for each error code is the same as the phrase shown in the table, with underscores substituted for spaces. For example, code 22012, DIVISION BY ZERO, has condition name DIVISION_BY_ZERO. Condition names can be written in either upper or lower case. (Note that PL/pgSQL does not recognize warning, as opposed to error, condition names; those are classes 00, 01, and 02.) Error Code Meaning Class 00 Successful Completion   0 SUCCESSFUL COMPLETION successful_completion Class 01 Warning   1000 WARNING warning 0100C DYNAMIC RESULT SETS RETURNED dynamic_result_sets_returned 1008 IMPLICIT ZERO BIT PADDING implicit_zero_bit_padding 1003 NULL VALUE ELIMINATED IN SET FUNCTION null_value_eliminated_in_set_function 1007 PRIVILEGE NOT GRANTED privilege_not_granted 1006 PRIVILEGE NOT REVOKED privilege_not_revoked 1004 STRING DATA RIGHT TRUNCATION string_data_right_truncation 01P01 DEPRECATED FEATURE deprecated_feature Class 02 No Data — this is also a warning class per the SQL standard   2000 NO DATA no_data 2001 NO ADDITIONAL DYNAMIC RESULT SETS RETURNED no_additional_dynamic_result_sets_returned Class 03 SQL Statement Not Yet Complete   3000 SQL STATEMENT NOT YET COMPLETE sql_statement_not_yet_complete Class 08 Connection Exception   8000 CONNECTION EXCEPTION connection_exception 8003 CONNECTION DOES NOT EXIST connection_does_not_exist 8006 CONNECTION FAILURE connection_failure 8001 SQLCLIENT UNABLE TO ESTABLISH SQLCONNECTION sqlclient_unable_to_establish_sqlconnection 8004 SQLSERVER REJECTED ESTABLISHMENT OF SQLCONNECTION sqlserver_rejected_establishment_of_sqlconnection 8007 TRANSACTION RESOLUTION UNKNOWN transaction_resolution_unknown 08P01 PROTOCOL VIOLATION protocol_violation Class 09 Triggered Action Exception   9000 TRIGGERED ACTION EXCEPTION triggered_action_exception Class 0A Feature Not Supported   0A000 FEATURE NOT SUPPORTED feature_not_supported Class 0B Invalid Transaction Initiation   0B000 INVALID TRANSACTION INITIATION invalid_transaction_initiation Class 0F Locator Exception   0F000 LOCATOR EXCEPTION locator_exception 0F001 INVALID LOCATOR SPECIFICATION invalid_locator_specification Class 0L Invalid Grantor   0L000 INVALID GRANTOR invalid_grantor 0LP01 INVALID GRANT OPERATION invalid_grant_operation Class 0P Invalid Role Specification   0P000 INVALID ROLE SPECIFICATION invalid_role_specification Class 21 Cardinality Violation   21000 CARDINALITY VIOLATION cardinality_violation Class 22 Data Exception   22000 DATA EXCEPTION data_exception 2202E ARRAY SUBSCRIPT ERROR array_subscript_error 22021 CHARACTER NOT IN REPERTOIRE character_not_in_repertoire 22008 DATETIME FIELD OVERFLOW datetime_field_overflow 22012 DIVISION BY ZERO division_by_zero 22005 ERROR IN ASSIGNMENT error_in_assignment 2200B ESCAPE CHARACTER CONFLICT escape_character_conflict 22022 INDICATOR OVERFLOW indicator_overflow 22015 INTERVAL FIELD OVERFLOW interval_field_overflow 2201E INVALID ARGUMENT FOR LOGARITHM invalid_argument_for_logarithm 2201F INVALID ARGUMENT FOR POWER FUNCTION invalid_argument_for_power_function 2201G INVALID ARGUMENT FOR WIDTH BUCKET FUNCTION invalid_argument_for_width_bucket_function 22018 INVALID CHARACTER VALUE FOR CAST invalid_character_value_for_cast 22007 INVALID DATETIME FORMAT invalid_datetime_format 22019 INVALID ESCAPE CHARACTER invalid_escape_character 2200D INVALID ESCAPE OCTET invalid_escape_octet 22025 INVALID ESCAPE SEQUENCE invalid_escape_sequence 22P06 NONSTANDARD USE OF ESCAPE CHARACTER nonstandard_use_of_escape_character 22010 INVALID INDICATOR PARAMETER VALUE invalid_indicator_parameter_value 22020 INVALID LIMIT VALUE invalid_limit_value 22023 INVALID PARAMETER VALUE invalid_parameter_value 2201B INVALID REGULAR EXPRESSION invalid_regular_expression 22009 INVALID TIME ZONE DISPLACEMENT VALUE invalid_time_zone_displacement_value 2200C INVALID USE OF ESCAPE CHARACTER invalid_use_of_escape_character 2200G MOST SPECIFIC TYPE MISMATCH most_specific_type_mismatch 22004 NULL VALUE NOT ALLOWED null_value_not_allowed 22002 NULL VALUE NO INDICATOR PARAMETER null_value_no_indicator_parameter 22003 NUMERIC VALUE OUT OF RANGE numeric_value_out_of_range 22026 STRING DATA LENGTH MISMATCH string_data_length_mismatch 22001 STRING DATA RIGHT TRUNCATION string_data_right_truncation 22011 SUBSTRING ERROR substring_error 22027 TRIM ERROR trim_error 22024 UNTERMINATED C STRING unterminated_c_string 2200F ZERO LENGTH CHARACTER STRING zero_length_character_string 22P01 FLOATING POINT EXCEPTION floating_point_exception 22P02 INVALID TEXT REPRESENTATION invalid_text_representation 22P03 INVALID BINARY REPRESENTATION invalid_binary_representation 22P04 BAD COPY FILE FORMAT bad_copy_file_format 22P05 UNTRANSLATABLE CHARACTER untranslatable_character Class 23 Integrity Constraint Violation   23000 INTEGRITY CONSTRAINT VIOLATION integrity_constraint_violation 23001 RESTRICT VIOLATION restrict_violation 23502 NOT NULL VIOLATION not_null_violation 23503 FOREIGN KEY VIOLATION foreign_key_violation 23505 UNIQUE VIOLATION unique_violation 23514 CHECK VIOLATION check_violation Class 24 Invalid Cursor State   24000 INVALID CURSOR STATE invalid_cursor_state Class 25 Invalid Transaction State   25000 INVALID TRANSACTION STATE invalid_transaction_state 25001 ACTIVE SQL TRANSACTION active_sql_transaction 25002 BRANCH TRANSACTION ALREADY ACTIVE branch_transaction_already_active 25008 HELD CURSOR REQUIRES SAME ISOLATION LEVEL held_cursor_requires_same_isolation_level 25003 INAPPROPRIATE ACCESS MODE FOR BRANCH TRANSACTION inappropriate_access_mode_for_branch_transaction 25004 INAPPROPRIATE ISOLATION LEVEL FOR BRANCH TRANSACTION inappropriate_isolation_level_for_branch_transaction 25005 NO ACTIVE SQL TRANSACTION FOR BRANCH TRANSACTION no_active_sql_transaction_for_branch_transaction 25006 READ ONLY SQL TRANSACTION read_only_sql_transaction 25007 SCHEMA AND DATA STATEMENT MIXING NOT SUPPORTED schema_and_data_statement_mixing_not_supported 25P01 NO ACTIVE SQL TRANSACTION no_active_sql_transaction 25P02 IN FAILED SQL TRANSACTION in_failed_sql_transaction Class 26 Invalid SQL Statement Name   26000 INVALID SQL STATEMENT NAME invalid_sql_statement_name Class 27 Triggered Data Change Violation   27000 TRIGGERED DATA CHANGE VIOLATION triggered_data_change_violation Class 28 Invalid Authorization Specification   28000 INVALID AUTHORIZATION SPECIFICATION invalid_authorization_specification Class 2B Dependent Privilege Descriptors Still Exist   2B000 DEPENDENT PRIVILEGE DESCRIPTORS STILL EXIST dependent_privilege_descriptors_still_exist 2BP01 DEPENDENT OBJECTS STILL EXIST dependent_objects_still_exist Class 2D Invalid Transaction Termination   2D000 INVALID TRANSACTION TERMINATION invalid_transaction_termination Class 2F SQL Routine Exception   2F000 SQL ROUTINE EXCEPTION sql_routine_exception 2F005 FUNCTION EXECUTED NO RETURN STATEMENT function_executed_no_return_statement 2F002 MODIFYING SQL DATA NOT PERMITTED modifying_sql_data_not_permitted 2F003 PROHIBITED SQL STATEMENT ATTEMPTED prohibited_sql_statement_attempted 2F004 READING SQL DATA NOT PERMITTED reading_sql_data_not_permitted Class 34 Invalid Cursor Name   34000 INVALID CURSOR NAME invalid_cursor_name Class 38 External Routine Exception   38000 EXTERNAL ROUTINE EXCEPTION external_routine_exception 38001 CONTAINING SQL NOT PERMITTED containing_sql_not_permitted 38002 MODIFYING SQL DATA NOT PERMITTED modifying_sql_data_not_permitted 38003 PROHIBITED SQL STATEMENT ATTEMPTED prohibited_sql_statement_attempted 38004 READING SQL DATA NOT PERMITTED reading_sql_data_not_permitted Class 39 External Routine Invocation Exception   39000 EXTERNAL ROUTINE INVOCATION EXCEPTION external_routine_invocation_exception 39001 INVALID SQLSTATE RETURNED invalid_sqlstate_returned 39004 NULL VALUE NOT ALLOWED null_value_not_allowed 39P01 TRIGGER PROTOCOL VIOLATED trigger_protocol_violated 39P02 SRF PROTOCOL VIOLATED srf_protocol_violated Class 3B Savepoint Exception   3B000 SAVEPOINT EXCEPTION savepoint_exception 3B001 INVALID SAVEPOINT SPECIFICATION invalid_savepoint_specification Class 3D Invalid Catalog Name   3D000 INVALID CATALOG NAME invalid_catalog_name >/row> Class 3F Invalid Schema Name   3F000 INVALID SCHEMA NAME invalid_schema_name Class 40 Transaction Rollback   40000 TRANSACTION ROLLBACK transaction_rollback 40002 TRANSACTION INTEGRITY CONSTRAINT VIOLATION transaction_integrity_constraint_violation 40001 SERIALIZATION FAILURE serialization_failure 40003 STATEMENT COMPLETION UNKNOWN statement_completion_unknown 40P01 DEADLOCK DETECTED deadlock_detected Class 42 Syntax Error or Access Rule Violation   42000 SYNTAX ERROR OR ACCESS RULE VIOLATION syntax_error_or_access_rule_violation 42601 SYNTAX ERROR syntax_error 42501 INSUFFICIENT PRIVILEGE insufficient_privilege 42846 CANNOT COERCE cannot_coerce 42803 GROUPING ERROR grouping_error 42830 INVALID FOREIGN KEY invalid_foreign_key 42602 INVALID NAME invalid_name 42622 NAME TOO LONG name_too_long 42939 RESERVED NAME reserved_name 42804 DATATYPE MISMATCH datatype_mismatch 42P18 INDETERMINATE DATATYPE indeterminate_datatype 42809 WRONG OBJECT TYPE wrong_object_type 42703 UNDEFINED COLUMN undefined_column 42883 UNDEFINED FUNCTION undefined_function 42P01 UNDEFINED TABLE undefined_table 42P02 UNDEFINED PARAMETER undefined_parameter 42704 UNDEFINED OBJECT undefined_object 42701 DUPLICATE COLUMN duplicate_column 42P03 DUPLICATE CURSOR duplicate_cursor 42P04 DUPLICATE DATABASE duplicate_database 42723 DUPLICATE FUNCTION duplicate_function 42P05 DUPLICATE PREPARED STATEMENT duplicate_prepared_statement 42P06 DUPLICATE SCHEMA duplicate_schema 42P07 DUPLICATE TABLE duplicate_table 42712 DUPLICATE ALIAS duplicate_alias 42710 DUPLICATE OBJECT duplicate_object 42702 AMBIGUOUS COLUMN ambiguous_column 42725 AMBIGUOUS FUNCTION ambiguous_function 42P08 AMBIGUOUS PARAMETER ambiguous_parameter 42P09 AMBIGUOUS ALIAS ambiguous_alias 42P10 INVALID COLUMN REFERENCE invalid_column_reference 42611 INVALID COLUMN DEFINITION invalid_column_definition 42P11 INVALID CURSOR DEFINITION invalid_cursor_definition 42P12 INVALID DATABASE DEFINITION invalid_database_definition 42P13 INVALID FUNCTION DEFINITION invalid_function_definition 42P14 INVALID PREPARED STATEMENT DEFINITION invalid_prepared_statement_definition 42P15 INVALID SCHEMA DEFINITION invalid_schema_definition 42P16 INVALID TABLE DEFINITION invalid_table_definition 42P17 INVALID OBJECT DEFINITION invalid_object_definition Class 44 WITH CHECK OPTION Violation   44000 WITH CHECK OPTION VIOLATION with_check_option_violation Class 53 Insufficient Resources   53000 INSUFFICIENT RESOURCES insufficient_resources 53100 DISK FULL disk_full 53200 OUT OF MEMORY out_of_memory 53300 TOO MANY CONNECTIONS too_many_connections Class 54 Program Limit Exceeded   54000 PROGRAM LIMIT EXCEEDED program_limit_exceeded 54001 STATEMENT TOO COMPLEX statement_too_complex 54011 TOO MANY COLUMNS too_many_columns 54023 TOO MANY ARGUMENTS too_many_arguments Class 55 Object Not In Prerequisite State   55000 OBJECT NOT IN PREREQUISITE STATE object_not_in_prerequisite_state 55006 OBJECT IN USE object_in_use 55P02 CANT CHANGE RUNTIME PARAM cant_change_runtime_param 55P03 LOCK NOT AVAILABLE lock_not_available Class 57 Operator Intervention   57000 OPERATOR INTERVENTION operator_intervention 57014 QUERY CANCELED query_canceled 57P01 ADMIN SHUTDOWN admin_shutdown 57P02 CRASH SHUTDOWN crash_shutdown 57P03 CANNOT CONNECT NOW cannot_connect_now Class 58 System Error (errors external to PostgreSQL itself)   58030 IO ERROR io_error 58P01 UNDEFINED FILE undefined_file 58P02 DUPLICATE FILE duplicate_file Class F0 Configuration File Error   F0000 CONFIG FILE ERROR config_file_error F0001 LOCK FILE EXISTS lock_file_exists Class P0 PL/pgSQL Error   P0000 PLPGSQL ERROR plpgsql_error P0001 RAISE EXCEPTION raise_exception Class XX Internal Error   XX000 INTERNAL ERROR internal_error XX001 DATA CORRUPTED data_corrupted XX002 INDEX CORRUPTED index_corrupted