Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Popular entries9756
2203722037
Class 22 · Data Exception
12
non_unique_keys_in_a_json_object
13
14
15
16
17
18
19
20
# 22037
## At a glance {#at-a-glance}
The locked condition names a non-unique-key error for a JSO…SQLSTATE · Class 22 · Data Exception
2203822038
Class 22 · Data Exception
12
singleton_sql_json_item_required
13
14
15
16
17
18
19
20
# 22038
## At a glance {#at-a-glance}
A SQL/JSON path operation expected one result of a required…SQLSTATE · Class 22 · Data Exception
2203922039
Class 22 · Data Exception
12
sql_json_array_not_found
13
14
15
16
17
18
19
20
# 22039
## At a glance {#at-a-glance}
An array-only JSON path accessor or item method reached a non-array…SQLSTATE · Class 22 · Data Exception
2203A2203A
Class 22 · Data Exception
12
sql_json_member_not_found
13
14
15
16
17
18
19
20
# 2203A
## At a glance {#at-a-glance}
A named JSON object member cannot be read from the current item. F…SQLSTATE · Class 22 · Data Exception
2203B2203B
Class 22 · Data Exception
12
sql_json_number_not_found
13
14
15
16
17
18
19
20
# 2203B
## At a glance {#at-a-glance}
A unary jsonpath arithmetic operator needs a numeric operand but r…SQLSTATE · Class 22 · Data Exception
2203C2203C
Class 22 · Data Exception
12
sql_json_object_not_found
13
14
15
16
17
18
19
20
# 2203C
## At a glance {#at-a-glance}
An object-only JSON path accessor or `.keyvalue()` method received…SQLSTATE · Class 22 · Data Exception
2203D2203D
Class 22 · Data Exception
12
too_many_json_array_elements
13
14
15
16
17
18
19
20
# 2203D
## At a glance {#at-a-glance}
The locked condition names an excessive number of JSON array el…SQLSTATE · Class 22 · Data Exception
2203E2203E
Class 22 · Data Exception
12
too_many_json_object_members
13
14
15
16
17
18
19
20
# 2203E
## At a glance {#at-a-glance}
The locked condition names an excessive number of JSON object m…SQLSTATE · Class 22 · Data Exception
2203F2203F
Class 22 · Data Exception
12
sql_json_scalar_required
13
14
15
16
17
18
19
20
# 2203F
## At a glance {#at-a-glance}
A JSON_VALUE operation received one item, but that item was not a s…SQLSTATE · Class 22 · Data Exception
2203G2203G
Class 22 · Data Exception
15
sql_json_item_cannot_be_cast_to_target_type
16
17
18
19
20
# 2203G
## At a glance {#at-a-glance}
`2203G` is the catalogue condition `sql_json_item_cannot…SQLSTATE · Class 22 · Data Exception
22P0122P01
Class 22 · Data Exception
10
floating_point_exception
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22P01
## At a glance {#at-a-glance}
PostgreSQL's fixed core path ins…SQLSTATE · Class 22 · Data Exception
22P0222P02
Class 22 · Data Exception
10
invalid_text_representation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22P02 — Invalid text representation
## At a glance {#at-a-glance}
…SQLSTATE · Class 22 · Data Exception
22P0322P03
Class 22 · Data Exception
10
invalid_binary_representation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22P03
## At a glance {#at-a-glance}
`22P03` is PostgreSQL's inv…SQLSTATE · Class 22 · Data Exception
22P0422P04
Class 22 · Data Exception
10
bad_copy_file_format
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22P04
## At a glance {#at-a-glance}
`22P04` is the COPY file-format boun…SQLSTATE · Class 22 · Data Exception
22P0522P05
Class 22 · Data Exception
10
untranslatable_character
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22P05
## At a glance {#at-a-glance}
PostgreSQL could identify a sour…SQLSTATE · Class 22 · Data Exception
22P0622P06
Class 22 · Data Exception
10
nonstandard_use_of_escape_character
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22P06
## At a glance {#at-a-glance}
The SQL scanner found…SQLSTATE · Class 22 · Data Exception
2300023000
Class 23 · Integrity Constraint Violation
10
integrity_constraint_violation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 23000 — integrity_constraint_violation
## At a …SQLSTATE · Class 23 · Integrity Constraint Violation
2300123001
Class 23 · Integrity Constraint Violation
10
restrict_violation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 23001 — restrict_violation
## At a glance {#at-a-glance}
`…SQLSTATE · Class 23 · Integrity Constraint Violation
2350223502
Class 23 · Integrity Constraint Violation
10
not_null_violation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 23502 — not_null_violation
## At a glance {#at-a-glance}
`…SQLSTATE · Class 23 · Integrity Constraint Violation
2350323503
Class 23 · Integrity Constraint Violation
10
foreign_key_violation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
## At a glance {#at-a-glance}
`23503` is PostgreSQL's `fo…SQLSTATE · Class 23 · Integrity Constraint Violation
2351423514
Class 23 · Integrity Constraint Violation
10
check_violation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 23514 — check_violation
## At a glance {#at-a-glance}
`23514`…SQLSTATE · Class 23 · Integrity Constraint Violation
23P0123P01
Class 23 · Integrity Constraint Violation
10
exclusion_violation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 23P01 — exclusion_violation
## At a glance {#at-a-glance}
…SQLSTATE · Class 23 · Integrity Constraint Violation
2400024000
Class 24 · Invalid Cursor State
10
invalid_cursor_state
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 24000 — invalid_cursor_state
## At a glance {#at-a-glance}
`24000`…SQLSTATE · Class 24 · Invalid Cursor State
2500025000
Class 25 · Invalid Transaction State
10
invalid_transaction_state
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 25000 — invalid_transaction_state
## At a glance {#at-a-g…SQLSTATE · Class 25 · Invalid Transaction State
2500125001
Class 25 · Invalid Transaction State
10
active_sql_transaction
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 25001 — active_sql_transaction
## At a glance {#at-a-glance}…SQLSTATE · Class 25 · Invalid Transaction State
2500225002
Class 25 · Invalid Transaction State
10
branch_transaction_already_active
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 25002 — branch_transaction_already_active
## At a…SQLSTATE · Class 25 · Invalid Transaction State
2500325003
Class 25 · Invalid Transaction State
10
inappropriate_access_mode_for_branch_transaction
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 25003 — inappropriate_access_mode_f…SQLSTATE · Class 25 · Invalid Transaction State
2500425004
Class 25 · Invalid Transaction State
10
inappropriate_isolation_level_for_branch_transaction
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 25004 — inappropriate_isolation…SQLSTATE · Class 25 · Invalid Transaction State
2500525005
Class 25 · Invalid Transaction State
10
no_active_sql_transaction_for_branch_transaction
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 25005 — no_active_sql_transaction_f…SQLSTATE · Class 25 · Invalid Transaction State
2500625006
Class 25 · Invalid Transaction State
10
read_only_sql_transaction
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 25006 — read_only_sql_transaction
## At a glance {#at-a-g…SQLSTATE · Class 25 · Invalid Transaction State
2500725007
Class 25 · Invalid Transaction State
10
schema_and_data_statement_mixing_not_supported
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 25007 — schema_and_data_statement_mix…SQLSTATE · Class 25 · Invalid Transaction State
2500825008
Class 25 · Invalid Transaction State
10
held_cursor_requires_same_isolation_level
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 25008 — held_cursor_requires_same_isolatio…SQLSTATE · Class 25 · Invalid Transaction State
25P0125P01
Class 25 · Invalid Transaction State
10
no_active_sql_transaction
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 25P01 — no_active_sql_transaction
## At a glance {#at-a-g…SQLSTATE · Class 25 · Invalid Transaction State
25P0225P02
Class 25 · Invalid Transaction State
10
in_failed_sql_transaction
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 25P02 — in_failed_sql_transaction
## At a glance {#at-a-g…SQLSTATE · Class 25 · Invalid Transaction State
25P0325P03
Class 25 · Invalid Transaction State
10
idle_in_transaction_session_timeout
11
12
13
14
15
16
17
18
19
20
9.6
# 25P03 — idle_in_transaction_session_timeout
## At a glance {#at-a-glanc…SQLSTATE · Class 25 · Invalid Transaction State
25P0425P04
Class 25 · Invalid Transaction State
17
transaction_timeout
18
19
20
# 25P04 — transaction_timeout
## At a glance {#at-a-glance}
`25P04` is a FATAL condition emitted by `transaction_…SQLSTATE · Class 25 · Invalid Transaction State
2600026000
Class 26 · Invalid SQL Statement Name
10
invalid_sql_statement_name
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 26000 — invalid_sql_statement_name
## At a glance {#at…SQLSTATE · Class 26 · Invalid SQL Statement Name
2700027000
Class 27 · Triggered Data Change Violation
10
triggered_data_change_violation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 27000 — triggered_data_change_violation
## A…SQLSTATE · Class 27 · Triggered Data Change Violation
2800028000
Class 28 · Invalid Authorization Specification
10
invalid_authorization_specification
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 28000
## At a glance {#at-a-glance}
…SQLSTATE · Class 28 · Invalid Authorization Specification
28P0128P01
Class 28 · Invalid Authorization Specification
10
invalid_password
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
## At a glance {#at-a-glance}
`28P01` is PostgreSQL's `in…SQLSTATE · Class 28 · Invalid Authorization Specification
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
pg17: choose a version ex: extensions only ↑↓ select ↵ open