PostgreSQL.ErrorCodes

type ErrorCode

Class 00 — Successful Completion

successful_completion

Class 01 — Warning

warning

dynamic_result_sets_returned

implicit_zero_bit_padding

null_value_eliminated_in_set_function

privilege_not_granted

privilege_not_revoked

string_data_right_truncation

deprecated_feature

Class 02 — No Data (this is also a warning class per the SQL standard)

no_data

no_additional_dynamic_result_sets_returned

Class 03 — SQL Statement Not Yet Complete

sql_statement_not_yet_complete

Class 08 — Connection Exception

connection_exception

connection_does_not_exist

connection_failure

sqlclient_unable_to_establish_sqlconnection

sqlserver_rejected_establishment_of_sqlconnection

transaction_resolution_unknown

protocol_violation

Class 09 — Triggered Action Exception

triggered_action_exception

Class 0A — Feature Not Supported

feature_not_supported

Class 0B — Invalid Transaction Initiation

invalid_transaction_initiation

Class 0F — Locator Exception

locator_exception

invalid_locator_specification

Class 0L — Invalid Grantor

invalid_grantor

invalid_grant_operation

Class 0P — Invalid Role Specification

invalid_role_specification

Class 0Z — Diagnostics Exception

diagnostics_exception

stacked_diagnostics_accessed_without_active_handler

Class 20 — Case Not Found

case_not_found

Class 21 — Cardinality Violation

cardinality_violation

Class 22 — Data Exception

data_exception

array_subscript_error

character_not_in_repertoire

datetime_field_overflow

division_by_zero

error_in_assignment

escape_character_conflict

indicator_overflow

interval_field_overflow

invalid_argument_for_logarithm

invalid_argument_for_ntile_function

invalid_argument_for_nth_value_function

invalid_argument_for_power_function

invalid_argument_for_width_bucket_function

invalid_character_value_for_cast

invalid_datetime_format

invalid_escape_character

invalid_escape_octet

invalid_escape_sequence

nonstandard_use_of_escape_character

invalid_indicator_parameter_value

invalid_parameter_value

invalid_regular_expression

invalid_row_count_in_limit_clause

invalid_row_count_in_result_offset_clause

invalid_tablesample_argument

invalid_tablesample_repeat

invalid_time_zone_displacement_value

invalid_use_of_escape_character

most_specific_type_mismatch

null_value_not_allowed

null_value_no_indicator_parameter

numeric_value_out_of_range

string_data_length_mismatch

string_data_right_truncation'

substring_error

trim_error

unterminated_c_string

zero_length_character_string

floating_point_exception

invalid_text_representation

invalid_binary_representation

bad_copy_file_format

untranslatable_character

not_an_xml_document

invalid_xml_document

invalid_xml_content

invalid_xml_comment

invalid_xml_processing_instruction

Class 23 — Integrity Constraint Violation

integrity_constraint_violation

restrict_violation

not_null_violation

foreign_key_violation

unique_violation

check_violation

exclusion_violation

Class 24 — Invalid Cursor State

invalid_cursor_state

Class 25 — Invalid Transaction State

invalid_transaction_state

active_sql_transaction

branch_transaction_already_active

held_cursor_requires_same_isolation_level

inappropriate_access_mode_for_branch_transaction

inappropriate_isolation_level_for_branch_transaction

no_active_sql_transaction_for_branch_transaction

read_only_sql_transaction

schema_and_data_statement_mixing_not_supported

no_active_sql_transaction

in_failed_sql_transaction

idle_in_transaction_session_timeout

Class 26 — Invalid SQL Statement Name

invalid_sql_statement_name

Class 27 — Triggered Data Change Violation

triggered_data_change_violation

Class 28 — Invalid Authorization Specification

invalid_authorization_specification

invalid_password

Class 2B — Dependent Privilege Descriptors Still Exist

dependent_privilege_descriptors_still_exist

dependent_objects_still_exist

Class 2D — Invalid Transaction Termination

invalid_transaction_termination

Class 2F — SQL Routine Exception

sql_routine_exception

function_executed_no_return_statement

modifying_sql_data_not_permitted

prohibited_sql_statement_attempted

reading_sql_data_not_permitted

Class 34 — Invalid Cursor Name

invalid_cursor_name

Class 38 — External Routine Exception

external_routine_exception

containing_sql_not_permitted

modifying_sql_data_not_permitted'

prohibited_sql_statement_attempted'

reading_sql_data_not_permitted'

Class 39 — External Routine Invocation Exception

external_routine_invocation_exception

invalid_sqlstate_returned

null_value_not_allowed'

trigger_protocol_violated

srf_protocol_violated

event_trigger_protocol_violated

Class 3B — Savepoint Exception

savepoint_exception

invalid_savepoint_specification

Class 3D — Invalid Catalog Name

invalid_catalog_name

Class 3F — Invalid Schema Name

invalid_schema_name

Class 40 — Transaction Rollback

transaction_rollback

transaction_integrity_constraint_violation

serialization_failure

statement_completion_unknown

deadlock_detected

Class 42 — Syntax Error or Access Rule Violation

syntax_error_or_access_rule_violation

syntax_error

insufficient_privilege

cannot_coerce

grouping_error

windowing_error

invalid_recursion

invalid_foreign_key

invalid_name

name_too_long

reserved_name

datatype_mismatch

indeterminate_datatype

collation_mismatch

indeterminate_collation

wrong_object_type

undefined_column

undefined_function

undefined_table

undefined_parameter

undefined_object

duplicate_column

duplicate_cursor

duplicate_database

duplicate_function

duplicate_prepared_statement

duplicate_schema

duplicate_table

duplicate_alias

duplicate_object

ambiguous_column

ambiguous_function

ambiguous_parameter

ambiguous_alias

invalid_column_reference

invalid_column_definition

invalid_cursor_definition

invalid_database_definition

invalid_function_definition

invalid_prepared_statement_definition

invalid_schema_definition

invalid_table_definition

invalid_object_definition

Class 44 — WITH CHECK OPTION Violation

with_check_option_violation

Class 53 — Insufficient Resources

insufficient_resources

disk_full

out_of_memory

too_many_connections

configuration_limit_exceeded

Class 54 — Program Limit Exceeded

program_limit_exceeded

statement_too_complex

too_many_columns

too_many_arguments

Class 55 — Object Not In Prerequisite State

object_not_in_prerequisite_state

object_in_use

cant_change_runtime_param

lock_not_available

Class 57 — Operator Intervention

operator_intervention

query_canceled

admin_shutdown

crash_shutdown

cannot_connect_now

database_dropped

Class 58 — System Error (errors external to PostgreSQL itself)

system_error

io_error

undefined_file

duplicate_file

Class 72 — Snapshot Failure

snapshot_too_old

Class F0 — Configuration File Error

config_file_error

lock_file_exists

Class HV — Foreign Data Wrapper Error (SQL/MED)

fdw_error

fdw_column_name_not_found

fdw_dynamic_parameter_value_needed

fdw_function_sequence_error

fdw_inconsistent_descriptor_information

fdw_invalid_attribute_value

fdw_invalid_column_name

fdw_invalid_column_number

fdw_invalid_data_type

fdw_invalid_data_type_descriptors

fdw_invalid_descriptor_field_identifier

fdw_invalid_handle

fdw_invalid_option_index

fdw_invalid_option_name

fdw_invalid_string_length_or_buffer_length

fdw_invalid_string_format

fdw_invalid_use_of_null_pointer

fdw_too_many_handles

fdw_out_of_memory

fdw_no_schemas

fdw_option_name_not_found

fdw_reply_handle

fdw_schema_not_found

fdw_table_not_found

fdw_unable_to_create_execution

fdw_unable_to_create_reply

fdw_unable_to_establish_connection

Class P0 — PL/pgSQL Error

plpgsql_error

raise_exception

no_data_found

too_many_rows

assert_failure

Class XX — Internal Error

internal_error

data_corrupted

index_corrupted