Module postgres::error

Errors.

Structs

DbError	A Postgres error or notice.
Error	An error communicating with the Postgres server.
SqlState	A SQLSTATE error code

Enums

ErrorPosition	Represents the position of an error in a query.
Severity	The severity of a Postgres error or notice.

Constants

ACTIVE_SQL_TRANSACTION	25001
ADMIN_SHUTDOWN	57P01
AMBIGUOUS_ALIAS	42P09
AMBIGUOUS_COLUMN	42702
AMBIGUOUS_FUNCTION	42725
AMBIGUOUS_PARAMETER	42P08
ARRAY_ELEMENT_ERROR	2202E
ARRAY_SUBSCRIPT_ERROR	2202E
ASSERT_FAILURE	P0004
BAD_COPY_FILE_FORMAT	22P04
BRANCH_TRANSACTION_ALREADY_ACTIVE	25002
CANNOT_COERCE	42846
CANNOT_CONNECT_NOW	57P03
CANT_CHANGE_RUNTIME_PARAM	55P02
CARDINALITY_VIOLATION	21000
CASE_NOT_FOUND	20000
CHARACTER_NOT_IN_REPERTOIRE	22021
CHECK_VIOLATION	23514
COLLATION_MISMATCH	42P21
CONFIGURATION_LIMIT_EXCEEDED	53400
CONFIG_FILE_ERROR	F0000
CONNECTION_DOES_NOT_EXIST	08003
CONNECTION_EXCEPTION	08000
CONNECTION_FAILURE	08006
CRASH_SHUTDOWN	57P02
DATABASE_DROPPED	57P04
DATATYPE_MISMATCH	42804
DATA_CORRUPTED	XX001
DATA_EXCEPTION	22000
DATETIME_FIELD_OVERFLOW	22008
DATETIME_VALUE_OUT_OF_RANGE	22008
DEPENDENT_OBJECTS_STILL_EXIST	2BP01
DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST	2B000
DIAGNOSTICS_EXCEPTION	0Z000
DISK_FULL	53100
DIVISION_BY_ZERO	22012
DUPLICATE_ALIAS	42712
DUPLICATE_COLUMN	42701
DUPLICATE_CURSOR	42P03
DUPLICATE_DATABASE	42P04
DUPLICATE_FILE	58P02
DUPLICATE_FUNCTION	42723
DUPLICATE_OBJECT	42710
DUPLICATE_PSTATEMENT	42P05
DUPLICATE_SCHEMA	42P06
DUPLICATE_TABLE	42P07
ERROR_IN_ASSIGNMENT	22005
ESCAPE_CHARACTER_CONFLICT	2200B
EXCLUSION_VIOLATION	23P01
EXTERNAL_ROUTINE_EXCEPTION	38000
EXTERNAL_ROUTINE_INVOCATION_EXCEPTION	39000
E_R_E_CONTAINING_SQL_NOT_PERMITTED	38001
E_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED	38002
E_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED	38003
E_R_E_READING_SQL_DATA_NOT_PERMITTED	38004
E_R_I_E_EVENT_TRIGGER_PROTOCOL_VIOLATED	39P03
E_R_I_E_INVALID_SQLSTATE_RETURNED	39001
E_R_I_E_NULL_VALUE_NOT_ALLOWED	39004
E_R_I_E_SRF_PROTOCOL_VIOLATED	39P02
E_R_I_E_TRIGGER_PROTOCOL_VIOLATED	39P01
FDW_COLUMN_NAME_NOT_FOUND	HV005
FDW_DYNAMIC_PARAMETER_VALUE_NEEDED	HV002
FDW_ERROR	HV000
FDW_FUNCTION_SEQUENCE_ERROR	HV010
FDW_INCONSISTENT_DESCRIPTOR_INFORMATION	HV021
FDW_INVALID_ATTRIBUTE_VALUE	HV024
FDW_INVALID_COLUMN_NAME	HV007
FDW_INVALID_COLUMN_NUMBER	HV008
FDW_INVALID_DATA_TYPE	HV004
FDW_INVALID_DATA_TYPE_DESCRIPTORS	HV006
FDW_INVALID_DESCRIPTOR_FIELD_IDENTIFIER	HV091
FDW_INVALID_HANDLE	HV00B
FDW_INVALID_OPTION_INDEX	HV00C
FDW_INVALID_OPTION_NAME	HV00D
FDW_INVALID_STRING_FORMAT	HV00A
FDW_INVALID_STRING_LENGTH_OR_BUFFER_LENGTH	HV090
FDW_INVALID_USE_OF_NULL_POINTER	HV009
FDW_NO_SCHEMAS	HV00P
FDW_OPTION_NAME_NOT_FOUND	HV00J
FDW_OUT_OF_MEMORY	HV001
FDW_REPLY_HANDLE	HV00K
FDW_SCHEMA_NOT_FOUND	HV00Q
FDW_TABLE_NOT_FOUND	HV00R
FDW_TOO_MANY_HANDLES	HV014
FDW_UNABLE_TO_CREATE_EXECUTION	HV00L
FDW_UNABLE_TO_CREATE_REPLY	HV00M
FDW_UNABLE_TO_ESTABLISH_CONNECTION	HV00N
FEATURE_NOT_SUPPORTED	0A000
FLOATING_POINT_EXCEPTION	22P01
FOREIGN_KEY_VIOLATION	23503
GENERATED_ALWAYS	428C9
GROUPING_ERROR	42803
HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL	25008
IDLE_IN_TRANSACTION_SESSION_TIMEOUT	25P03
INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION	25003
INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION	25004
INDETERMINATE_COLLATION	42P22
INDETERMINATE_DATATYPE	42P18
INDEX_CORRUPTED	XX002
INDICATOR_OVERFLOW	22022
INSUFFICIENT_PRIVILEGE	42501
INSUFFICIENT_RESOURCES	53000
INTEGRITY_CONSTRAINT_VIOLATION	23000
INTERNAL_ERROR	XX000
INTERVAL_FIELD_OVERFLOW	22015
INVALID_ARGUMENT_FOR_LOG	2201E
INVALID_ARGUMENT_FOR_NTH_VALUE	22016
INVALID_ARGUMENT_FOR_NTILE	22014
INVALID_ARGUMENT_FOR_POWER_FUNCTION	2201F
INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION	2201G
INVALID_AUTHORIZATION_SPECIFICATION	28000
INVALID_BINARY_REPRESENTATION	22P03
INVALID_CATALOG_NAME	3D000
INVALID_CHARACTER_VALUE_FOR_CAST	22018
INVALID_COLUMN_DEFINITION	42611
INVALID_COLUMN_REFERENCE	42P10
INVALID_CURSOR_DEFINITION	42P11
INVALID_CURSOR_NAME	34000
INVALID_CURSOR_STATE	24000
INVALID_DATABASE_DEFINITION	42P12
INVALID_DATETIME_FORMAT	22007
INVALID_ESCAPE_CHARACTER	22019
INVALID_ESCAPE_OCTET	2200D
INVALID_ESCAPE_SEQUENCE	22025
INVALID_FOREIGN_KEY	42830
INVALID_FUNCTION_DEFINITION	42P13
INVALID_GRANTOR	0L000
INVALID_GRANT_OPERATION	0LP01
INVALID_INDICATOR_PARAMETER_VALUE	22010
INVALID_NAME	42602
INVALID_OBJECT_DEFINITION	42P17
INVALID_PARAMETER_VALUE	22023
INVALID_PASSWORD	28P01
INVALID_PSTATEMENT_DEFINITION	42P14
INVALID_RECURSION	42P19
INVALID_REGULAR_EXPRESSION	2201B
INVALID_ROLE_SPECIFICATION	0P000
INVALID_ROW_COUNT_IN_LIMIT_CLAUSE	2201W
INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE	2201X
INVALID_SCHEMA_DEFINITION	42P15
INVALID_SCHEMA_NAME	3F000
INVALID_SQL_STATEMENT_NAME	26000
INVALID_TABLESAMPLE_ARGUMENT	2202H
INVALID_TABLESAMPLE_REPEAT	2202G
INVALID_TABLE_DEFINITION	42P16
INVALID_TEXT_REPRESENTATION	22P02
INVALID_TIME_ZONE_DISPLACEMENT_VALUE	22009
INVALID_TRANSACTION_INITIATION	0B000
INVALID_TRANSACTION_STATE	25000
INVALID_TRANSACTION_TERMINATION	2D000
INVALID_USE_OF_ESCAPE_CHARACTER	2200C
INVALID_XML_COMMENT	2200S
INVALID_XML_CONTENT	2200N
INVALID_XML_DOCUMENT	2200M
INVALID_XML_PROCESSING_INSTRUCTION	2200T
IN_FAILED_SQL_TRANSACTION	25P02
IO_ERROR	58030
LOCATOR_EXCEPTION	0F000
LOCK_FILE_EXISTS	F0001
LOCK_NOT_AVAILABLE	55P03
L_E_INVALID_SPECIFICATION	0F001
MOST_SPECIFIC_TYPE_MISMATCH	2200G
NAME_TOO_LONG	42622
NONSTANDARD_USE_OF_ESCAPE_CHARACTER	22P06
NOT_AN_XML_DOCUMENT	2200L
NOT_NULL_VIOLATION	23502
NO_ACTIVE_SQL_TRANSACTION	25P01
NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION	25005
NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED	02001
NO_DATA	02000
NO_DATA_FOUND	P0002
NULL_VALUE_NOT_ALLOWED	22004
NULL_VALUE_NO_INDICATOR_PARAMETER	22002
NUMERIC_VALUE_OUT_OF_RANGE	22003
OBJECT_IN_USE	55006
OBJECT_NOT_IN_PREREQUISITE_STATE	55000
OPERATOR_INTERVENTION	57000
OUT_OF_MEMORY	53200
PLPGSQL_ERROR	P0000
PROGRAM_LIMIT_EXCEEDED	54000
PROTOCOL_VIOLATION	08P01
QUERY_CANCELED	57014
RAISE_EXCEPTION	P0001
READ_ONLY_SQL_TRANSACTION	25006
RESERVED_NAME	42939
RESTRICT_VIOLATION	23001
SAVEPOINT_EXCEPTION	3B000
SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED	25007
SEQUENCE_GENERATOR_LIMIT_EXCEEDED	2200H
SNAPSHOT_TOO_OLD	72000
SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION	08001
SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION	08004
SQL_ROUTINE_EXCEPTION	2F000
SQL_STATEMENT_NOT_YET_COMPLETE	03000
STACKED_DIAGNOSTICS_ACCESSED_WITHOUT_ACTIVE_HANDLER	0Z002
STATEMENT_TOO_COMPLEX	54001
STRING_DATA_LENGTH_MISMATCH	22026
STRING_DATA_RIGHT_TRUNCATION	22001
SUBSTRING_ERROR	22011
SUCCESSFUL_COMPLETION	00000
SYNTAX_ERROR	42601
SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION	42000
SYSTEM_ERROR	58000
S_E_INVALID_SPECIFICATION	3B001
S_R_E_FUNCTION_EXECUTED_NO_RETURN_STATEMENT	2F005
S_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED	2F002
S_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED	2F003
S_R_E_READING_SQL_DATA_NOT_PERMITTED	2F004
TOO_MANY_ARGUMENTS	54023
TOO_MANY_COLUMNS	54011
TOO_MANY_CONNECTIONS	53300
TOO_MANY_ROWS	P0003
TRANSACTION_RESOLUTION_UNKNOWN	08007
TRANSACTION_ROLLBACK	40000
TRIGGERED_ACTION_EXCEPTION	09000
TRIGGERED_DATA_CHANGE_VIOLATION	27000
TRIM_ERROR	22027
T_R_DEADLOCK_DETECTED	40P01
T_R_INTEGRITY_CONSTRAINT_VIOLATION	40002
T_R_SERIALIZATION_FAILURE	40001
T_R_STATEMENT_COMPLETION_UNKNOWN	40003
UNDEFINED_COLUMN	42703
UNDEFINED_CURSOR	34000
UNDEFINED_DATABASE	3D000
UNDEFINED_FILE	58P01
UNDEFINED_FUNCTION	42883
UNDEFINED_OBJECT	42704
UNDEFINED_PARAMETER	42P02
UNDEFINED_PSTATEMENT	26000
UNDEFINED_SCHEMA	3F000
UNDEFINED_TABLE	42P01
UNIQUE_VIOLATION	23505
UNSAFE_NEW_ENUM_VALUE_USAGE	55P04
UNTERMINATED_C_STRING	22024
UNTRANSLATABLE_CHARACTER	22P05
WARNING	01000
WARNING_DEPRECATED_FEATURE	01P01
WARNING_DYNAMIC_RESULT_SETS_RETURNED	0100C
WARNING_IMPLICIT_ZERO_BIT_PADDING	01008
WARNING_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION	01003
WARNING_PRIVILEGE_NOT_GRANTED	01007
WARNING_PRIVILEGE_NOT_REVOKED	01006
WARNING_STRING_DATA_RIGHT_TRUNCATION	01004
WINDOWING_ERROR	42P20
WITH_CHECK_OPTION_VIOLATION	44000
WRONG_OBJECT_TYPE	42809
ZERO_LENGTH_CHARACTER_STRING	2200F