PostgreSQL.ErrorCodes

Error codes as per https://www.postgresql.org/docs/9.6/static/errcodes-appendix.html.

Documentation

type ErrorCode = ByteString

Class 00 — Successful Completion

successful_completion :: ErrorCode

Code "00000".

Class 01 — Warning

warning :: ErrorCode

Code "01000".

dynamic_result_sets_returned :: ErrorCode

Code "0100C".

implicit_zero_bit_padding :: ErrorCode

Code "01008".

null_value_eliminated_in_set_function :: ErrorCode

Code "01003".

privilege_not_granted :: ErrorCode

Code "01007".

privilege_not_revoked :: ErrorCode

Code "01006".

string_data_right_truncation :: ErrorCode

Code "01004".

deprecated_feature :: ErrorCode

Code "01P01".

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

no_data :: ErrorCode

Code "02000".

no_additional_dynamic_result_sets_returned :: ErrorCode

Code "02001".

Class 03 — SQL Statement Not Yet Complete

sql_statement_not_yet_complete :: ErrorCode

Code "03000".

Class 08 — Connection Exception

connection_exception :: ErrorCode

Code "08000".

connection_does_not_exist :: ErrorCode

Code "08003".

connection_failure :: ErrorCode

Code "08006".

sqlclient_unable_to_establish_sqlconnection :: ErrorCode

Code "08001".

sqlserver_rejected_establishment_of_sqlconnection :: ErrorCode

Code "08004".

transaction_resolution_unknown :: ErrorCode

Code "08007".

protocol_violation :: ErrorCode

Code "08P01".

Class 09 — Triggered Action Exception

triggered_action_exception :: ErrorCode

Code "09000".

Class 0A — Feature Not Supported

feature_not_supported :: ErrorCode

Code "0A000".

Class 0B — Invalid Transaction Initiation

invalid_transaction_initiation :: ErrorCode

Code "0B000".

Class 0F — Locator Exception

locator_exception :: ErrorCode

Code "0F000".

invalid_locator_specification :: ErrorCode

Code "0F001".

Class 0L — Invalid Grantor

invalid_grantor :: ErrorCode

Code "0L000".

invalid_grant_operation :: ErrorCode

Code "0LP01".

Class 0P — Invalid Role Specification

invalid_role_specification :: ErrorCode

Code "0P000".

Class 0Z — Diagnostics Exception

diagnostics_exception :: ErrorCode

Code "0Z000".

stacked_diagnostics_accessed_without_active_handler :: ErrorCode

Code "0Z002".

Class 20 — Case Not Found

case_not_found :: ErrorCode

Code "20000".

Class 21 — Cardinality Violation

cardinality_violation :: ErrorCode

Code "21000".

Class 22 — Data Exception

data_exception :: ErrorCode

Code "22000".

array_subscript_error :: ErrorCode

Code "2202E".

character_not_in_repertoire :: ErrorCode

Code "22021".

datetime_field_overflow :: ErrorCode

Code "22008".

division_by_zero :: ErrorCode

Code "22012".

error_in_assignment :: ErrorCode

Code "22005".

escape_character_conflict :: ErrorCode

Code "2200B".

indicator_overflow :: ErrorCode

Code "22022".

interval_field_overflow :: ErrorCode

Code "22015".

invalid_argument_for_logarithm :: ErrorCode

Code "2201E".

invalid_argument_for_ntile_function :: ErrorCode

Code "22014".

invalid_argument_for_nth_value_function :: ErrorCode

Code "22016".

invalid_argument_for_power_function :: ErrorCode

Code "2201F".

invalid_argument_for_width_bucket_function :: ErrorCode

Code "2201G".

invalid_character_value_for_cast :: ErrorCode

Code "22018".

invalid_datetime_format :: ErrorCode

Code "22007".

invalid_escape_character :: ErrorCode

Code "22019".

invalid_escape_octet :: ErrorCode

Code "2200D".

invalid_escape_sequence :: ErrorCode

Code "22025".

nonstandard_use_of_escape_character :: ErrorCode

Code "22P06".

invalid_indicator_parameter_value :: ErrorCode

Code "22010".

invalid_parameter_value :: ErrorCode

Code "22023".

invalid_regular_expression :: ErrorCode

Code "2201B".

invalid_row_count_in_limit_clause :: ErrorCode

Code "2201W".

invalid_row_count_in_result_offset_clause :: ErrorCode

Code "2201X".

invalid_tablesample_argument :: ErrorCode

Code "2202H".

invalid_tablesample_repeat :: ErrorCode

Code "2202G".

invalid_time_zone_displacement_value :: ErrorCode

Code "22009".

invalid_use_of_escape_character :: ErrorCode

Code "2200C".

most_specific_type_mismatch :: ErrorCode

Code "2200G".

null_value_not_allowed :: ErrorCode

Code "22004".

null_value_no_indicator_parameter :: ErrorCode

Code "22002".

numeric_value_out_of_range :: ErrorCode

Code "22003".

string_data_length_mismatch :: ErrorCode

Code "22026".

string_data_right_truncation' :: ErrorCode

Code "22001".

substring_error :: ErrorCode

Code "22011".

trim_error :: ErrorCode

Code "22027".

unterminated_c_string :: ErrorCode

Code "22024".

zero_length_character_string :: ErrorCode

Code "2200F".

floating_point_exception :: ErrorCode

Code "22P01".

invalid_text_representation :: ErrorCode

Code "22P02".

invalid_binary_representation :: ErrorCode

Code "22P03".

bad_copy_file_format :: ErrorCode

Code "22P04".

untranslatable_character :: ErrorCode

Code "22P05".

not_an_xml_document :: ErrorCode

Code "2200L".

invalid_xml_document :: ErrorCode

Code "2200M".

invalid_xml_content :: ErrorCode

Code "2200N".

invalid_xml_comment :: ErrorCode

Code "2200S".

invalid_xml_processing_instruction :: ErrorCode

Code "2200T".

Class 23 — Integrity Constraint Violation

integrity_constraint_violation :: ErrorCode

Code "23000".

restrict_violation :: ErrorCode

Code "23001".

not_null_violation :: ErrorCode

Code "23502".

foreign_key_violation :: ErrorCode

Code "23503".

unique_violation :: ErrorCode

Code "23505".

check_violation :: ErrorCode

Code "23514".

exclusion_violation :: ErrorCode

Code "23P01".

Class 24 — Invalid Cursor State

invalid_cursor_state :: ErrorCode

Code "24000".

Class 25 — Invalid Transaction State

invalid_transaction_state :: ErrorCode

Code "25000".

active_sql_transaction :: ErrorCode

Code "25001".

branch_transaction_already_active :: ErrorCode

Code "25002".

held_cursor_requires_same_isolation_level :: ErrorCode

Code "25008".

inappropriate_access_mode_for_branch_transaction :: ErrorCode

Code "25003".

inappropriate_isolation_level_for_branch_transaction :: ErrorCode

Code "25004".

no_active_sql_transaction_for_branch_transaction :: ErrorCode

Code "25005".

read_only_sql_transaction :: ErrorCode

Code "25006".

schema_and_data_statement_mixing_not_supported :: ErrorCode

Code "25007".

no_active_sql_transaction :: ErrorCode

Code "25P01".

in_failed_sql_transaction :: ErrorCode

Code "25P02".

idle_in_transaction_session_timeout :: ErrorCode

Code "25PO3".

Class 26 — Invalid SQL Statement Name

invalid_sql_statement_name :: ErrorCode

Code "26000".

Class 27 — Triggered Data Change Violation

triggered_data_change_violation :: ErrorCode

Code "27000".

Class 28 — Invalid Authorization Specification

invalid_authorization_specification :: ErrorCode

Code "28000".

invalid_password :: ErrorCode

Code "28P01".

Class 2B — Dependent Privilege Descriptors Still Exist

dependent_privilege_descriptors_still_exist :: ErrorCode

Code "2B000".

dependent_objects_still_exist :: ErrorCode

Code "2BP01".

Class 2D — Invalid Transaction Termination

invalid_transaction_termination :: ErrorCode

Code "2D000".

Class 2F — SQL Routine Exception

sql_routine_exception :: ErrorCode

Code "2F000".

function_executed_no_return_statement :: ErrorCode

Code "2F005".

modifying_sql_data_not_permitted :: ErrorCode

Code "2F002".

prohibited_sql_statement_attempted :: ErrorCode

Code "2F003".

reading_sql_data_not_permitted :: ErrorCode

Code "2F004".

Class 34 — Invalid Cursor Name

invalid_cursor_name :: ErrorCode

Code "34000".

Class 38 — External Routine Exception

external_routine_exception :: ErrorCode

Code "38000".

containing_sql_not_permitted :: ErrorCode

Code "38001".

modifying_sql_data_not_permitted' :: ErrorCode

Code "38002".

prohibited_sql_statement_attempted' :: ErrorCode

Code "38003".

reading_sql_data_not_permitted' :: ErrorCode

Code "38004".

Class 39 — External Routine Invocation Exception

external_routine_invocation_exception :: ErrorCode

Code "39000".

invalid_sqlstate_returned :: ErrorCode

Code "39001".

null_value_not_allowed' :: ErrorCode

Code "39004".

trigger_protocol_violated :: ErrorCode

Code "39P01".

srf_protocol_violated :: ErrorCode

Code "39P02".

event_trigger_protocol_violated :: ErrorCode

Code "39PO3".

Class 3B — Savepoint Exception

savepoint_exception :: ErrorCode

Code "3B000".

invalid_savepoint_specification :: ErrorCode

Code "3B001".

Class 3D — Invalid Catalog Name

invalid_catalog_name :: ErrorCode

Code "3D000".

Class 3F — Invalid Schema Name

invalid_schema_name :: ErrorCode

Code "3F000".

Class 40 — Transaction Rollback

transaction_rollback :: ErrorCode

Code "40000".

transaction_integrity_constraint_violation :: ErrorCode

Code "40002".

serialization_failure :: ErrorCode

Code "40001".

statement_completion_unknown :: ErrorCode

Code "40003".

deadlock_detected :: ErrorCode

Code "40P01".

Class 42 — Syntax Error or Access Rule Violation

syntax_error_or_access_rule_violation :: ErrorCode

Code "42000".

syntax_error :: ErrorCode

Code "42601".

insufficient_privilege :: ErrorCode

Code "42501".

cannot_coerce :: ErrorCode

Code "42846".

grouping_error :: ErrorCode

Code "42803".

windowing_error :: ErrorCode

Code "42P20".

invalid_recursion :: ErrorCode

Code "42P19".

invalid_foreign_key :: ErrorCode

Code "42830".

invalid_name :: ErrorCode

Code "42602".

name_too_long :: ErrorCode

Code "42622".

reserved_name :: ErrorCode

Code "42939".

datatype_mismatch :: ErrorCode

Code "42804".

indeterminate_datatype :: ErrorCode

Code "42P18".

collation_mismatch :: ErrorCode

Code "42P21".

indeterminate_collation :: ErrorCode

Code "42P22".

wrong_object_type :: ErrorCode

Code "42809".

undefined_column :: ErrorCode

Code "42703".

undefined_function :: ErrorCode

Code "42883".

undefined_table :: ErrorCode

Code "42P01".

undefined_parameter :: ErrorCode

Code "42P02".

undefined_object :: ErrorCode

Code "42704".

duplicate_column :: ErrorCode

Code "42701".

duplicate_cursor :: ErrorCode

Code "42P03".

duplicate_database :: ErrorCode

Code "42P04".

duplicate_function :: ErrorCode

Code "42723".

duplicate_prepared_statement :: ErrorCode

Code "42P05".

duplicate_schema :: ErrorCode

Code "42P06".

duplicate_table :: ErrorCode

Code "42P07".

duplicate_alias :: ErrorCode

Code "42712".

duplicate_object :: ErrorCode

Code "42710".

ambiguous_column :: ErrorCode

Code "42702".

ambiguous_function :: ErrorCode

Code "42725".

ambiguous_parameter :: ErrorCode

Code "42P08".

ambiguous_alias :: ErrorCode

Code "42P09".

invalid_column_reference :: ErrorCode

Code "42P10".

invalid_column_definition :: ErrorCode

Code "42611".

invalid_cursor_definition :: ErrorCode

Code "42P11".

invalid_database_definition :: ErrorCode

Code "42P12".

invalid_function_definition :: ErrorCode

Code "42P13".

invalid_prepared_statement_definition :: ErrorCode

Code "42P14".

invalid_schema_definition :: ErrorCode

Code "42P15".

invalid_table_definition :: ErrorCode

Code "42P16".

invalid_object_definition :: ErrorCode

Code "42P17".

Class 44 — WITH CHECK OPTION Violation

with_check_option_violation :: ErrorCode

Code "44000".

Class 53 — Insufficient Resources

insufficient_resources :: ErrorCode

Code "53000".

disk_full :: ErrorCode

Code "53100".

out_of_memory :: ErrorCode

Code "53200".

too_many_connections :: ErrorCode

Code "53300".

configuration_limit_exceeded :: ErrorCode

Code "53400".

Class 54 — Program Limit Exceeded

program_limit_exceeded :: ErrorCode

Code "54000".

statement_too_complex :: ErrorCode

Code "54001".

too_many_columns :: ErrorCode

Code "54011".

too_many_arguments :: ErrorCode

Code "54023".

Class 55 — Object Not In Prerequisite State

object_not_in_prerequisite_state :: ErrorCode

Code "55000".

object_in_use :: ErrorCode

Code "55006".

cant_change_runtime_param :: ErrorCode

Code "55P02".

lock_not_available :: ErrorCode

Code "55P03".

Class 57 — Operator Intervention

operator_intervention :: ErrorCode

Code "57000".

query_canceled :: ErrorCode

Code "57014".

admin_shutdown :: ErrorCode

Code "57P01".

crash_shutdown :: ErrorCode

Code "57P02".

cannot_connect_now :: ErrorCode

Code "57P03".

database_dropped :: ErrorCode

Code "57P04".

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

system_error :: ErrorCode

Code "58000".

io_error :: ErrorCode

Code "58030".

undefined_file :: ErrorCode

Code "58P01".

duplicate_file :: ErrorCode

Code "58P02".

Class 72 — Snapshot Failure

snapshot_too_old :: ErrorCode

Code "72000".

Class F0 — Configuration File Error

config_file_error :: ErrorCode

Code "F0000".

lock_file_exists :: ErrorCode

Code "F0001".

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

fdw_error :: ErrorCode

Code "HV000".

fdw_column_name_not_found :: ErrorCode

Code "HV005".

fdw_dynamic_parameter_value_needed :: ErrorCode

Code "HV002".

fdw_function_sequence_error :: ErrorCode

Code "HV010".

fdw_inconsistent_descriptor_information :: ErrorCode

Code "HV021".

fdw_invalid_attribute_value :: ErrorCode

Code "HV024".

fdw_invalid_column_name :: ErrorCode

Code "HV007".

fdw_invalid_column_number :: ErrorCode

Code "HV008".

fdw_invalid_data_type :: ErrorCode

Code "HV004".

fdw_invalid_data_type_descriptors :: ErrorCode

Code "HV006".

fdw_invalid_descriptor_field_identifier :: ErrorCode

Code "HV091".

fdw_invalid_handle :: ErrorCode

Code "HV00B".

fdw_invalid_option_index :: ErrorCode

Code "HV00C".

fdw_invalid_option_name :: ErrorCode

Code "HV00D".

fdw_invalid_string_length_or_buffer_length :: ErrorCode

Code "HV090".

fdw_invalid_string_format :: ErrorCode

Code "HV00A".

fdw_invalid_use_of_null_pointer :: ErrorCode

Code "HV009".

fdw_too_many_handles :: ErrorCode

Code "HV014".

fdw_out_of_memory :: ErrorCode

Code "HV001".

fdw_no_schemas :: ErrorCode

Code "HV00P".

fdw_option_name_not_found :: ErrorCode

Code "HV00J".

fdw_reply_handle :: ErrorCode

Code "HV00K".

fdw_schema_not_found :: ErrorCode

Code "HV00Q".

fdw_table_not_found :: ErrorCode

Code "HV00R".

fdw_unable_to_create_execution :: ErrorCode

Code "HV00L".

fdw_unable_to_create_reply :: ErrorCode

Code "HV00M".

fdw_unable_to_establish_connection :: ErrorCode

Code "HV00N".

Class P0 — PL/pgSQL Error

plpgsql_error :: ErrorCode

Code "P0000".

raise_exception :: ErrorCode

Code "P0001".

no_data_found :: ErrorCode

Code "P0002".

too_many_rows :: ErrorCode

Code "P0003".

assert_failure :: ErrorCode

Code "POOO4".

Class XX — Internal Error

internal_error :: ErrorCode

Code "XX000".

data_corrupted :: ErrorCode

Code "XX001".

index_corrupted :: ErrorCode

Code "XX002".