Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Popular entries9756
2B0002B000
Class 2B · Dependent Privilege Descriptors Still Exist
10
dependent_privilege_descriptors_still_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
# 2B000 — dependent_pri…SQLSTATE · Class 2B · Dependent Privilege Descriptors Still Exist
2BP012BP01
Class 2B · Dependent Privilege Descriptors Still Exist
10
dependent_objects_still_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
# 2BP01 — dependent_objects_still_exi…SQLSTATE · Class 2B · Dependent Privilege Descriptors Still Exist
2D0002D000
Class 2D · Invalid Transaction Termination
10
invalid_transaction_termination
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2D000 — invalid_transaction_termination
## A…SQLSTATE · Class 2D · Invalid Transaction Termination
2F0002F000
Class 2F · SQL Routine Exception
10
sql_routine_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
# 2F000
## At a glance {#at-a-glance}
SQLSTATE 2F000 is the SQL Ro…SQLSTATE · Class 2F · SQL Routine Exception
2F0022F002
Class 2F · SQL Routine Exception
10
modifying_sql_data_not_permitted
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2F002
## At a glance {#at-a-glance}
SQLSTATE 2F002 na…SQLSTATE · Class 2F · SQL Routine Exception
2F0032F003
Class 2F · SQL Routine Exception
10
prohibited_sql_statement_attempted
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2F003
## At a glance {#at-a-glance}
The fixed scan …SQLSTATE · Class 2F · SQL Routine Exception
2F0042F004
Class 2F · SQL Routine Exception
10
reading_sql_data_not_permitted
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 2F004
## At a glance {#at-a-glance}
The catalogue defin…SQLSTATE · Class 2F · SQL Routine Exception
2F0052F005
Class 2F · SQL Routine Exception
10
function_executed_no_return_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
# 2F005
## At a glance {#at-a-glance}
PL/pgSQL rep…SQLSTATE · Class 2F · SQL Routine Exception
3400034000
Class 34 · Invalid Cursor Name
10
invalid_cursor_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
# 34000 — invalid_cursor_name
## At a glance {#at-a-glance}
`34000` m…SQLSTATE · Class 34 · Invalid Cursor Name
3800038000
Class 38 · External Routine Exception
10
external_routine_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
# 38000
## At a glance {#at-a-glance}
Class 38 is broad.…SQLSTATE · Class 38 · External Routine Exception
3800138001
Class 38 · External Routine Exception
10
containing_sql_not_permitted
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 38001
## At a glance {#at-a-glance}
The fixed defini…SQLSTATE · Class 38 · External Routine Exception
3800238002
Class 38 · External Routine Exception
10
modifying_sql_data_not_permitted
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 38002
## At a glance {#at-a-glance}
This Class 3…SQLSTATE · Class 38 · External Routine Exception
3800338003
Class 38 · External Routine Exception
10
prohibited_sql_statement_attempted
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 38003
## At a glance {#at-a-glance}
The Class …SQLSTATE · Class 38 · External Routine Exception
3800438004
Class 38 · External Routine Exception
10
reading_sql_data_not_permitted
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 38004
## At a glance {#at-a-glance}
The Class 38 m…SQLSTATE · Class 38 · External Routine Exception
3900039000
Class 39 · External Routine Invocation Exception
10
external_routine_invocation_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
# 39000
## At a glance {#at-a-glanc…SQLSTATE · Class 39 · External Routine Invocation Exception
3900139001
Class 39 · External Routine Invocation Exception
10
invalid_sqlstate_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
# 39001
## At a glance {#at-a-glance}
The fixe…SQLSTATE · Class 39 · External Routine Invocation Exception
3900439004
Class 39 · External Routine Invocation 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
# 39004
## At a glance {#at-a-glance}
39004 is `n…SQLSTATE · Class 39 · External Routine Invocation Exception
39P0139P01
Class 39 · External Routine Invocation Exception
10
trigger_protocol_violated
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 39P01
## At a glance {#at-a-glance}
39P01 is…SQLSTATE · Class 39 · External Routine Invocation Exception
39P0239P02
Class 39 · External Routine Invocation Exception
10
srf_protocol_violated
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 39P02
## At a glance {#at-a-glance}
39P02 is `sr…SQLSTATE · Class 39 · External Routine Invocation Exception
39P0339P03
Class 39 · External Routine Invocation Exception
10
event_trigger_protocol_violated
11
12
13
14
15
16
17
18
19
20
9.5
9.6
# 39P03
## At a glance {#at-a-glance}
39P03 is `event_trigge…SQLSTATE · Class 39 · External Routine Invocation Exception
3B0003B000
Class 3B · Savepoint Exception
10
savepoint_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
# 3B000 — savepoint_exception
## At a glance {#at-a-glance}
`3B000` i…SQLSTATE · Class 3B · Savepoint Exception
3B0013B001
Class 3B · Savepoint Exception
10
invalid_savepoint_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
# 3B001 — invalid_savepoint_specification
## At a glance {…SQLSTATE · Class 3B · Savepoint Exception
3D0003D000
Class 3D · Invalid Catalog Name
10
invalid_catalog_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
# 3D000
## At a glance {#at-a-glance}
SQLSTATE `3D000` is **invalid_…SQLSTATE · Class 3D · Invalid Catalog Name
3F0003F000
Class 3F · Invalid Schema Name
10
invalid_schema_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
# 3F000
## At a glance {#at-a-glance}
SQLSTATE `3F000` is **invalid_sc…SQLSTATE · Class 3F · Invalid Schema Name
4000040000
Class 40 · Transaction Rollback
10
transaction_rollback
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 40000 — transaction_rollback
## At a glance {#at-a-glance}
`40000…SQLSTATE · Class 40 · Transaction Rollback
4000140001
Class 40 · Transaction Rollback
10
serialization_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
## At a glance {#at-a-glance}
`40001` is PostgreSQL's `serializatio…SQLSTATE · Class 40 · Transaction Rollback
4000240002
Class 40 · Transaction Rollback
10
transaction_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
# 40002 — transaction_integrity_constraint_viol…SQLSTATE · Class 40 · Transaction Rollback
4000340003
Class 40 · Transaction Rollback
10
statement_completion_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
# 40003 — statement_completion_unknown
## At a glance {#at-a…SQLSTATE · Class 40 · Transaction Rollback
40P0140P01
Class 40 · Transaction Rollback
10
deadlock_detected
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}
`40P01` is PostgreSQL's `deadlock_detecte…SQLSTATE · Class 40 · Transaction Rollback
4200042000
Class 42 · Syntax Error or Access Rule Violation
10
syntax_error_or_access_rule_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
# 42000
## At a glance {#at-a-glanc…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4250142501
Class 42 · Syntax Error or Access Rule Violation
10
insufficient_privilege
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42501
## At a glance {#at-a-glance}
SQLSTATE `4…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4260142601
Class 42 · Syntax Error or Access Rule Violation
10
syntax_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
# 42601
## At a glance {#at-a-glance}
SQLSTATE `42601` is *…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4260242602
Class 42 · Syntax Error or Access Rule Violation
10
invalid_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
# 42602
## At a glance {#at-a-glance}
SQLSTATE `42602` is *…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4261142611
Class 42 · Syntax Error or Access Rule Violation
10
invalid_column_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
# 42611
## At a glance {#at-a-glance}
SQLSTATE…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4262242622
Class 42 · Syntax Error or Access Rule Violation
10
name_too_long
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42622
## At a glance {#at-a-glance}
SQLSTATE `42622` is …SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4270142701
Class 42 · Syntax Error or Access Rule Violation
10
duplicate_column
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42701
## At a glance {#at-a-glance}
SQLSTATE `42701` …SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4270242702
Class 42 · Syntax Error or Access Rule Violation
10
ambiguous_column
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42702
## At a glance {#at-a-glance}
SQLSTATE `42702` …SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4270342703
Class 42 · Syntax Error or Access Rule Violation
10
undefined_column
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42703
## At a glance {#at-a-glance}
SQLSTATE `42703` …SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4270442704
Class 42 · Syntax Error or Access Rule Violation
10
undefined_object
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42704
## At a glance {#at-a-glance}
SQLSTATE `42704` …SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
4271042710
Class 42 · Syntax Error or Access Rule Violation
10
duplicate_object
11
12
13
14
15
16
17
18
19
20
9.0
9.1
9.2
9.3
9.4
9.5
9.6
# 42710 — Duplicate object
## At a glance {#at-a-glance}…SQLSTATE · Class 42 · Syntax Error or Access Rule Violation
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
pg17: choose a version ex: extensions only ↑↓ select ↵ open