Class 00 — Successful Completion | |
| |
| |
| |
| dynamic_result_sets_returned
|
| implicit_zero_bit_padding
|
| null_value_eliminated_in_set_function
|
| |
| |
| string_data_right_truncation
|
| |
Class 02 — No Data (this is also a warning class per the SQL standard) | |
| |
| no_additional_dynamic_result_sets_returned
|
Class 03 — SQL Statement Not Yet Complete | |
| sql_statement_not_yet_complete
|
Class 08 — Connection Exception | |
| |
| connection_does_not_exist
|
| |
| sqlclient_unable_to_establish_sqlconnection
|
| sqlserver_rejected_establishment_of_sqlconnection
|
| transaction_resolution_unknown
|
| |
Class 09 — Triggered Action Exception | |
| triggered_action_exception
|
Class 0A — Feature Not Supported | |
| |
Class 0B — Invalid Transaction Initiation | |
| invalid_transaction_initiation
|
Class 0F — Locator Exception | |
| |
| invalid_locator_specification
|
Class 0L — Invalid Grantor | |
| |
| |
Class 0P — Invalid Role Specification | |
| invalid_role_specification
|
Class 0Z — Diagnostics Exception | |
| |
| stacked_diagnostics_accessed_without_active_handler
|
Class 20 — Case Not Found | |
| |
Class 21 — Cardinality Violation | |
| |
Class 22 — Data Exception | |
| |
| |
| character_not_in_repertoire
|
| |
| |
| |
| escape_character_conflict
|
| |
| |
| 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
|
| |
| |
| |
| |
| nonstandard_use_of_escape_character
|
| invalid_indicator_parameter_value
|
| |
| invalid_preceding_or_following_size
|
| 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_no_indicator_parameter
|
| numeric_value_out_of_range
|
| sequence_generator_limit_exceeded
|
| string_data_length_mismatch
|
| string_data_right_truncation
|
| |
| |
| |
| zero_length_character_string
|
| |
| invalid_text_representation
|
| invalid_binary_representation
|
| |
| |
| |
| |
| |
| |
| invalid_xml_processing_instruction
|
| duplicate_json_object_key_value
|
| invalid_argument_for_sql_json_datetime_function
|
| |
| invalid_sql_json_subscript
|
| more_than_one_sql_json_item
|
| |
| non_numeric_sql_json_item
|
| non_unique_keys_in_a_json_object
|
| singleton_sql_json_item_required
|
| |
| sql_json_member_not_found
|
| sql_json_number_not_found
|
| sql_json_object_not_found
|
| too_many_json_array_elements
|
| too_many_json_object_members
|
| |
| sql_json_item_cannot_be_cast_to_target_type
|
Class 23 — Integrity Constraint Violation | |
| integrity_constraint_violation
|
| |
| |
| |
| |
| |
| |
Class 24 — Invalid Cursor State | |
| |
Class 25 — Invalid Transaction State | |
| invalid_transaction_state
|
| |
| 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
|
| |
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 | |
| |
| function_executed_no_return_statement
|
| modifying_sql_data_not_permitted
|
| prohibited_sql_statement_attempted
|
| reading_sql_data_not_permitted
|
Class 34 — 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
|
| |
| trigger_protocol_violated
|
| |
| event_trigger_protocol_violated
|
Class 3B — Savepoint Exception | |
| |
| invalid_savepoint_specification
|
Class 3D — Invalid Catalog Name | |
| |
Class 3F — Invalid Schema Name | |
| |
Class 40 — Transaction Rollback | |
| |
| transaction_integrity_constraint_violation
|
| |
| statement_completion_unknown
|
| |
Class 42 — Syntax Error or Access Rule Violation | |
| syntax_error_or_access_rule_violation
|
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| duplicate_prepared_statement
|
| |
| |
| |
| |
| |
| |
| |
| |
| |
| invalid_column_definition
|
| invalid_cursor_definition
|
| invalid_database_definition
|
| invalid_function_definition
|
| invalid_prepared_statement_definition
|
| invalid_schema_definition
|
| |
| invalid_object_definition
|
Class 44 — WITH CHECK OPTION Violation | |
| with_check_option_violation
|
Class 53 — Insufficient Resources | |
| |
| |
| |
| |
| configuration_limit_exceeded
|
Class 54 — Program Limit Exceeded | |
| |
| |
| |
| |
Class 55 — Object Not In Prerequisite State | |
| object_not_in_prerequisite_state
|
| |
| cant_change_runtime_param
|
| |
| unsafe_new_enum_value_usage
|
Class 57 — Operator Intervention | |
| |
| |
| |
| |
| |
| |
| |
Class 58 — System Error (errors external to PostgreSQL itself) | |
| |
| |
| |
| |
Class 72 — Snapshot Failure | |
| |
Class F0 — Configuration File Error | |
| |
| |
Class HV — Foreign Data Wrapper Error (SQL/MED) | |
| |
| 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_number
|
| |
| fdw_invalid_data_type_descriptors
|
| fdw_invalid_descriptor_field_identifier
|
| |
| |
| |
| fdw_invalid_string_length_or_buffer_length
|
| fdw_invalid_string_format
|
| fdw_invalid_use_of_null_pointer
|
| |
| |
| |
| fdw_option_name_not_found
|
| |
| |
| |
| fdw_unable_to_create_execution
|
| fdw_unable_to_create_reply
|
| fdw_unable_to_establish_connection
|
Class P0 — PL/pgSQL Error | |
| |
| |
| |
| |
| |
Class XX — Internal Error | |
| |
| |
| |