| Safe Haskell | Safe |
|---|---|
| Language | Haskell98 |
Database.PostgreSQL.Typed.ErrCodes
Contents
- Class 00 - Successful Completion
- Class 01 - Warning
- Class 02 - No Data (this is also a warning class per the SQL standard)
- Class 03 - SQL Statement Not Yet Complete
- Class 08 - Connection Exception
- Class 09 - Triggered Action Exception
- Class 0A - Feature Not Supported
- Class 0B - Invalid Transaction Initiation
- Class 0F - Locator Exception
- Class 0L - Invalid Grantor
- Class 0P - Invalid Role Specification
- Class 0Z - Diagnostics Exception
- Class 20 - Case Not Found
- Class 21 - Cardinality Violation
- Class 22 - Data Exception
- Class 23 - Integrity Constraint Violation
- Class 24 - Invalid Cursor State
- Class 25 - Invalid Transaction State
- Class 26 - Invalid SQL Statement Name
- Class 27 - Triggered Data Change Violation
- Class 28 - Invalid Authorization Specification
- Class 2B - Dependent Privilege Descriptors Still Exist
- Class 2D - Invalid Transaction Termination
- Class 2F - SQL Routine Exception
- Class 34 - Invalid Cursor Name
- Class 38 - External Routine Exception
- Class 39 - External Routine Invocation Exception
- Class 3B - Savepoint Exception
- Class 3D - Invalid Catalog Name
- Class 3F - Invalid Schema Name
- Class 40 - Transaction Rollback
- Class 42 - Syntax Error or Access Rule Violation
- Class 44 - WITH CHECK OPTION Violation
- Class 53 - Insufficient Resources
- Class 54 - Program Limit Exceeded
- Class 55 - Object Not In Prerequisite State
- Class 57 - Operator Intervention
- Class 58 - System Error (errors external to PostgreSQL itself)
- Class F0 - Configuration File Error
- Class HV - Foreign Data Wrapper Error (SQL/MED)
- Class P0 - PL/pgSQL Error
- Class XX - Internal Error
Description
PostgreSQL error codes.
- names :: Map ByteString String
- successful_completion :: ByteString
- warning :: ByteString
- warning_dynamic_result_sets_returned :: ByteString
- warning_implicit_zero_bit_padding :: ByteString
- warning_null_value_eliminated_in_set_function :: ByteString
- warning_privilege_not_granted :: ByteString
- warning_privilege_not_revoked :: ByteString
- warning_string_data_right_truncation :: ByteString
- warning_deprecated_feature :: ByteString
- no_data :: ByteString
- no_additional_dynamic_result_sets_returned :: ByteString
- sql_statement_not_yet_complete :: ByteString
- connection_exception :: ByteString
- connection_does_not_exist :: ByteString
- connection_failure :: ByteString
- sqlclient_unable_to_establish_sqlconnection :: ByteString
- sqlserver_rejected_establishment_of_sqlconnection :: ByteString
- transaction_resolution_unknown :: ByteString
- protocol_violation :: ByteString
- triggered_action_exception :: ByteString
- feature_not_supported :: ByteString
- invalid_transaction_initiation :: ByteString
- locator_exception :: ByteString
- invalid_locator_specification :: ByteString
- invalid_grantor :: ByteString
- invalid_grant_operation :: ByteString
- invalid_role_specification :: ByteString
- diagnostics_exception :: ByteString
- stacked_diagnostics_accessed_without_active_handler :: ByteString
- case_not_found :: ByteString
- cardinality_violation :: ByteString
- data_exception :: ByteString
- _ARRAY_ELEMENT_ERROR :: ByteString
- array_subscript_error :: ByteString
- character_not_in_repertoire :: ByteString
- datetime_field_overflow :: ByteString
- _DATETIME_VALUE_OUT_OF_RANGE :: ByteString
- division_by_zero :: ByteString
- error_in_assignment :: ByteString
- escape_character_conflict :: ByteString
- indicator_overflow :: ByteString
- interval_field_overflow :: ByteString
- invalid_argument_for_logarithm :: ByteString
- invalid_argument_for_ntile_function :: ByteString
- invalid_argument_for_nth_value_function :: ByteString
- invalid_argument_for_power_function :: ByteString
- invalid_argument_for_width_bucket_function :: ByteString
- invalid_character_value_for_cast :: ByteString
- invalid_datetime_format :: ByteString
- invalid_escape_character :: ByteString
- invalid_escape_octet :: ByteString
- invalid_escape_sequence :: ByteString
- nonstandard_use_of_escape_character :: ByteString
- invalid_indicator_parameter_value :: ByteString
- invalid_parameter_value :: ByteString
- invalid_regular_expression :: ByteString
- invalid_row_count_in_limit_clause :: ByteString
- invalid_row_count_in_result_offset_clause :: ByteString
- invalid_tablesample_argument :: ByteString
- invalid_tablesample_repeat :: ByteString
- invalid_time_zone_displacement_value :: ByteString
- invalid_use_of_escape_character :: ByteString
- most_specific_type_mismatch :: ByteString
- null_value_not_allowed :: ByteString
- null_value_no_indicator_parameter :: ByteString
- numeric_value_out_of_range :: ByteString
- string_data_length_mismatch :: ByteString
- string_data_right_truncation :: ByteString
- substring_error :: ByteString
- trim_error :: ByteString
- unterminated_c_string :: ByteString
- zero_length_character_string :: ByteString
- floating_point_exception :: ByteString
- invalid_text_representation :: ByteString
- invalid_binary_representation :: ByteString
- bad_copy_file_format :: ByteString
- untranslatable_character :: ByteString
- not_an_xml_document :: ByteString
- invalid_xml_document :: ByteString
- invalid_xml_content :: ByteString
- invalid_xml_comment :: ByteString
- invalid_xml_processing_instruction :: ByteString
- integrity_constraint_violation :: ByteString
- restrict_violation :: ByteString
- not_null_violation :: ByteString
- foreign_key_violation :: ByteString
- unique_violation :: ByteString
- check_violation :: ByteString
- exclusion_violation :: ByteString
- invalid_cursor_state :: ByteString
- invalid_transaction_state :: ByteString
- active_sql_transaction :: ByteString
- branch_transaction_already_active :: ByteString
- held_cursor_requires_same_isolation_level :: ByteString
- inappropriate_access_mode_for_branch_transaction :: ByteString
- inappropriate_isolation_level_for_branch_transaction :: ByteString
- no_active_sql_transaction_for_branch_transaction :: ByteString
- read_only_sql_transaction :: ByteString
- schema_and_data_statement_mixing_not_supported :: ByteString
- no_active_sql_transaction :: ByteString
- in_failed_sql_transaction :: ByteString
- invalid_sql_statement_name :: ByteString
- triggered_data_change_violation :: ByteString
- invalid_authorization_specification :: ByteString
- invalid_password :: ByteString
- dependent_privilege_descriptors_still_exist :: ByteString
- dependent_objects_still_exist :: ByteString
- invalid_transaction_termination :: ByteString
- sql_routine_exception :: ByteString
- s_r_e_function_executed_no_return_statement :: ByteString
- s_r_e_modifying_sql_data_not_permitted :: ByteString
- s_r_e_prohibited_sql_statement_attempted :: ByteString
- s_r_e_reading_sql_data_not_permitted :: ByteString
- invalid_cursor_name :: ByteString
- external_routine_exception :: ByteString
- e_r_e_containing_sql_not_permitted :: ByteString
- e_r_e_modifying_sql_data_not_permitted :: ByteString
- e_r_e_prohibited_sql_statement_attempted :: ByteString
- e_r_e_reading_sql_data_not_permitted :: ByteString
- external_routine_invocation_exception :: ByteString
- e_r_i_e_invalid_sqlstate_returned :: ByteString
- e_r_i_e_null_value_not_allowed :: ByteString
- e_r_i_e_trigger_protocol_violated :: ByteString
- e_r_i_e_srf_protocol_violated :: ByteString
- e_r_i_e_event_trigger_protocol_violated :: ByteString
- savepoint_exception :: ByteString
- invalid_savepoint_specification :: ByteString
- invalid_catalog_name :: ByteString
- invalid_schema_name :: ByteString
- transaction_rollback :: ByteString
- transaction_integrity_constraint_violation :: ByteString
- serialization_failure :: ByteString
- statement_completion_unknown :: ByteString
- deadlock_detected :: ByteString
- syntax_error_or_access_rule_violation :: ByteString
- syntax_error :: ByteString
- insufficient_privilege :: ByteString
- cannot_coerce :: ByteString
- grouping_error :: ByteString
- windowing_error :: ByteString
- invalid_recursion :: ByteString
- invalid_foreign_key :: ByteString
- invalid_name :: ByteString
- name_too_long :: ByteString
- reserved_name :: ByteString
- datatype_mismatch :: ByteString
- indeterminate_datatype :: ByteString
- collation_mismatch :: ByteString
- indeterminate_collation :: ByteString
- wrong_object_type :: ByteString
- undefined_column :: ByteString
- _UNDEFINED_CURSOR :: ByteString
- _UNDEFINED_DATABASE :: ByteString
- undefined_function :: ByteString
- _UNDEFINED_PSTATEMENT :: ByteString
- _UNDEFINED_SCHEMA :: ByteString
- undefined_table :: ByteString
- undefined_parameter :: ByteString
- undefined_object :: ByteString
- duplicate_column :: ByteString
- duplicate_cursor :: ByteString
- duplicate_database :: ByteString
- duplicate_function :: ByteString
- duplicate_prepared_statement :: ByteString
- duplicate_schema :: ByteString
- duplicate_table :: ByteString
- duplicate_alias :: ByteString
- duplicate_object :: ByteString
- ambiguous_column :: ByteString
- ambiguous_function :: ByteString
- ambiguous_parameter :: ByteString
- ambiguous_alias :: ByteString
- invalid_column_reference :: ByteString
- invalid_column_definition :: ByteString
- invalid_cursor_definition :: ByteString
- invalid_database_definition :: ByteString
- invalid_function_definition :: ByteString
- invalid_prepared_statement_definition :: ByteString
- invalid_schema_definition :: ByteString
- invalid_table_definition :: ByteString
- invalid_object_definition :: ByteString
- with_check_option_violation :: ByteString
- insufficient_resources :: ByteString
- disk_full :: ByteString
- out_of_memory :: ByteString
- too_many_connections :: ByteString
- configuration_limit_exceeded :: ByteString
- program_limit_exceeded :: ByteString
- statement_too_complex :: ByteString
- too_many_columns :: ByteString
- too_many_arguments :: ByteString
- object_not_in_prerequisite_state :: ByteString
- object_in_use :: ByteString
- cant_change_runtime_param :: ByteString
- lock_not_available :: ByteString
- operator_intervention :: ByteString
- query_canceled :: ByteString
- admin_shutdown :: ByteString
- crash_shutdown :: ByteString
- cannot_connect_now :: ByteString
- database_dropped :: ByteString
- system_error :: ByteString
- io_error :: ByteString
- undefined_file :: ByteString
- duplicate_file :: ByteString
- config_file_error :: ByteString
- lock_file_exists :: ByteString
- fdw_error :: ByteString
- fdw_column_name_not_found :: ByteString
- fdw_dynamic_parameter_value_needed :: ByteString
- fdw_function_sequence_error :: ByteString
- fdw_inconsistent_descriptor_information :: ByteString
- fdw_invalid_attribute_value :: ByteString
- fdw_invalid_column_name :: ByteString
- fdw_invalid_column_number :: ByteString
- fdw_invalid_data_type :: ByteString
- fdw_invalid_data_type_descriptors :: ByteString
- fdw_invalid_descriptor_field_identifier :: ByteString
- fdw_invalid_handle :: ByteString
- fdw_invalid_option_index :: ByteString
- fdw_invalid_option_name :: ByteString
- fdw_invalid_string_length_or_buffer_length :: ByteString
- fdw_invalid_string_format :: ByteString
- fdw_invalid_use_of_null_pointer :: ByteString
- fdw_too_many_handles :: ByteString
- fdw_out_of_memory :: ByteString
- fdw_no_schemas :: ByteString
- fdw_option_name_not_found :: ByteString
- fdw_reply_handle :: ByteString
- fdw_schema_not_found :: ByteString
- fdw_table_not_found :: ByteString
- fdw_unable_to_create_execution :: ByteString
- fdw_unable_to_create_reply :: ByteString
- fdw_unable_to_establish_connection :: ByteString
- plpgsql_error :: ByteString
- raise_exception :: ByteString
- no_data_found :: ByteString
- too_many_rows :: ByteString
- assert_failure :: ByteString
- internal_error :: ByteString
- data_corrupted :: ByteString
- index_corrupted :: ByteString
Documentation
names :: Map ByteString String #
All known error code names by code.
Class 00 - Successful Completion
successful_completion :: ByteString #
SUCCESSFUL_COMPLETION: 00000 (Success)
Class 01 - Warning
warning :: ByteString #
WARNING: 01000 (Warning)
warning_dynamic_result_sets_returned :: ByteString #
WARNING_DYNAMIC_RESULT_SETS_RETURNED: 0100C (Warning)
warning_implicit_zero_bit_padding :: ByteString #
WARNING_IMPLICIT_ZERO_BIT_PADDING: 01008 (Warning)
warning_null_value_eliminated_in_set_function :: ByteString #
WARNING_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION: 01003 (Warning)
warning_privilege_not_granted :: ByteString #
WARNING_PRIVILEGE_NOT_GRANTED: 01007 (Warning)
warning_privilege_not_revoked :: ByteString #
WARNING_PRIVILEGE_NOT_REVOKED: 01006 (Warning)
warning_string_data_right_truncation :: ByteString #
WARNING_STRING_DATA_RIGHT_TRUNCATION: 01004 (Warning)
warning_deprecated_feature :: ByteString #
WARNING_DEPRECATED_FEATURE: 01P01 (Warning)
Class 02 - No Data (this is also a warning class per the SQL standard)
no_data :: ByteString #
NO_DATA: 02000 (Warning)
no_additional_dynamic_result_sets_returned :: ByteString #
NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED: 02001 (Warning)
Class 03 - SQL Statement Not Yet Complete
sql_statement_not_yet_complete :: ByteString #
SQL_STATEMENT_NOT_YET_COMPLETE: 03000 (Error)
Class 08 - Connection Exception
connection_exception :: ByteString #
CONNECTION_EXCEPTION: 08000 (Error)
connection_does_not_exist :: ByteString #
CONNECTION_DOES_NOT_EXIST: 08003 (Error)
connection_failure :: ByteString #
CONNECTION_FAILURE: 08006 (Error)
sqlclient_unable_to_establish_sqlconnection :: ByteString #
SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION: 08001 (Error)
sqlserver_rejected_establishment_of_sqlconnection :: ByteString #
SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION: 08004 (Error)
transaction_resolution_unknown :: ByteString #
TRANSACTION_RESOLUTION_UNKNOWN: 08007 (Error)
protocol_violation :: ByteString #
PROTOCOL_VIOLATION: 08P01 (Error)
Class 09 - Triggered Action Exception
triggered_action_exception :: ByteString #
TRIGGERED_ACTION_EXCEPTION: 09000 (Error)
Class 0A - Feature Not Supported
feature_not_supported :: ByteString #
FEATURE_NOT_SUPPORTED: 0A000 (Error)
Class 0B - Invalid Transaction Initiation
invalid_transaction_initiation :: ByteString #
INVALID_TRANSACTION_INITIATION: 0B000 (Error)
Class 0F - Locator Exception
locator_exception :: ByteString #
LOCATOR_EXCEPTION: 0F000 (Error)
invalid_locator_specification :: ByteString #
L_E_INVALID_SPECIFICATION: 0F001 (Error)
Class 0L - Invalid Grantor
invalid_grantor :: ByteString #
INVALID_GRANTOR: 0L000 (Error)
invalid_grant_operation :: ByteString #
INVALID_GRANT_OPERATION: 0LP01 (Error)
Class 0P - Invalid Role Specification
invalid_role_specification :: ByteString #
INVALID_ROLE_SPECIFICATION: 0P000 (Error)
Class 0Z - Diagnostics Exception
diagnostics_exception :: ByteString #
DIAGNOSTICS_EXCEPTION: 0Z000 (Error)
stacked_diagnostics_accessed_without_active_handler :: ByteString #
STACKED_DIAGNOSTICS_ACCESSED_WITHOUT_ACTIVE_HANDLER: 0Z002 (Error)
Class 20 - Case Not Found
case_not_found :: ByteString #
CASE_NOT_FOUND: 20000 (Error)
Class 21 - Cardinality Violation
cardinality_violation :: ByteString #
CARDINALITY_VIOLATION: 21000 (Error)
Class 22 - Data Exception
data_exception :: ByteString #
DATA_EXCEPTION: 22000 (Error)
_ARRAY_ELEMENT_ERROR :: ByteString #
ARRAY_ELEMENT_ERROR: 2202E (Error)
array_subscript_error :: ByteString #
ARRAY_SUBSCRIPT_ERROR: 2202E (Error)
character_not_in_repertoire :: ByteString #
CHARACTER_NOT_IN_REPERTOIRE: 22021 (Error)
datetime_field_overflow :: ByteString #
DATETIME_FIELD_OVERFLOW: 22008 (Error)
_DATETIME_VALUE_OUT_OF_RANGE :: ByteString #
DATETIME_VALUE_OUT_OF_RANGE: 22008 (Error)
division_by_zero :: ByteString #
DIVISION_BY_ZERO: 22012 (Error)
error_in_assignment :: ByteString #
ERROR_IN_ASSIGNMENT: 22005 (Error)
escape_character_conflict :: ByteString #
ESCAPE_CHARACTER_CONFLICT: 2200B (Error)
indicator_overflow :: ByteString #
INDICATOR_OVERFLOW: 22022 (Error)
interval_field_overflow :: ByteString #
INTERVAL_FIELD_OVERFLOW: 22015 (Error)
invalid_argument_for_logarithm :: ByteString #
INVALID_ARGUMENT_FOR_LOG: 2201E (Error)
invalid_argument_for_ntile_function :: ByteString #
INVALID_ARGUMENT_FOR_NTILE: 22014 (Error)
invalid_argument_for_nth_value_function :: ByteString #
INVALID_ARGUMENT_FOR_NTH_VALUE: 22016 (Error)
invalid_argument_for_power_function :: ByteString #
INVALID_ARGUMENT_FOR_POWER_FUNCTION: 2201F (Error)
invalid_argument_for_width_bucket_function :: ByteString #
INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION: 2201G (Error)
invalid_character_value_for_cast :: ByteString #
INVALID_CHARACTER_VALUE_FOR_CAST: 22018 (Error)
invalid_datetime_format :: ByteString #
INVALID_DATETIME_FORMAT: 22007 (Error)
invalid_escape_character :: ByteString #
INVALID_ESCAPE_CHARACTER: 22019 (Error)
invalid_escape_octet :: ByteString #
INVALID_ESCAPE_OCTET: 2200D (Error)
invalid_escape_sequence :: ByteString #
INVALID_ESCAPE_SEQUENCE: 22025 (Error)
nonstandard_use_of_escape_character :: ByteString #
NONSTANDARD_USE_OF_ESCAPE_CHARACTER: 22P06 (Error)
invalid_indicator_parameter_value :: ByteString #
INVALID_INDICATOR_PARAMETER_VALUE: 22010 (Error)
invalid_parameter_value :: ByteString #
INVALID_PARAMETER_VALUE: 22023 (Error)
invalid_regular_expression :: ByteString #
INVALID_REGULAR_EXPRESSION: 2201B (Error)
invalid_row_count_in_limit_clause :: ByteString #
INVALID_ROW_COUNT_IN_LIMIT_CLAUSE: 2201W (Error)
invalid_row_count_in_result_offset_clause :: ByteString #
INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE: 2201X (Error)
invalid_tablesample_argument :: ByteString #
INVALID_TABLESAMPLE_ARGUMENT: 2202H (Error)
invalid_tablesample_repeat :: ByteString #
INVALID_TABLESAMPLE_REPEAT: 2202G (Error)
invalid_time_zone_displacement_value :: ByteString #
INVALID_TIME_ZONE_DISPLACEMENT_VALUE: 22009 (Error)
invalid_use_of_escape_character :: ByteString #
INVALID_USE_OF_ESCAPE_CHARACTER: 2200C (Error)
most_specific_type_mismatch :: ByteString #
MOST_SPECIFIC_TYPE_MISMATCH: 2200G (Error)
null_value_not_allowed :: ByteString #
NULL_VALUE_NOT_ALLOWED: 22004 (Error)
null_value_no_indicator_parameter :: ByteString #
NULL_VALUE_NO_INDICATOR_PARAMETER: 22002 (Error)
numeric_value_out_of_range :: ByteString #
NUMERIC_VALUE_OUT_OF_RANGE: 22003 (Error)
string_data_length_mismatch :: ByteString #
STRING_DATA_LENGTH_MISMATCH: 22026 (Error)
string_data_right_truncation :: ByteString #
STRING_DATA_RIGHT_TRUNCATION: 22001 (Error)
substring_error :: ByteString #
SUBSTRING_ERROR: 22011 (Error)
TRIM_ERROR: 22027 (Error)
unterminated_c_string :: ByteString #
UNTERMINATED_C_STRING: 22024 (Error)
zero_length_character_string :: ByteString #
ZERO_LENGTH_CHARACTER_STRING: 2200F (Error)
floating_point_exception :: ByteString #
FLOATING_POINT_EXCEPTION: 22P01 (Error)
invalid_text_representation :: ByteString #
INVALID_TEXT_REPRESENTATION: 22P02 (Error)
invalid_binary_representation :: ByteString #
INVALID_BINARY_REPRESENTATION: 22P03 (Error)
bad_copy_file_format :: ByteString #
BAD_COPY_FILE_FORMAT: 22P04 (Error)
untranslatable_character :: ByteString #
UNTRANSLATABLE_CHARACTER: 22P05 (Error)
not_an_xml_document :: ByteString #
NOT_AN_XML_DOCUMENT: 2200L (Error)
invalid_xml_document :: ByteString #
INVALID_XML_DOCUMENT: 2200M (Error)
invalid_xml_content :: ByteString #
INVALID_XML_CONTENT: 2200N (Error)
invalid_xml_comment :: ByteString #
INVALID_XML_COMMENT: 2200S (Error)
invalid_xml_processing_instruction :: ByteString #
INVALID_XML_PROCESSING_INSTRUCTION: 2200T (Error)
Class 23 - Integrity Constraint Violation
integrity_constraint_violation :: ByteString #
INTEGRITY_CONSTRAINT_VIOLATION: 23000 (Error)
restrict_violation :: ByteString #
RESTRICT_VIOLATION: 23001 (Error)
not_null_violation :: ByteString #
NOT_NULL_VIOLATION: 23502 (Error)
foreign_key_violation :: ByteString #
FOREIGN_KEY_VIOLATION: 23503 (Error)
unique_violation :: ByteString #
UNIQUE_VIOLATION: 23505 (Error)
check_violation :: ByteString #
CHECK_VIOLATION: 23514 (Error)
exclusion_violation :: ByteString #
EXCLUSION_VIOLATION: 23P01 (Error)
Class 24 - Invalid Cursor State
invalid_cursor_state :: ByteString #
INVALID_CURSOR_STATE: 24000 (Error)
Class 25 - Invalid Transaction State
invalid_transaction_state :: ByteString #
INVALID_TRANSACTION_STATE: 25000 (Error)
active_sql_transaction :: ByteString #
ACTIVE_SQL_TRANSACTION: 25001 (Error)
branch_transaction_already_active :: ByteString #
BRANCH_TRANSACTION_ALREADY_ACTIVE: 25002 (Error)
held_cursor_requires_same_isolation_level :: ByteString #
HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL: 25008 (Error)
inappropriate_access_mode_for_branch_transaction :: ByteString #
INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION: 25003 (Error)
inappropriate_isolation_level_for_branch_transaction :: ByteString #
INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION: 25004 (Error)
no_active_sql_transaction_for_branch_transaction :: ByteString #
NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION: 25005 (Error)
read_only_sql_transaction :: ByteString #
READ_ONLY_SQL_TRANSACTION: 25006 (Error)
schema_and_data_statement_mixing_not_supported :: ByteString #
SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED: 25007 (Error)
no_active_sql_transaction :: ByteString #
NO_ACTIVE_SQL_TRANSACTION: 25P01 (Error)
in_failed_sql_transaction :: ByteString #
IN_FAILED_SQL_TRANSACTION: 25P02 (Error)
Class 26 - Invalid SQL Statement Name
invalid_sql_statement_name :: ByteString #
INVALID_SQL_STATEMENT_NAME: 26000 (Error)
Class 27 - Triggered Data Change Violation
triggered_data_change_violation :: ByteString #
TRIGGERED_DATA_CHANGE_VIOLATION: 27000 (Error)
Class 28 - Invalid Authorization Specification
invalid_authorization_specification :: ByteString #
INVALID_AUTHORIZATION_SPECIFICATION: 28000 (Error)
invalid_password :: ByteString #
INVALID_PASSWORD: 28P01 (Error)
Class 2B - Dependent Privilege Descriptors Still Exist
dependent_privilege_descriptors_still_exist :: ByteString #
DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST: 2B000 (Error)
dependent_objects_still_exist :: ByteString #
DEPENDENT_OBJECTS_STILL_EXIST: 2BP01 (Error)
Class 2D - Invalid Transaction Termination
invalid_transaction_termination :: ByteString #
INVALID_TRANSACTION_TERMINATION: 2D000 (Error)
Class 2F - SQL Routine Exception
sql_routine_exception :: ByteString #
SQL_ROUTINE_EXCEPTION: 2F000 (Error)
s_r_e_function_executed_no_return_statement :: ByteString #
S_R_E_FUNCTION_EXECUTED_NO_RETURN_STATEMENT: 2F005 (Error)
s_r_e_modifying_sql_data_not_permitted :: ByteString #
S_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED: 2F002 (Error)
s_r_e_prohibited_sql_statement_attempted :: ByteString #
S_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED: 2F003 (Error)
s_r_e_reading_sql_data_not_permitted :: ByteString #
S_R_E_READING_SQL_DATA_NOT_PERMITTED: 2F004 (Error)
Class 34 - Invalid Cursor Name
invalid_cursor_name :: ByteString #
INVALID_CURSOR_NAME: 34000 (Error)
Class 38 - External Routine Exception
external_routine_exception :: ByteString #
EXTERNAL_ROUTINE_EXCEPTION: 38000 (Error)
e_r_e_containing_sql_not_permitted :: ByteString #
E_R_E_CONTAINING_SQL_NOT_PERMITTED: 38001 (Error)
e_r_e_modifying_sql_data_not_permitted :: ByteString #
E_R_E_MODIFYING_SQL_DATA_NOT_PERMITTED: 38002 (Error)
e_r_e_prohibited_sql_statement_attempted :: ByteString #
E_R_E_PROHIBITED_SQL_STATEMENT_ATTEMPTED: 38003 (Error)
e_r_e_reading_sql_data_not_permitted :: ByteString #
E_R_E_READING_SQL_DATA_NOT_PERMITTED: 38004 (Error)
Class 39 - External Routine Invocation Exception
external_routine_invocation_exception :: ByteString #
EXTERNAL_ROUTINE_INVOCATION_EXCEPTION: 39000 (Error)
e_r_i_e_invalid_sqlstate_returned :: ByteString #
E_R_I_E_INVALID_SQLSTATE_RETURNED: 39001 (Error)
e_r_i_e_null_value_not_allowed :: ByteString #
E_R_I_E_NULL_VALUE_NOT_ALLOWED: 39004 (Error)
e_r_i_e_trigger_protocol_violated :: ByteString #
E_R_I_E_TRIGGER_PROTOCOL_VIOLATED: 39P01 (Error)
e_r_i_e_srf_protocol_violated :: ByteString #
E_R_I_E_SRF_PROTOCOL_VIOLATED: 39P02 (Error)
e_r_i_e_event_trigger_protocol_violated :: ByteString #
E_R_I_E_EVENT_TRIGGER_PROTOCOL_VIOLATED: 39P03 (Error)
Class 3B - Savepoint Exception
savepoint_exception :: ByteString #
SAVEPOINT_EXCEPTION: 3B000 (Error)
invalid_savepoint_specification :: ByteString #
S_E_INVALID_SPECIFICATION: 3B001 (Error)
Class 3D - Invalid Catalog Name
invalid_catalog_name :: ByteString #
INVALID_CATALOG_NAME: 3D000 (Error)
Class 3F - Invalid Schema Name
invalid_schema_name :: ByteString #
INVALID_SCHEMA_NAME: 3F000 (Error)
Class 40 - Transaction Rollback
transaction_rollback :: ByteString #
TRANSACTION_ROLLBACK: 40000 (Error)
transaction_integrity_constraint_violation :: ByteString #
T_R_INTEGRITY_CONSTRAINT_VIOLATION: 40002 (Error)
serialization_failure :: ByteString #
T_R_SERIALIZATION_FAILURE: 40001 (Error)
statement_completion_unknown :: ByteString #
T_R_STATEMENT_COMPLETION_UNKNOWN: 40003 (Error)
deadlock_detected :: ByteString #
T_R_DEADLOCK_DETECTED: 40P01 (Error)
Class 42 - Syntax Error or Access Rule Violation
syntax_error_or_access_rule_violation :: ByteString #
SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION: 42000 (Error)
SYNTAX_ERROR: 42601 (Error)
insufficient_privilege :: ByteString #
INSUFFICIENT_PRIVILEGE: 42501 (Error)
CANNOT_COERCE: 42846 (Error)
grouping_error :: ByteString #
GROUPING_ERROR: 42803 (Error)
windowing_error :: ByteString #
WINDOWING_ERROR: 42P20 (Error)
invalid_recursion :: ByteString #
INVALID_RECURSION: 42P19 (Error)
invalid_foreign_key :: ByteString #
INVALID_FOREIGN_KEY: 42830 (Error)
INVALID_NAME: 42602 (Error)
NAME_TOO_LONG: 42622 (Error)
RESERVED_NAME: 42939 (Error)
datatype_mismatch :: ByteString #
DATATYPE_MISMATCH: 42804 (Error)
indeterminate_datatype :: ByteString #
INDETERMINATE_DATATYPE: 42P18 (Error)
collation_mismatch :: ByteString #
COLLATION_MISMATCH: 42P21 (Error)
indeterminate_collation :: ByteString #
INDETERMINATE_COLLATION: 42P22 (Error)
wrong_object_type :: ByteString #
WRONG_OBJECT_TYPE: 42809 (Error)
undefined_column :: ByteString #
UNDEFINED_COLUMN: 42703 (Error)
_UNDEFINED_CURSOR :: ByteString #
UNDEFINED_CURSOR: 34000 (Error)
_UNDEFINED_DATABASE :: ByteString #
UNDEFINED_DATABASE: 3D000 (Error)
undefined_function :: ByteString #
UNDEFINED_FUNCTION: 42883 (Error)
_UNDEFINED_PSTATEMENT :: ByteString #
UNDEFINED_PSTATEMENT: 26000 (Error)
_UNDEFINED_SCHEMA :: ByteString #
UNDEFINED_SCHEMA: 3F000 (Error)
undefined_table :: ByteString #
UNDEFINED_TABLE: 42P01 (Error)
undefined_parameter :: ByteString #
UNDEFINED_PARAMETER: 42P02 (Error)
undefined_object :: ByteString #
UNDEFINED_OBJECT: 42704 (Error)
duplicate_column :: ByteString #
DUPLICATE_COLUMN: 42701 (Error)
duplicate_cursor :: ByteString #
DUPLICATE_CURSOR: 42P03 (Error)
duplicate_database :: ByteString #
DUPLICATE_DATABASE: 42P04 (Error)
duplicate_function :: ByteString #
DUPLICATE_FUNCTION: 42723 (Error)
duplicate_prepared_statement :: ByteString #
DUPLICATE_PSTATEMENT: 42P05 (Error)
duplicate_schema :: ByteString #
DUPLICATE_SCHEMA: 42P06 (Error)
duplicate_table :: ByteString #
DUPLICATE_TABLE: 42P07 (Error)
duplicate_alias :: ByteString #
DUPLICATE_ALIAS: 42712 (Error)
duplicate_object :: ByteString #
DUPLICATE_OBJECT: 42710 (Error)
ambiguous_column :: ByteString #
AMBIGUOUS_COLUMN: 42702 (Error)
ambiguous_function :: ByteString #
AMBIGUOUS_FUNCTION: 42725 (Error)
ambiguous_parameter :: ByteString #
AMBIGUOUS_PARAMETER: 42P08 (Error)
ambiguous_alias :: ByteString #
AMBIGUOUS_ALIAS: 42P09 (Error)
invalid_column_reference :: ByteString #
INVALID_COLUMN_REFERENCE: 42P10 (Error)
invalid_column_definition :: ByteString #
INVALID_COLUMN_DEFINITION: 42611 (Error)
invalid_cursor_definition :: ByteString #
INVALID_CURSOR_DEFINITION: 42P11 (Error)
invalid_database_definition :: ByteString #
INVALID_DATABASE_DEFINITION: 42P12 (Error)
invalid_function_definition :: ByteString #
INVALID_FUNCTION_DEFINITION: 42P13 (Error)
invalid_prepared_statement_definition :: ByteString #
INVALID_PSTATEMENT_DEFINITION: 42P14 (Error)
invalid_schema_definition :: ByteString #
INVALID_SCHEMA_DEFINITION: 42P15 (Error)
invalid_table_definition :: ByteString #
INVALID_TABLE_DEFINITION: 42P16 (Error)
invalid_object_definition :: ByteString #
INVALID_OBJECT_DEFINITION: 42P17 (Error)
Class 44 - WITH CHECK OPTION Violation
with_check_option_violation :: ByteString #
WITH_CHECK_OPTION_VIOLATION: 44000 (Error)
Class 53 - Insufficient Resources
insufficient_resources :: ByteString #
INSUFFICIENT_RESOURCES: 53000 (Error)
disk_full :: ByteString #
DISK_FULL: 53100 (Error)
OUT_OF_MEMORY: 53200 (Error)
too_many_connections :: ByteString #
TOO_MANY_CONNECTIONS: 53300 (Error)
configuration_limit_exceeded :: ByteString #
CONFIGURATION_LIMIT_EXCEEDED: 53400 (Error)
Class 54 - Program Limit Exceeded
program_limit_exceeded :: ByteString #
PROGRAM_LIMIT_EXCEEDED: 54000 (Error)
statement_too_complex :: ByteString #
STATEMENT_TOO_COMPLEX: 54001 (Error)
too_many_columns :: ByteString #
TOO_MANY_COLUMNS: 54011 (Error)
too_many_arguments :: ByteString #
TOO_MANY_ARGUMENTS: 54023 (Error)
Class 55 - Object Not In Prerequisite State
object_not_in_prerequisite_state :: ByteString #
OBJECT_NOT_IN_PREREQUISITE_STATE: 55000 (Error)
OBJECT_IN_USE: 55006 (Error)
cant_change_runtime_param :: ByteString #
CANT_CHANGE_RUNTIME_PARAM: 55P02 (Error)
lock_not_available :: ByteString #
LOCK_NOT_AVAILABLE: 55P03 (Error)
Class 57 - Operator Intervention
operator_intervention :: ByteString #
OPERATOR_INTERVENTION: 57000 (Error)
query_canceled :: ByteString #
QUERY_CANCELED: 57014 (Error)
admin_shutdown :: ByteString #
ADMIN_SHUTDOWN: 57P01 (Error)
crash_shutdown :: ByteString #
CRASH_SHUTDOWN: 57P02 (Error)
cannot_connect_now :: ByteString #
CANNOT_CONNECT_NOW: 57P03 (Error)
database_dropped :: ByteString #
DATABASE_DROPPED: 57P04 (Error)
Class 58 - System Error (errors external to PostgreSQL itself)
SYSTEM_ERROR: 58000 (Error)
io_error :: ByteString #
IO_ERROR: 58030 (Error)
undefined_file :: ByteString #
UNDEFINED_FILE: 58P01 (Error)
duplicate_file :: ByteString #
DUPLICATE_FILE: 58P02 (Error)
Class F0 - Configuration File Error
config_file_error :: ByteString #
CONFIG_FILE_ERROR: F0000 (Error)
lock_file_exists :: ByteString #
LOCK_FILE_EXISTS: F0001 (Error)
Class HV - Foreign Data Wrapper Error (SQL/MED)
fdw_error :: ByteString #
FDW_ERROR: HV000 (Error)
fdw_column_name_not_found :: ByteString #
FDW_COLUMN_NAME_NOT_FOUND: HV005 (Error)
fdw_dynamic_parameter_value_needed :: ByteString #
FDW_DYNAMIC_PARAMETER_VALUE_NEEDED: HV002 (Error)
fdw_function_sequence_error :: ByteString #
FDW_FUNCTION_SEQUENCE_ERROR: HV010 (Error)
fdw_inconsistent_descriptor_information :: ByteString #
FDW_INCONSISTENT_DESCRIPTOR_INFORMATION: HV021 (Error)
fdw_invalid_attribute_value :: ByteString #
FDW_INVALID_ATTRIBUTE_VALUE: HV024 (Error)
fdw_invalid_column_name :: ByteString #
FDW_INVALID_COLUMN_NAME: HV007 (Error)
fdw_invalid_column_number :: ByteString #
FDW_INVALID_COLUMN_NUMBER: HV008 (Error)
fdw_invalid_data_type :: ByteString #
FDW_INVALID_DATA_TYPE: HV004 (Error)
fdw_invalid_data_type_descriptors :: ByteString #
FDW_INVALID_DATA_TYPE_DESCRIPTORS: HV006 (Error)
fdw_invalid_descriptor_field_identifier :: ByteString #
FDW_INVALID_DESCRIPTOR_FIELD_IDENTIFIER: HV091 (Error)
fdw_invalid_handle :: ByteString #
FDW_INVALID_HANDLE: HV00B (Error)
fdw_invalid_option_index :: ByteString #
FDW_INVALID_OPTION_INDEX: HV00C (Error)
fdw_invalid_option_name :: ByteString #
FDW_INVALID_OPTION_NAME: HV00D (Error)
fdw_invalid_string_length_or_buffer_length :: ByteString #
FDW_INVALID_STRING_LENGTH_OR_BUFFER_LENGTH: HV090 (Error)
fdw_invalid_string_format :: ByteString #
FDW_INVALID_STRING_FORMAT: HV00A (Error)
fdw_invalid_use_of_null_pointer :: ByteString #
FDW_INVALID_USE_OF_NULL_POINTER: HV009 (Error)
fdw_too_many_handles :: ByteString #
FDW_TOO_MANY_HANDLES: HV014 (Error)
fdw_out_of_memory :: ByteString #
FDW_OUT_OF_MEMORY: HV001 (Error)
fdw_no_schemas :: ByteString #
FDW_NO_SCHEMAS: HV00P (Error)
fdw_option_name_not_found :: ByteString #
FDW_OPTION_NAME_NOT_FOUND: HV00J (Error)
fdw_reply_handle :: ByteString #
FDW_REPLY_HANDLE: HV00K (Error)
fdw_schema_not_found :: ByteString #
FDW_SCHEMA_NOT_FOUND: HV00Q (Error)
fdw_table_not_found :: ByteString #
FDW_TABLE_NOT_FOUND: HV00R (Error)
fdw_unable_to_create_execution :: ByteString #
FDW_UNABLE_TO_CREATE_EXECUTION: HV00L (Error)
fdw_unable_to_create_reply :: ByteString #
FDW_UNABLE_TO_CREATE_REPLY: HV00M (Error)
fdw_unable_to_establish_connection :: ByteString #
FDW_UNABLE_TO_ESTABLISH_CONNECTION: HV00N (Error)
Class P0 - PL/pgSQL Error
PLPGSQL_ERROR: P0000 (Error)
raise_exception :: ByteString #
RAISE_EXCEPTION: P0001 (Error)
NO_DATA_FOUND: P0002 (Error)
TOO_MANY_ROWS: P0003 (Error)
assert_failure :: ByteString #
ASSERT_FAILURE: P0004 (Error)
Class XX - Internal Error
internal_error :: ByteString #
INTERNAL_ERROR: XX000 (Error)
data_corrupted :: ByteString #
DATA_CORRUPTED: XX001 (Error)
index_corrupted :: ByteString #
INDEX_CORRUPTED: XX002 (Error)