Database.PostgreSQL.Typed.ErrCodes

names

Class 00 - Successful Completion

successful_completion

Class 01 - Warning

warning

warning_dynamic_result_sets_returned

warning_implicit_zero_bit_padding

warning_null_value_eliminated_in_set_function

warning_privilege_not_granted

warning_privilege_not_revoked

warning_string_data_right_truncation

warning_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_ELEMENT_ERROR

array_subscript_error

character_not_in_repertoire

datetime_field_overflow

_DATETIME_VALUE_OUT_OF_RANGE

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

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

s_r_e_function_executed_no_return_statement

s_r_e_modifying_sql_data_not_permitted

s_r_e_prohibited_sql_statement_attempted

s_r_e_reading_sql_data_not_permitted

Class 34 - Invalid Cursor Name

invalid_cursor_name

Class 38 - External Routine Exception

external_routine_exception

e_r_e_containing_sql_not_permitted

e_r_e_modifying_sql_data_not_permitted

e_r_e_prohibited_sql_statement_attempted

e_r_e_reading_sql_data_not_permitted

Class 39 - External Routine Invocation Exception

external_routine_invocation_exception

e_r_i_e_invalid_sqlstate_returned

e_r_i_e_null_value_not_allowed

e_r_i_e_trigger_protocol_violated

e_r_i_e_srf_protocol_violated

e_r_i_e_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_CURSOR

_UNDEFINED_DATABASE

undefined_function

_UNDEFINED_PSTATEMENT

_UNDEFINED_SCHEMA

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 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