Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Category index263
2200822008
Class 22 · Data Exception
10
datetime_field_overflow
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22008
## At a glance {#at-a-glance}
22008 is `datetime_field_overflow…SQLSTATE · Class 22 · Data Exception
2200922009
Class 22 · Data Exception
10
invalid_time_zone_displacement_value
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22009
## At a glance {#at-a-glance}
22009 is `invalid_ti…SQLSTATE · Class 22 · Data Exception
2200B2200B
Class 22 · Data Exception
10
escape_character_conflict
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2200B
## At a glance {#at-a-glance}
2200B is `escape_character_conf…SQLSTATE · Class 22 · Data Exception
2200C2200C
Class 22 · Data Exception
10
invalid_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
# 2200C
## At a glance {#at-a-glance}
The SQL `SIMILAR TO` patte…SQLSTATE · Class 22 · Data Exception
2200D2200D
Class 22 · Data Exception
10
invalid_escape_octet
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2200D
## At a glance {#at-a-glance}
The catalogue condition covers an inv…SQLSTATE · Class 22 · Data Exception
2200F2200F
Class 22 · Data Exception
10
zero_length_character_string
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2200F
## At a glance {#at-a-glance}
The condition identifies an o…SQLSTATE · Class 22 · Data Exception
2200G2200G
Class 22 · Data Exception
10
most_specific_type_mismatch
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2200G
## At a glance {#at-a-glance}
This condition names a most-sp…SQLSTATE · Class 22 · Data Exception
2200H2200H
Class 22 · Data Exception
10
sequence_generator_limit_exceeded
11
12
13
14
15
16
17
18
19
20
# 2200H
## At a glance {#at-a-glance}
A sequence allocation reached its configured limit w…SQLSTATE · Class 22 · Data Exception
2200L2200L
Class 22 · Data Exception
10
not_an_xml_document
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2200L
## At a glance {#at-a-glance}
The SQL/XML `SQLSERIALIZE` `DOCUMENT` …SQLSTATE · Class 22 · Data Exception
2200M2200M
Class 22 · Data Exception
10
invalid_xml_document
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2200M
## At a glance {#at-a-glance}
This catalogue member denotes an inva…SQLSTATE · Class 22 · Data Exception
2200N2200N
Class 22 · Data Exception
10
invalid_xml_content
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2200N
## At a glance {#at-a-glance}
This member covers invalid XML content…SQLSTATE · Class 22 · Data Exception
2200S2200S
Class 22 · Data Exception
10
invalid_xml_comment
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2200S
## At a glance {#at-a-glance}
An XML comment is invalid. PostgreSQL …SQLSTATE · Class 22 · Data Exception
2200T2200T
Class 22 · Data Exception
10
invalid_xml_processing_instruction
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2200T
## At a glance {#at-a-glance}
An XML processing instr…SQLSTATE · Class 22 · Data Exception
2201022010
Class 22 · Data Exception
10
invalid_indicator_parameter_value
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}
An indicator parameter value does…SQLSTATE · Class 22 · Data Exception
2201122011
Class 22 · Data Exception
10
substring_error
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}
A text substring path received an invalid explicit …SQLSTATE · Class 22 · Data Exception
2201222012
Class 22 · Data Exception
10
division_by_zero
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}
A division or modulo operation reached a zero divi…SQLSTATE · Class 22 · Data Exception
2201322013
Class 22 · Data Exception
11
invalid_preceding_or_following_size
12
13
14
15
16
17
18
19
20
## At a glance {#at-a-glance}
A window-frame offset is negative in a fixed `ROWS` or `GROUPS…SQLSTATE · Class 22 · Data Exception
2201422014
Class 22 · Data Exception
10
invalid_argument_for_ntile_function
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}
`ntile` received a non-positive…SQLSTATE · Class 22 · Data Exception
2201522015
Class 22 · Data Exception
10
interval_field_overflow
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}
An interval input field exceeds the range a…SQLSTATE · Class 22 · Data Exception
2201622016
Class 22 · Data Exception
10
invalid_argument_for_nth_value_function
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}
`nth_value` received a non-…SQLSTATE · Class 22 · Data Exception
2201822018
Class 22 · Data Exception
10
invalid_character_value_for_cast
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}
A character value is rejected by t…SQLSTATE · Class 22 · Data Exception
2201922019
Class 22 · Data Exception
10
invalid_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
## At a glance {#at-a-glance}
An operation rejected its escape argument.…SQLSTATE · Class 22 · Data Exception
2201B2201B
Class 22 · Data Exception
10
invalid_regular_expression
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}
SQL regular-expression compilation and e…SQLSTATE · Class 22 · Data Exception
2201E2201E
Class 22 · Data Exception
10
invalid_argument_for_logarithm
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2201E
## At a glance {#at-a-glance}
Logarithm functions reject …SQLSTATE · Class 22 · Data Exception
2201F2201F
Class 22 · Data Exception
10
invalid_argument_for_power_function
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2201F
## At a glance {#at-a-glance}
Power functions reject…SQLSTATE · Class 22 · Data Exception
2201G2201G
Class 22 · Data Exception
10
invalid_argument_for_width_bucket_function
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2201G
## At a glance {#at-a-glance}
`width_bucket` …SQLSTATE · Class 22 · Data Exception
2201W2201W
Class 22 · Data Exception
10
invalid_row_count_in_limit_clause
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2201W
## At a glance {#at-a-glance}
A LIMIT or FETCH row cou…SQLSTATE · Class 22 · Data Exception
2201X2201X
Class 22 · Data Exception
10
invalid_row_count_in_result_offset_clause
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2201X
## At a glance {#at-a-glance}
An OFFSET expres…SQLSTATE · Class 22 · Data Exception
2202122021
Class 22 · Data Exception
10
character_not_in_repertoire
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22021
## At a glance {#at-a-glance}
A source byte sequence is inva…SQLSTATE · Class 22 · Data Exception
2202222022
Class 22 · Data Exception
10
indicator_overflow
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22022
## At a glance {#at-a-glance}
The catalogue condition names an indica…SQLSTATE · Class 22 · Data Exception
2202322023
Class 22 · Data Exception
10
invalid_parameter_value
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22023
## At a glance {#at-a-glance}
A named parameter, option, descrip…SQLSTATE · Class 22 · Data Exception
2202422024
Class 22 · Data Exception
10
unterminated_c_string
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22024
## At a glance {#at-a-glance}
The catalogue condition names a C-st…SQLSTATE · Class 22 · Data Exception
2202522025
Class 22 · Data Exception
10
invalid_escape_sequence
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22025
## At a glance {#at-a-glance}
An escape sequence is invalid for …SQLSTATE · Class 22 · Data Exception
2202622026
Class 22 · Data Exception
10
string_data_length_mismatch
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22026
## At a glance {#at-a-glance}
A bit-string value has the wro…SQLSTATE · Class 22 · Data Exception
2202722027
Class 22 · Data Exception
10
trim_error
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22027
## At a glance {#at-a-glance}
The trim operation rejected its argument or tri…SQLSTATE · Class 22 · Data Exception
2202E2202E
Class 22 · Data Exception
10
array_subscript_error
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}
`2202E` is PostgreSQL's `array_subscript_er…SQLSTATE · Class 22 · Data Exception
2202G2202G
Class 22 · Data Exception
10
invalid_tablesample_repeat
11
12
13
14
15
16
17
18
19
20
9.5
9.6
# 2202G
## At a glance {#at-a-glance}
The TABLESAMPLE REPEATABLE seed is invalid when it …SQLSTATE · Class 22 · Data Exception
2202H2202H
Class 22 · Data Exception
10
invalid_tablesample_argument
11
12
13
14
15
16
17
18
19
20
9.5
9.6
# 2202H
## At a glance {#at-a-glance}
A TABLESAMPLE method received an invalid argument…SQLSTATE · Class 22 · Data Exception
2203022030
Class 22 · Data Exception
12
duplicate_json_object_key_value
13
14
15
16
17
18
19
20
# 22030
## At a glance {#at-a-glance}
A JSON object construction encountered a duplicate key. The …SQLSTATE · Class 22 · Data Exception
2203122031
Class 22 · Data Exception
13
invalid_argument_for_sql_json_datetime_function
14
15
16
17
18
19
20
# 22031
## At a glance {#at-a-glance}
A SQL/JSON datetime method received an invalid …SQLSTATE · Class 22 · Data Exception
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
pg17: choose a version ex: extensions only ↑↓ select ↵ open