Module postgres_shared::error[][src]

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