Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Popular entries9756
4271242712
Class 42 · Syntax Error or Access Rule Violation
10
duplicate_alias
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42712 — Duplicate alias
## At a glance {#at-a-glance}
…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4272342723
Class 42 · Syntax Error or Access Rule Violation
10
duplicate_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
# 42723 — Duplicate function
## At a glance {#at-a-gla…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4272542725
Class 42 · Syntax Error or Access Rule Violation
10
ambiguous_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
# 42725 — Ambiguous function
## At a glance {#at-a-gla…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4280342803
Class 42 · Syntax Error or Access Rule Violation
10
grouping_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
# 42803 — Grouping error
## At a glance {#at-a-glance}
`4…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4280442804
Class 42 · Syntax Error or Access Rule Violation
10
datatype_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
# 42804 — Datatype mismatch
## At a glance {#at-a-glanc…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4280942809
Class 42 · Syntax Error or Access Rule Violation
10
wrong_object_type
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42809 — Wrong object type
## At a glance {#at-a-glanc…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4283042830
Class 42 · Syntax Error or Access Rule Violation
10
invalid_foreign_key
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42830 — Invalid foreign key
## At a glance {#at-a-g…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4284642846
Class 42 · Syntax Error or Access Rule Violation
10
cannot_coerce
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42846 — Cannot coerce
## At a glance {#at-a-glance}
`428…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4288342883
Class 42 · Syntax Error or Access Rule Violation
10
undefined_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
# 42883 — Undefined function
## At a glance {#at-a-gla…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
428C9428C9
Class 42 · Syntax Error or Access Rule Violation
10
generated_always
11
12
13
14
15
16
17
18
19
20
# 428C9 — Generated-always column assignment
## At a glance {#at-a-glance}
`428C9` …SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4293942939
Class 42 · Syntax Error or Access Rule Violation
10
reserved_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
# 42939 — Reserved name
## At a glance {#at-a-glance}
`429…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P0142P01
Class 42 · Syntax Error or Access Rule Violation
10
undefined_table
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}
`42P01` is PostgreSQL's `u…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P0242P02
Class 42 · Syntax Error or Access Rule Violation
10
undefined_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
# 42P02 — Undefined parameter
## At a glance {#at-a-g…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P0342P03
Class 42 · Syntax Error or Access Rule Violation
10
duplicate_cursor
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P03 — Duplicate cursor
## At a glance {#at-a-glance}…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P0442P04
Class 42 · Syntax Error or Access Rule Violation
10
duplicate_database
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P04 — Duplicate database
## At a glance {#at-a-gla…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P0542P05
Class 42 · Syntax Error or Access Rule Violation
10
duplicate_prepared_statement
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P05 — Duplicate prepared statement
## At…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P0642P06
Class 42 · Syntax Error or Access Rule Violation
10
duplicate_schema
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P06 — Duplicate schema
## At a glance {#at-a-glance}…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P0742P07
Class 42 · Syntax Error or Access Rule Violation
10
duplicate_table
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P07 — Duplicate table or relation definition
## At a …SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P0842P08
Class 42 · Syntax Error or Access Rule Violation
10
ambiguous_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
# 42P08 — Ambiguous parameter type
## At a glance {#a…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P0942P09
Class 42 · Syntax Error or Access Rule Violation
10
ambiguous_alias
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P09 — Ambiguous table alias
## At a glance {#at-a-gla…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P1042P10
Class 42 · Syntax Error or Access Rule Violation
10
invalid_column_reference
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P10 — Invalid column reference
## At a glanc…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P1142P11
Class 42 · Syntax Error or Access Rule Violation
10
invalid_cursor_definition
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P11 — Invalid cursor definition
## At a gla…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P1242P12
Class 42 · Syntax Error or Access Rule Violation
10
invalid_database_definition
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P12 — Invalid database definition
## At a…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P1342P13
Class 42 · Syntax Error or Access Rule Violation
10
invalid_function_definition
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P13 — Invalid function definition
## At a…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P1442P14
Class 42 · Syntax Error or Access Rule Violation
10
invalid_prepared_statement_definition
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P14 — Invalid prepared statement…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P1542P15
Class 42 · Syntax Error or Access Rule Violation
10
invalid_schema_definition
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P15 — Invalid schema definition
## At a gla…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P1642P16
Class 42 · Syntax Error or Access Rule Violation
10
invalid_table_definition
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P16 — Invalid table definition
## At a glanc…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P1742P17
Class 42 · Syntax Error or Access Rule Violation
10
invalid_object_definition
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P17 — Invalid object definition
## At a gla…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P1842P18
Class 42 · Syntax Error or Access Rule Violation
10
indeterminate_datatype
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P18 — Indeterminate datatype
## At a glance {#…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P1942P19
Class 42 · Syntax Error or Access Rule Violation
10
invalid_recursion
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42P19 — Invalid recursion
## At a glance {#at-a-glanc…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P2042P20
Class 42 · Syntax Error or Access Rule Violation
10
windowing_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
# 42P20 — Windowing error
## At a glance {#at-a-glance}
…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P2142P21
Class 42 · Syntax Error or Access Rule Violation
10
collation_mismatch
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# 42P21 — Collation mismatch
## At a glance {#at-a-glance}…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
42P2242P22
Class 42 · Syntax Error or Access Rule Violation
10
indeterminate_collation
11
12
13
14
15
16
17
18
19
20
9.1
9.2
9.3
9.4
9.5
9.6
# 42P22 — Indeterminate collation
## At a glance {#at…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4400044000
Class 44 · WITH CHECK OPTION Violation
10
with_check_option_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
# 44000 — with_check_option_violation
## At a glance {…SQLSTATE · Class 44 · WITH CHECK OPTION Violation
5300053000
Class 53 · Insufficient Resources
10
insufficient_resources
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 53000
## At a glance {#at-a-glance}
`53000` is the broad insuf…SQLSTATE · Class 53 · Insufficient Resources
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
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
pg17: choose a version ex: extensions only ↑↓ select ↵ open