SQL State List
The following table lists the SQLSTATE classes and individual SQLSTATE codes.
| SQLState | Description | Details |
|---|---|---|
| Class 00—Successful Completion | ||
| 00000 | ERRCODE_SUCCESSFUL_COMPLETION | |
| Class 01—Warning | ||
| 01000 | ERRCODE_WARNING | associated warning messages |
| 01003 | ERRCODE_WARNING_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION | |
| 01004 | ERRCODE_WARNING_STRING_DATA_RIGHT_TRUNCATION | associated warning messages |
| 01006 | ERRCODE_WARNING_PRIVILEGE_NOT_REVOKED | associated warning messages |
| 01007 | ERRCODE_WARNING_PRIVILEGE_NOT_GRANTED | associated warning messages |
| 01008 | ERRCODE_WARNING_PRIVILEGE_ALREADY_GRANTED | |
| 01009 | ERRCODE_WARNING_PRIVILEGE_ALREADY_REVOKED | |
| 0100C | ERRCODE_WARNING_DYNAMIC_RESULT_SETS_RETURNED | |
| 01V01 | ERRCODE_WARNING_DEPRECATED_FEATURE | associated warning messages |
| 01V02 | ERRCODE_WARNING_QUERY_RETRIED | |
| Class 02—No Data | ||
| 02000 | ERRCODE_NO_DATA | |
| 02001 | ERRCODE_NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED | |
| Class 03—SQL Statement Not Yet Complete | ||
| 03000 | ERRCODE_SQL_STATEMENT_NOT_YET_COMPLETE | |
| Class 08—Client Connection Exception | ||
| 08000 | ERRCODE_CONNECTION_EXCEPTION | associated error messages |
| 08001 | ERRCODE_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION | associated error messages |
| 08003 | ERRCODE_CONNECTION_DOES_NOT_EXIST | associated error messages |
| 08004 | ERRCODE_SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION | |
| 08006 | ERRCODE_CONNECTION_FAILURE | associated error messages |
| 08007 | ERRCODE_TRANSACTION_RESOLUTION_UNKNOWN | |
| 08V01 | ERRCODE_PROTOCOL_VIOLATION | associated error messages |
| Class 09—Triggered Action Exception | ||
| 09000 | ERRCODE_TRIGGERED_ACTION_EXCEPTION | associated error messages |
| Class 0A—Feature Not Supported | ||
| 0A000 | ERRCODE_FEATURE_NOT_SUPPORTED | associated error messages |
| 0A005 | ERRCODE_PLAN_TO_SQL_NOT_SUPPORTED | associated error messages |
| Class 0B—Invalid Transaction Initiation | ||
| 0B000 | ERRCODE_INVALID_TRANSACTION_INITIATION | associated error messages |
| Class 0F—Locator Exception | ||
| 0F000 | ERRCODE_LOCATOR_EXCEPTION | |
| 0F001 | ERRCODE_L_E_INVALID_SPECIFICATION | |
| Class 0L—Invalid Grantor | ||
| 0L000 | ERRCODE_INVALID_GRANTOR | |
| 0LV01 | ERRCODE_INVALID_GRANT_OPERATION | associated error messages |
| Class 0P—Invalid Role Specification | ||
| 0P000 | ERRCODE_INVALID_ROLE_SPECIFICATION | |
| Class 21—Cardinality Violation | ||
| 21000 | ERRCODE_CARDINALITY_VIOLATION | |
| Class 22—Data Exception | ||
| 22000 | ERRCODE_DATA_EXCEPTION | associated error messages |
| 22001 | ERRCODE_STRING_DATA_RIGHT_TRUNCATION | associated error messages |
| 22002 | ERRCODE_NULL_VALUE_NO_INDICATOR_PARAMETER | |
| 22003 | ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE | associated error messages |
| 22004 | ERRCODE_NULL_VALUE_NOT_ALLOWED | associated error messages |
| 22005 | ERRCODE_ERROR_IN_ASSIGNMENT | |
| 22007 | ERRCODE_INVALID_DATETIME_FORMAT | associated error messages |
| 22008 | ERRCODE_DATETIME_FIELD_OVERFLOW | associated error messages |
| 22009 | ERRCODE_INVALID_TIME_ZONE_DISPLACEMENT_VALUE | associated error messages |
| 2200B | ERRCODE_ESCAPE_CHARACTER_CONFLICT | associated error messages |
| 2200C | ERRCODE_INVALID_USE_OF_ESCAPE_CHARACTER | |
| 2200D | ERRCODE_INVALID_ESCAPE_OCTET | associated error messages |
| 2200F | ERRCODE_ZERO_LENGTH_CHARACTER_STRING | |
| 2200G | ERRCODE_MOST_SPECIFIC_TYPE_MISMATCH | |
| 22010 | ERRCODE_INVALID_INDICATOR_PARAMETER_VALUE | |
| 22011 | ERRCODE_SUBSTRING_ERROR | associated error messages |
| 22012 | ERRCODE_DIVISION_BY_ZERO | associated error messages |
| 22015 | ERRCODE_INTERVAL_FIELD_OVERFLOW | associated error messages |
| 22018 | ERRCODE_INVALID_CHARACTER_VALUE_FOR_CAST | |
| 22019 | ERRCODE_INVALID_ESCAPE_CHARACTER | associated error messages |
| 2201B | ERRCODE_INVALID_REGULAR_EXPRESSION | associated error messages |
| 2201E | ERRCODE_INVALID_ARGUMENT_FOR_LOG | |
| 2201F | ERRCODE_INVALID_ARGUMENT_FOR_POWER_FUNCTION | |
| 2201G | ERRCODE_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION | associated error messages |
| 22020 | ERRCODE_INVALID_LIMIT_VALUE | |
| 22021 | ERRCODE_CHARACTER_NOT_IN_REPERTOIRE | associated error messages |
| 22022 | ERRCODE_INDICATOR_OVERFLOW | |
| 22023 | ERRCODE_INVALID_PARAMETER_VALUE | associated error messages |
| 22024 | ERRCODE_UNTERMINATED_C_STRING | |
| 22025 | ERRCODE_INVALID_ESCAPE_SEQUENCE | associated error messages |
| 22026 | ERRCODE_STRING_DATA_LENGTH_MISMATCH | |
| 22027 | ERRCODE_TRIM_ERROR | |
| 2202E | ERRCODE_ARRAY_ELEMENT_ERROR | |
| 22906 | ERRCODE_NONSTANDARD_USE_OF_ESCAPE_CHARACTER | associated error messages |
| 22V01 | ERRCODE_FLOATING_POINT_EXCEPTION | |
| 22V02 | ERRCODE_INVALID_TEXT_REPRESENTATION | associated error messages |
| 22V03 | ERRCODE_INVALID_BINARY_REPRESENTATION | associated error messages |
| 22V04 | ERRCODE_BAD_COPY_FILE_FORMAT | associated error messages |
| 22V05 | ERRCODE_UNTRANSLATABLE_CHARACTER | |
| 22V0B | ERRCODE_ESCAPE_CHARACTER_ON_NOESCAPE | associated error messages |
| 22V21 | ERRCODE_INVALID_EPOCH | associated error messages |
| 22V22 | ERRCODE_PLPGSQL_ERROR | |
| 22V23 | ERRCODE_RAISE_EXCEPTION | associated error messages |
| 22V24 | ERRCODE_COPY_PARSE_ERROR | associated error messages |
| Class 23—Integrity Constraint Violation | ||
| 23000 | ERRCODE_INTEGRITY_CONSTRAINT_VIOLATION | |
| 23001 | ERRCODE_RESTRICT_VIOLATION | |
| 23502 | ERRCODE_NOT_NULL_VIOLATION | associated error messages |
| 23503 | ERRCODE_FOREIGN_KEY_VIOLATION | associated error messages |
| 23505 | ERRCODE_UNIQUE_VIOLATION | associated error messages |
| 23514 | ERRCODE_CHECK_VIOLATION | associated error messages |
| Class 24—Invalid Cursor State | ||
| 24000 | ERRCODE_INVALID_CURSOR_STATE | |
| Class 25—Invalid Transaction State | ||
| 25000 | ERRCODE_INVALID_TRANSACTION_STATE | associated error messages |
| 25001 | ERRCODE_ACTIVE_SQL_TRANSACTION | |
| 25002 | ERRCODE_BRANCH_TRANSACTION_ALREADY_ACTIVE | |
| 25003 | ERRCODE_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION | |
| 25004 | ERRCODE_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION | |
| 25005 | ERRCODE_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION | |
| 25006 | ERRCODE_READ_ONLY_SQL_TRANSACTION | |
| 25007 | ERRCODE_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED | |
| 25008 | ERRCODE_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL | |
| 25V01 | ERRCODE_NO_ACTIVE_SQL_TRANSACTION | associated error messages |
| 25V02 | ERRCODE_IN_FAILED_SQL_TRANSACTION | |
| Class 26—Invalid SQL Statement Name | ||
| 26000 | ERRCODE_INVALID_SQL_STATEMENT_NAME | |
| Class 27—Triggered Data Change Violation | ||
| 27000 | ERRCODE_TRIGGERED_DATA_CHANGE_VIOLATION | |
| Class 28—Invalid Authorization Specification | ||
| 28000 | ERRCODE_INVALID_AUTHORIZATION_SPECIFICATION | associated error messages |
| 28001 | ERRCODE_ACCOUNT_LOCKED | |
| 28002 | ERRCODE_PASSWORD_EXPIRED | |
| 28003 | ERRCODE_PASSWORD_IN_GRACE_PERIOD | |
| Class 2B—Dependent Privilege Descriptors Still Exist | ||
| 2B000 | ERRCODE_DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST | |
| 2BV01 | ERRCODE_DEPENDENT_OBJECTS_STILL_EXIST | associated error messages |
| Class 2D—Invalid Transaction Termination | ||
| 2D000 | ERRCODE_INVALID_TRANSACTION_TERMINATION | |
| Class 2F—SQL Routine Exception | ||
| 2F000 | ERRCODE_SQL_ROUTINE_EXCEPTION | |
| 2F002 | ERRCODE_S_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED | |
| 2F003 | ERRCODE_S_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED | |
| 2F004 | ERRCODE_S_R_E_READING_SQL_DATA_NOT_PERMITTED | |
| 2F005 | ERRCODE_S_R_E_FUNCTION_EXECUTED_NO_RETURN_STATEMENT | |
| Class 34—Invalid Cursor Name | ||
| 34000 | ERRCODE_INVALID_CURSOR_NAME | |
| Class 38—External Routine Exception | ||
| 38000 | ERRCODE_EXTERNAL_ROUTINE_EXCEPTION | |
| 38001 | ERRCODE_E_R_E_CONTAINING_SQL_NOT_PERMITTED | |
| 38002 | ERRCODE_E_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED | |
| 38003 | ERRCODE_E_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED | |
| 38004 | ERRCODE_E_R_E_READING_SQL_DATA_NOT_PERMITTED | associated error messages |
| Class 39—External Routine Invocation Exception | ||
| 39000 | ERRCODE_EXTERNAL_ROUTINE_INVOCATION_EXCEPTION | |
| 39001 | ERRCODE_E_R_I_E_INVALID_SQLSTATE_RETURNED | |
| 39004 | ERRCODE_E_R_I_E_NULL_VALUE_NOT_ALLOWED | |
| 39V01 | ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED | |
| 39V02 | ERRCODE_E_R_I_E_SRF_PROTOCOL_VIOLATED | |
| Class 3B—Savepoint Exception | ||
| 3B000 | ERRCODE_SAVEPOINT_EXCEPTION | |
| 3B001 | ERRCODE_S_E_INVALID_SPECIFICATION | |
| Class 3D—Invalid Catalog Name | ||
| 3D000 | ERRCODE_INVALID_CATALOG_NAME | |
| Class 3F—Invalid Schema Name | ||
| 3F000 | ERRCODE_INVALID_SCHEMA_NAME | |
| Class 40—Transaction Rollback | ||
| 40000 | ERRCODE_TRANSACTION_ROLLBACK | |
| 40001 | ERRCODE_T_R_SERIALIZATION_FAILURE | |
| 40002 | ERRCODE_T_R_INTEGRITY_CONSTRAINT_VIOLATION | |
| 40003 | ERRCODE_T_R_STATEMENT_COMPLETION_UNKNOWN | |
| 40V01 | ERRCODE_T_R_DEADLOCK_DETECTED | associated error messages |
| Class 42—Syntax Error or Access Rule Violation | ||
| 42000 | ERRCODE_SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION | |
| 42501 | ERRCODE_INSUFFICIENT_PRIVILEGE | associated error messages |
| 42601 | ERRCODE_SYNTAX_ERROR | associated error messages |
| 42602 | ERRCODE_INVALID_NAME | associated error messages |
| 42611 | ERRCODE_INVALID_COLUMN_DEFINITION | associated error messages |
| 42622 | ERRCODE_NAME_TOO_LONG | associated error messages |
| 42701 | ERRCODE_DUPLICATE_COLUMN | associated error messages |
| 42702 | ERRCODE_AMBIGUOUS_COLUMN | associated error messages |
| 42703 | ERRCODE_UNDEFINED_COLUMN | associated error messages |
| 42704 | ERRCODE_UNDEFINED_OBJECT | associated error messages |
| 42710 | ERRCODE_DUPLICATE_OBJECT | associated error messages |
| 42712 | ERRCODE_DUPLICATE_ALIAS | associated error messages |
| 42723 | ERRCODE_DUPLICATE_FUNCTION | associated error messages |
| 42725 | ERRCODE_AMBIGUOUS_FUNCTION | associated error messages |
| 42803 | ERRCODE_GROUPING_ERROR | associated error messages |
| 42804 | ERRCODE_DATATYPE_MISMATCH | associated error messages |
| 42809 | ERRCODE_WRONG_OBJECT_TYPE | associated error messages |
| 42830 | ERRCODE_INVALID_FOREIGN_KEY | associated error messages |
| 42846 | ERRCODE_CANNOT_COERCE | associated error messages |
| 42883 | ERRCODE_UNDEFINED_FUNCTION | associated error messages |
| 42939 | ERRCODE_RESERVED_NAME | associated error messages |
| 42P20 | ERRCODE_WINDOWING_ERROR | associated error messages |
| 42V01 | ERRCODE_UNDEFINED_TABLE | associated error messages |
| 42V02 | ERRCODE_UNDEFINED_PARAMETER | associated error messages |
| 42V03 | ERRCODE_DUPLICATE_CURSOR | associated error messages |
| 42V04 | ERRCODE_DUPLICATE_DATABASE | associated error messages |
| 42V05 | ERRCODE_DUPLICATE_PSTATEMENT | |
| 42V06 | ERRCODE_DUPLICATE_SCHEMA | associated error messages |
| 42V07 | ERRCODE_DUPLICATE_TABLE | associated error messages |
| 42V08 | ERRCODE_AMBIGUOUS_PARAMETER | associated error messages |
| 42V09 | ERRCODE_AMBIGUOUS_ALIAS | associated error messages |
| 42V10 | ERRCODE_INVALID_COLUMN_REFERENCE | associated error messages |
| 42V11 | ERRCODE_INVALID_CURSOR_DEFINITION | associated error messages |
| 42V12 | ERRCODE_INVALID_DATABASE_DEFINITION | |
| 42V13 | ERRCODE_INVALID_FUNCTION_DEFINITION | associated error messages |
| 42V14 | ERRCODE_INVALID_PSTATEMENT_DEFINITION | |
| 42V15 | ERRCODE_INVALID_SCHEMA_DEFINITION | associated error messages |
| 42V16 | ERRCODE_INVALID_TABLE_DEFINITION | associated error messages |
| 42V17 | ERRCODE_INVALID_OBJECT_DEFINITION | associated error messages |
| 42V18 | ERRCODE_INDETERMINATE_DATATYPE | associated error messages |
| 42V21 | ERRCODE_UNDEFINED_PROJECTION | associated error messages |
| 42V22 | ERRCODE_UNDEFINED_NODE | associated error messages |
| 42V23 | ERRCODE_UNDEFINED_PERMUTATION | |
| 42V24 | ERRCODE_UNDEFINED_USER | associated error messages |
| 42V25 | ERRCODE_PATTERN_MATCH_ERROR | associated error messages |
| 42V26 | ERRCODE_DUPLICATE_NODE | associated error messages |
| Class 44—WITH CHECK OPTION Violation | ||
| 44000 | ERRCODE_WITH_CHECK_OPTION_VIOLATION | |
| Class 53—Insufficient Resources | ||
| 53000 | ERRCODE_INSUFFICIENT_RESOURCES | associated error messages |
| 53100 | ERRCODE_DISK_FULL | associated error messages |
| 53200 | ERRCODE_OUT_OF_MEMORY | associated error messages |
| 53300 | ERRCODE_TOO_MANY_CONNECTIONS | |
| Class 54—Program Limit Exceeded | ||
| 54000 | ERRCODE_PROGRAM_LIMIT_EXCEEDED | associated error messages |
| 54001 | ERRCODE_STATEMENT_TOO_COMPLEX | associated error messages |
| 54011 | ERRCODE_TOO_MANY_COLUMNS | associated error messages |
| 54023 | ERRCODE_TOO_MANY_ARGUMENTS | associated error messages |
| Class 55—Object Not In Prerequisite State | ||
| 55000 | ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE | associated error messages |
| 55006 | ERRCODE_OBJECT_IN_USE | associated error messages |
| 55V02 | ERRCODE_CANT_CHANGE_RUNTIME_PARAM | associated error messages |
| 55V03 | ERRCODE_LOCK_NOT_AVAILABLE | associated error messages |
| 55V04 | ERRCODE_TM_MARKER_NOT_AVAILABLE | associated error messages |
| Class 57—Operator Intervention | ||
| 57000 | ERRCODE_OPERATOR_INTERVENTION | |
| 57014 | ERRCODE_QUERY_CANCELED | associated error messages |
| 57015 | ERRCODE_SLOW_DELETE | associated error messages |
| 57V01 | ERRCODE_ADMIN_SHUTDOWN | associated error messages |
| 57V02 | ERRCODE_CRASH_SHUTDOWN | |
| 57V03 | ERRCODE_CANNOT_CONNECT_NOW | associated error messages |
| 57V04 | ERRCODE_DML_COMMIT_DURING_SHUTDOWN | associated error messages |
| Class 58—System Error | ||
| 58030 | ERRCODE_IO_ERROR | associated error messages |
| 58V01 | ERRCODE_UNDEFINED_FILE | associated error messages |
| 58V02 | ERRCODE_DUPLICATE_FILE | |
| Class V1—Vertica-specific multi-node errors class | ||
| V1001 | ERRCODE_LOST_CONNECTIVITY | associated error messages |
| V1002 | ERRCODE_K_SAFETY_VIOLATION | associated error messages |
| V1003 | ERRCODE_CLUSTER_CHANGE | associated error messages |
| Class V2—Vertica-specific miscellaneous errors class | ||
| V2000 | ERRCODE_AUTH_FAILED | associated error messages |
| V2001 | ERRCODE_LICENSE_ISSUE | associated error messages |
| V2002 | ERRCODE_MOVEOUT_ABORTED | |
| Class VC—Configuration File Error | ||
| VC001 | ERRCODE_CONFIG_FILE_ERROR | associated error messages |
| VC002 | ERRCODE_LOCK_FILE_EXISTS | |
| Class VD—DB Designer errors | ||
| VD001 | ERRCODE_DESIGNER_FUNCTION_ERROR | associated error messages |
| Class VP—User procedure errors | ||
| VP000 | ERRCODE_USER_PROC_ERROR | associated error messages |
| VP001 | ERRCODE_USER_PROC_EXEC_ERROR | associated error messages |
| Class VX—Internal Error | ||
| VX001 | ERRCODE_INTERNAL_ERROR | associated error messages |
| VX002 | ERRCODE_DATA_CORRUPTED | associated error messages |
| VX003 | ERRCODE_INDEX_CORRUPTED | associated error messages |
| VX004 | ERRCODE_PLAN_TO_SQL_INTERNAL_EROR | associated error messages |