Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Category index263
5310053100
Class 53 · Insufficient Resources
10
disk_full
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 53100
## At a glance {#at-a-glance}
`53100` reports the explicit short-writ…SQLSTATE · Class 53 · Insufficient Resources
5320053200
Class 53 · Insufficient Resources
10
out_of_memory
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 53200
## At a glance {#at-a-glance}
`53200` is PostgreSQL's out-of-memo…SQLSTATE · Class 53 · Insufficient Resources
5330053300
Class 53 · Insufficient Resources
10
too_many_connections
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}
`53300` is PostgreSQL's `too_many_co…SQLSTATE · Class 53 · Insufficient Resources
5340053400
Class 53 · Insufficient Resources
10
configuration_limit_exceeded
11
12
13
14
15
16
17
18
19
20
9.2
9.3
9.4
9.5
9.6
# 53400
## At a glance {#at-a-glance}
`53400` reports that a confi…SQLSTATE · Class 53 · Insufficient Resources
5400054000
Class 54 · Program Limit Exceeded
10
program_limit_exceeded
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 54000
## At a glance {#at-a-glance}
`54000` is used when a con…SQLSTATE · Class 54 · Program Limit Exceeded
5400154001
Class 54 · Program Limit Exceeded
10
statement_too_complex
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 54001
## At a glance {#at-a-glance}
`54001` covers a statement …SQLSTATE · Class 54 · Program Limit Exceeded
5401154011
Class 54 · Program Limit Exceeded
10
too_many_columns
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 54011
## At a glance {#at-a-glance}
`54011` reports that a physical …SQLSTATE · Class 54 · Program Limit Exceeded
5402354023
Class 54 · Program Limit Exceeded
10
too_many_arguments
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 54023
## At a glance {#at-a-glance}
`54023` is the argument-count …SQLSTATE · Class 54 · Program Limit Exceeded
5500055000
Class 55 · Object Not In Prerequisite State
10
object_not_in_prerequisite_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
# 55000 — Object not in prerequisite state
##…SQLSTATE · Class 55 · Object Not In Prerequisite State
5500655006
Class 55 · Object Not In Prerequisite State
10
object_in_use
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 55006 — Object in use
## At a glance {#at-a-glance}
`55006` r…SQLSTATE · Class 55 · Object Not In Prerequisite State
55P0255P02
Class 55 · Object Not In Prerequisite State
10
cant_change_runtime_param
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 55P02
## At a glance {#at-a-glance}
`55P02` means…SQLSTATE · Class 55 · Object Not In Prerequisite State
55P0355P03
Class 55 · Object Not In Prerequisite State
10
lock_not_available
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 55P03
## At a glance {#at-a-glance}
`55P03` reports that…SQLSTATE · Class 55 · Object Not In Prerequisite State
55P0455P04
Class 55 · Object Not In Prerequisite State
12
unsafe_new_enum_value_usage
13
14
15
16
17
18
19
20
# 55P04
## At a glance {#at-a-glance}
`55P04` protects the commit-before-use rule f…SQLSTATE · Class 55 · Object Not In Prerequisite State
5700057000
Class 57 · Operator Intervention
10
operator_intervention
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 57000
## At a glance {#at-a-glance}
`57000` is the SQLSTATE Class…SQLSTATE · Class 57 · Operator Intervention
5701457014
Class 57 · Operator Intervention
10
query_canceled
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}
`57014` is PostgreSQL's `query_canceled` co…SQLSTATE · Class 57 · Operator Intervention
57P0157P01
Class 57 · Operator Intervention
10
admin_shutdown
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 57P01
## At a glance {#at-a-glance}
`57P01` is a server-initiated admini…SQLSTATE · Class 57 · Operator Intervention
57P0257P02
Class 57 · Operator Intervention
10
crash_shutdown
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 57P02
## At a glance {#at-a-glance}
`57P02` is the crash-shutdown path. …SQLSTATE · Class 57 · Operator Intervention
57P0357P03
Class 57 · Operator Intervention
10
cannot_connect_now
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 57P03
## At a glance {#at-a-glance}
`57P03` is emitted during connec…SQLSTATE · Class 57 · Operator Intervention
57P0457P04
Class 57 · Operator Intervention
10
database_dropped
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 57P04
## At a glance {#at-a-glance}
`57P04` is selected when a recover…SQLSTATE · Class 57 · Operator Intervention
57P0557P05
Class 57 · Operator Intervention
14
idle_session_timeout
15
16
17
18
19
20
# 57P05
## At a glance {#at-a-glance}
`57P05` terminates a session after `idle_session_timeout` expires whil…SQLSTATE · Class 57 · Operator Intervention
5800058000
Class 58 · System Error (errors external to PostgreSQL itself)
10
system_error
11
12
13
14
15
16
17
18
19
20
9.2
9.3
9.4
9.5
9.6
# 58000
## At a glance {#at-a-glance}
`58000` is the s…SQLSTATE · Class 58 · System Error (errors external to PostgreSQL itself)
5803058030
Class 58 · System Error (errors external to PostgreSQL itself)
10
io_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
# 58030
## At a glance {#at-a-glance}
`58030` is …SQLSTATE · Class 58 · System Error (errors external to PostgreSQL itself)
58P0158P01
Class 58 · System Error (errors external to PostgreSQL itself)
10
undefined_file
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 58P01
## At a glance {#at-a-glance}
`58P0…SQLSTATE · Class 58 · System Error (errors external to PostgreSQL itself)
58P0258P02
Class 58 · System Error (errors external to PostgreSQL itself)
10
duplicate_file
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 58P02
## At a glance {#at-a-glance}
`58P0…SQLSTATE · Class 58 · System Error (errors external to PostgreSQL itself)
58P0358P03
Class 58 · System Error (errors external to PostgreSQL itself)
18
file_name_too_long
19
20
# 58P03
## At a glance {#at-a-glance}
`58P03` is selected by PostgreSQL's file-access errno…SQLSTATE · Class 58 · System Error (errors external to PostgreSQL itself)
7200072000
Class 72 · Snapshot Failure
10
snapshot_too_old
11
12
13
14
15
16
9.6
# 72000
## At a glance {#at-a-glance}
`72000` is a historical `snapshot_too_old` error. PostgreSQL 16.15 still d…SQLSTATE · Class 72 · Snapshot Failure
F0000F0000
Class F0 · Configuration File Error
10
config_file_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
# F0000
## At a glance {#at-a-glance}
`F0000` is the configuration-…SQLSTATE · Class F0 · Configuration File Error
F0001F0001
Class F0 · Configuration File Error
10
lock_file_exists
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# F0001
## At a glance {#at-a-glance}
`F0001` is a startup ownership…SQLSTATE · Class F0 · Configuration File Error
HV000HV000
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_error
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV000 — fdw_error
## At a glance {#at-a-glance}
`HV000` is the ge…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
HV001HV001
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_out_of_memory
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV001 — fdw_out_of_memory
## At a glance {#at-a-glance}
`…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
HV002HV002
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_dynamic_parameter_value_needed
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV002 — fdw_dynamic_parameter_value_needed…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
HV004HV004
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_invalid_data_type
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV004 — fdw_invalid_data_type
## At a glance {#at-a-gl…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
HV005HV005
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_column_name_not_found
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV005 — fdw_column_name_not_found
## At a glance {…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
HV006HV006
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_invalid_data_type_descriptors
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV006 — fdw_invalid_data_type_descriptors
…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
HV007HV007
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_invalid_column_name
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV007 — fdw_invalid_column_name
## At a glance {#at-…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
HV008HV008
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_invalid_column_number
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV008 — fdw_invalid_column_number
## At a glance {…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
HV009HV009
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_invalid_use_of_null_pointer
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV009 — fdw_invalid_use_of_null_pointer
## A…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
HV00AHV00A
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_invalid_string_format
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV00A — fdw_invalid_string_format
## At a glance {…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
HV00BHV00B
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_invalid_handle
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV00B — fdw_invalid_handle
## At a glance {#at-a-glance}
…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
HV00CHV00C
Class HV · Foreign Data Wrapper Error (SQL/MED)
10
fdw_invalid_option_index
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# HV00C — fdw_invalid_option_index
## At a glance {#a…SQLSTATE · Class HV · Foreign Data Wrapper Error (SQL/MED)
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
pg17: choose a version ex: extensions only ↑↓ select ↵ open