sqlstate

Description

SQL state related errors and conditions.

Enumerations
enum	ozo::sqlstate::code
	SQL state error conditions. More...

Functions
const error_category &	ozo::sqlstate::category () noexcept
	Sql state related errors category. More...

Enumeration Type Documentation

code

enum ozo::sqlstate::code

SQL state error conditions.

This is a set of error conditions. It may not be complete, since new versions of PostgreSQL may add another sql state codes and users may create new ones inside a DB logic. So this set may be used to match most of sql states but not all.

Here are list of error conditions related to PostgreSQL error classes. A full list of codes can be found in the official documentation for PostgreSQL.

Enumerator
successful_completion	Class 00 — Successful Completion.
warning	Class 01 — Warning.
no_data	Class 02 — No Data (this is also a warning class per the SQL standard)
sql_statement_not_yet_complete	Class 03 — SQL Statement Not Yet Complete.
connection_exception	Class 08 — Connection Exception.
triggered_action_exception	Class 09 — Triggered Action Exception.
feature_not_supported	Class 0A — Feature Not Supported.
invalid_transaction_initiation	Class 0B — Invalid Transaction Initiation.
locator_exception	Class 0F — Locator Exception.
invalid_grantor	Class 0L — Invalid Grantor.
invalid_role_specification	Class 0P — Invalid Role Specification.
diagnostics_exception	Class 0Z — Diagnostics Exception.
case_not_found	Class 20 — Case Not Found.
cardinality_violation	Class 21 — Cardinality Violation.
data_exception	Class 22 — Data Exception.
integrity_constraint_violation	Class 23 — Integrity Constraint Violation.
invalid_cursor_state	Class 24 — Invalid Cursor State.
invalid_transaction_state	Class 25 — Invalid Transaction State.
invalid_sql_statement_name	Class 26 — Invalid SQL Statement Name.
triggered_data_change_violation	Class 27 — Triggered Data Change Violation.
invalid_authorization_specification	Class 28 — Invalid Authorization Specification.
dependent_privilege_descriptors_still_exist	Class 2B — Dependent Privilege Descriptors Still Exist.
invalid_transaction_termination	Class 2D — Invalid Transaction Termination.
sql_routine_exception	Class 2F — SQL Routine Exception.
invalid_cursor_name	Class 34 — Invalid Cursor Name.
external_routine_exception	Class 38 — External Routine Exception.
external_routine_invocation_exception	Class 39 — External Routine Invocation Exception.
savepoint_exception	Class 3B — Savepoint Exception.
invalid_catalog_name	Class 3D — Invalid Catalog Name.
invalid_schema_name	Class 3F — Invalid Schema Name.
transaction_rollback	Class 40 — Transaction Rollback.
syntax_error_or_access_rule_violation	Class 42 — Syntax Error or Access Rule Violation.
with_check_option_violation	Class 44 — WITH CHECK OPTION Violation.
insufficient_resources	Class 53 — Insufficient Resources.
program_limit_exceeded	Class 54 — Program Limit Exceeded.
object_not_in_prerequisite_state	Class 55 — Object Not In Prerequisite State.
operator_intervention	Class 57 — Operator Intervention.
system_error	Class 58 — System Error (errors external to PostgreSQL itself)
snapshot_too_old	Class 72 — Snapshot Failure.
config_file_error	Class F0 — Configuration File Error.
fdw_error	Class HV — Foreign Data Wrapper Error (SQL/MED)
plpgsql_error	Class P0 — PL/pgSQL Error.
internal_error	Class XX — Internal Error.

Function Documentation

category()

const error_category & ozo::sqlstate::category ( )

noexcept

Sql state related errors category.

Returns

const error_category& — reference to the category object

References ozo::errc::category().