Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Category index263
2350523505
Class 23 · Integrity Constraint Violation
10
unique_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}
`23505` is PostgreSQL's `unique_…SQLSTATE · Class 23 · Integrity Constraint Violation
0000000000
Class 00 · Successful Completion
10
successful_completion
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 00000 — successful_completion
## At a glance {#at-a-glance}
`000…SQLSTATE · Class 00 · Successful Completion
0100001000
Class 01 · Warning
10
warning
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}
`01000` is the generic `warning` condition in Class 01, `Warning…SQLSTATE · Class 01 · Warning
0100301003
Class 01 · Warning
10
null_value_eliminated_in_set_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
# 01003 — null_value_eliminated_in_set_function
## At a glance {#…SQLSTATE · Class 01 · Warning
0100401004
Class 01 · Warning
10
string_data_right_truncation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 01004 — string_data_right_truncation
## At a glance {#at-a-glance}
`010…SQLSTATE · Class 01 · Warning
0100601006
Class 01 · Warning
10
privilege_not_revoked
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 01006 — privilege_not_revoked
## At a glance {#at-a-glance}
`01006` has confir…SQLSTATE · Class 01 · Warning
0100701007
Class 01 · Warning
10
privilege_not_granted
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 01007 — privilege_not_granted
## At a glance {#at-a-glance}
`01007` has confir…SQLSTATE · Class 01 · Warning
0100801008
Class 01 · Warning
10
implicit_zero_bit_padding
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 01008 — implicit_zero_bit_padding
## At a glance {#at-a-glance}
`01008` na…SQLSTATE · Class 01 · Warning
0100C0100C
Class 01 · Warning
10
dynamic_result_sets_returned
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 0100C — dynamic_result_sets_returned
## At a glance {#at-a-glance}
`010…SQLSTATE · Class 01 · Warning
01P0101P01
Class 01 · Warning
10
deprecated_feature
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 01P01 — deprecated_feature
## At a glance {#at-a-glance}
PostgreSQL 18.6 emits `0…SQLSTATE · Class 01 · Warning
0200002000
Class 02 · No Data (this is also a warning class per the SQL standard)
10
no_data
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 02000 — no_data
## At a glance {#at-a-gla…SQLSTATE · Class 02 · No Data (this is also a warning class per the SQL standard)
0200102001
Class 02 · No Data (this is also a warning class per the SQL standard)
10
no_additional_dynamic_result_sets_returned
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 02001 —…SQLSTATE · Class 02 · No Data (this is also a warning class per the SQL standard)
0300003000
Class 03 · SQL Statement Not Yet Complete
10
sql_statement_not_yet_complete
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 03000 — sql_statement_not_yet_complete
## At a …SQLSTATE · Class 03 · SQL Statement Not Yet Complete
0800008000
Class 08 · Connection Exception
10
connection_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
# 08000
## At a glance {#at-a-glance}
SQLSTATE `08000` is **connecti…SQLSTATE · Class 08 · Connection Exception
0800108001
Class 08 · Connection Exception
10
sqlclient_unable_to_establish_sqlconnection
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 08001
## At a glance {#at-a-glance}
SQLSTAT…SQLSTATE · Class 08 · Connection Exception
0800308003
Class 08 · Connection Exception
10
connection_does_not_exist
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 08003
## At a glance {#at-a-glance}
SQLSTATE `08003` is **con…SQLSTATE · Class 08 · Connection Exception
0800408004
Class 08 · Connection Exception
10
sqlserver_rejected_establishment_of_sqlconnection
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 08004
## At a glance {#at-a-glance}
S…SQLSTATE · Class 08 · Connection Exception
0800608006
Class 08 · Connection Exception
10
connection_failure
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 08006
## At a glance {#at-a-glance}
SQLSTATE `08006` is **connection…SQLSTATE · Class 08 · Connection Exception
0800708007
Class 08 · Connection Exception
10
transaction_resolution_unknown
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 08007
## At a glance {#at-a-glance}
SQLSTATE `08007` is …SQLSTATE · Class 08 · Connection Exception
08P0108P01
Class 08 · Connection Exception
10
protocol_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
# 08P01
## At a glance {#at-a-glance}
SQLSTATE `08P01` is **protocol_v…SQLSTATE · Class 08 · Connection Exception
0900009000
Class 09 · Triggered Action Exception
10
triggered_action_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
# 09000
## At a glance {#at-a-glance}
SQLSTATE 09000 is …SQLSTATE · Class 09 · Triggered Action Exception
0A0000A000
Class 0A · Feature Not Supported
10
feature_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
# 0A000
## At a glance {#at-a-glance}
SQLSTATE `0A000` is **featur…SQLSTATE · Class 0A · Feature Not Supported
0B0000B000
Class 0B · Invalid Transaction Initiation
10
invalid_transaction_initiation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 0B000
## At a glance {#at-a-glance}
SQLSTATE 0…SQLSTATE · Class 0B · Invalid Transaction Initiation
0F0000F000
Class 0F · Locator Exception
10
locator_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
# 0F000
## At a glance {#at-a-glance}
SQLSTATE 0F000 is the Locator Except…SQLSTATE · Class 0F · Locator Exception
0F0010F001
Class 0F · Locator Exception
10
invalid_locator_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
# 0F001
## At a glance {#at-a-glance}
SQLSTATE 0F001 is the In…SQLSTATE · Class 0F · Locator Exception
0L0000L000
Class 0L · Invalid Grantor
10
invalid_grantor
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 0L000
## At a glance {#at-a-glance}
SQLSTATE `0L000` is **invalid_grantor** …SQLSTATE · Class 0L · Invalid Grantor
0LP010LP01
Class 0L · Invalid Grantor
10
invalid_grant_operation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 0LP01
## At a glance {#at-a-glance}
SQLSTATE `0LP01` is **invalid_gr…SQLSTATE · Class 0L · Invalid Grantor
0P0000P000
Class 0P · Invalid Role Specification
10
invalid_role_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
# 0P000
## At a glance {#at-a-glance}
SQLSTATE `0P000` i…SQLSTATE · Class 0P · Invalid Role Specification
0Z0000Z000
Class 0Z · Diagnostics Exception
10
diagnostics_exception
11
12
13
14
15
16
17
18
19
20
9.2
9.3
9.4
9.5
9.6
# 0Z000
## At a glance {#at-a-glance}
SQLSTATE 0Z000 is the Diagnostics Ex…SQLSTATE · Class 0Z · Diagnostics Exception
0Z0020Z002
Class 0Z · Diagnostics Exception
10
stacked_diagnostics_accessed_without_active_handler
11
12
13
14
15
16
17
18
19
20
9.2
9.3
9.4
9.5
9.6
# 0Z002
## At a glance {#at-a-glance}
SQLSTA…SQLSTATE · Class 0Z · Diagnostics Exception
1060810608
Class 10 · XQuery Error
18
invalid_argument_for_xquery
19
20
# 10608
## At a glance {#at-a-glance}
SQLSTATE 10608 is an ERROR-level XQuery-class condition for an invalid argument. Po…SQLSTATE · Class 10 · XQuery Error
2000020000
Class 20 · Case Not Found
10
case_not_found
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 20000
## At a glance {#at-a-glance}
SQLSTATE 20000 is raised by PL/pgSQL for a…SQLSTATE · Class 20 · Case Not Found
2100021000
Class 21 · Cardinality Violation
10
cardinality_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
# 21000 — cardinality_violation
## At a glance {#at-a-glance}
`210…SQLSTATE · Class 21 · Cardinality Violation
2200022000
Class 22 · Data Exception
10
data_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
# 22000
## At a glance {#at-a-glance}
22000 is `data_exception`. The fixed `arra…SQLSTATE · Class 22 · Data Exception
2200122001
Class 22 · Data Exception
10
string_data_right_truncation
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22001
## At a glance {#at-a-glance}
22001 is `string_data_right_…SQLSTATE · Class 22 · Data Exception
2200222002
Class 22 · Data Exception
10
null_value_no_indicator_parameter
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22002
## At a glance {#at-a-glance}
22002 is `null_value_no…SQLSTATE · Class 22 · Data Exception
2200322003
Class 22 · Data Exception
10
numeric_value_out_of_range
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22003
## At a glance {#at-a-glance}
22003 is `numeric_value_out_of…SQLSTATE · Class 22 · Data Exception
2200422004
Class 22 · Data Exception
10
null_value_not_allowed
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22004
## At a glance {#at-a-glance}
22004 is `null_value_not_allowed`.…SQLSTATE · Class 22 · Data Exception
2200522005
Class 22 · Data Exception
10
error_in_assignment
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 22005
## At a glance {#at-a-glance}
22005 is `error_in_assignment`. The f…SQLSTATE · Class 22 · Data Exception
2200722007
Class 22 · Data Exception
10
invalid_datetime_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
# 22007
## At a glance {#at-a-glance}
22007 is `invalid_datetime_format…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