The five-character SQLSTATE, packed into a number so that it compares and switches like an
enum: if error.code == .UNIQUE_VIOLATION. Codes not listed here still compare and print
(sqlstate_text). Its class is the first two characters: sqlstate_class(code).
Members
- NONE
- SUCCESSFUL_COMPLETION
- 00000
- WARNING
- 01000
- NO_DATA
- 02000
- CONNECTION_EXCEPTION
- 08000
- CONNECTION_DOES_NOT_EXIST
- 08003
- CONNECTION_FAILURE
- 08006
- PROTOCOL_VIOLATION
- 08P01
- FEATURE_NOT_SUPPORTED
- 0A000
- CARDINALITY_VIOLATION
- 21000
- DATA_EXCEPTION
- 22000
- STRING_DATA_RIGHT_TRUNCATION
- 22001
- NUMERIC_VALUE_OUT_OF_RANGE
- 22003
- NULL_VALUE_NOT_ALLOWED
- 22004
- INVALID_DATETIME_FORMAT
- 22007
- DATETIME_FIELD_OVERFLOW
- 22008
- DIVISION_BY_ZERO
- 22012
- CHARACTER_NOT_IN_REPERTOIRE
- 22021
- INVALID_PARAMETER_VALUE
- 22023
- INVALID_TEXT_REPRESENTATION
- 22P02
- INVALID_BINARY_REPRESENTATION
- 22P03
- INVALID_JSON_TEXT
- 22P05
- INTEGRITY_CONSTRAINT_VIOLATION
- 23000
- RESTRICT_VIOLATION
- 23001
- NOT_NULL_VIOLATION
- 23502
- FOREIGN_KEY_VIOLATION
- 23503
- UNIQUE_VIOLATION
- 23505
- CHECK_VIOLATION
- 23514
- EXCLUSION_VIOLATION
- 23P01
- INVALID_CURSOR_STATE
- 24000
- INVALID_TRANSACTION_STATE
- 25000
- ACTIVE_SQL_TRANSACTION
- 25001
- READ_ONLY_SQL_TRANSACTION
- 25006
- IN_FAILED_SQL_TRANSACTION
- 25P02
- IDLE_IN_TRANSACTION_SESSION_TIMEOUT
- 25P03
- INVALID_SQL_STATEMENT_NAME
- 26000
- INVALID_AUTHORIZATION_SPECIFICATION
- 28000
- INVALID_PASSWORD
- 28P01
- TRANSACTION_ROLLBACK
- 40000
- SERIALIZATION_FAILURE
- 40001
- STATEMENT_COMPLETION_UNKNOWN
- 40003
- DEADLOCK_DETECTED
- 40P01
- SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION
- 42000
- SYNTAX_ERROR
- 42601
- INSUFFICIENT_PRIVILEGE
- 42501
- CANNOT_COERCE
- 42846
- GROUPING_ERROR
- 42803
- DATATYPE_MISMATCH
- 42804
- WRONG_OBJECT_TYPE
- 42809
- UNDEFINED_COLUMN
- 42703
- UNDEFINED_FUNCTION
- 42883
- UNDEFINED_TABLE
- 42P01
- UNDEFINED_PARAMETER
- 42P02
- UNDEFINED_OBJECT
- 42704
- DUPLICATE_COLUMN
- 42701
- DUPLICATE_DATABASE
- 42P04
- DUPLICATE_FUNCTION
- 42723
- DUPLICATE_PREPARED_STATEMENT
- 42P05
- DUPLICATE_SCHEMA
- 42P06
- DUPLICATE_TABLE
- 42P07
- DUPLICATE_OBJECT
- 42710
- AMBIGUOUS_COLUMN
- 42702
- AMBIGUOUS_FUNCTION
- 42725
- INDETERMINATE_DATATYPE
- 42P18
- INVALID_COLUMN_REFERENCE
- 42P10
- INVALID_OBJECT_DEFINITION
- 42P17
- INSUFFICIENT_RESOURCES
- 53000
- DISK_FULL
- 53100
- OUT_OF_MEMORY
- 53200
- TOO_MANY_CONNECTIONS
- 53300
- PROGRAM_LIMIT_EXCEEDED
- 54000
- OBJECT_NOT_IN_PREREQUISITE_STATE
- 55000
- OBJECT_IN_USE
- 55006
- LOCK_NOT_AVAILABLE
- 55P03
- OPERATOR_INTERVENTION
- 57000
- QUERY_CANCELED
- 57014
- ADMIN_SHUTDOWN
- 57P01
- CRASH_SHUTDOWN
- 57P02
- CANNOT_CONNECT_NOW
- 57P03
- DATABASE_DROPPED
- 57P04
- IDLE_SESSION_TIMEOUT
- 57P05
- SYSTEM_ERROR
- 58000
- RAISE_EXCEPTION
- P0001
- NO_DATA_FOUND
- P0002
- TOO_MANY_ROWS
- P0003
- ASSERT_FAILURE
- P0004
- INTERNAL_ERROR
- XX000
- DATA_CORRUPTED
- XX001