PostgreSQL Error Reference

Every error, explained

SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.

3908 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 648 of 3908 errors

0A000 ERROR

subqueries within GRAPH_TABLE reference are not supported — 0A000

feature_not_supported

PostgreSQL error "subqueries within GRAPH_TABLE reference are not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

“*” is not supported here — 0A000

feature_not_supported

PostgreSQL error ""*" is not supported here" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

non-local element variable reference is not supported — 0A000

feature_not_supported

PostgreSQL error "non-local element variable reference is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

element pattern quantifier is not supported — 0A000

feature_not_supported

PostgreSQL error "element pattern quantifier is not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

unsupported element pattern kind: “…” — 0A000

feature_not_supported

PostgreSQL error "unsupported element pattern kind: "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

path pattern cannot start with an edge pattern — 0A000

feature_not_supported

PostgreSQL error "path pattern cannot start with an edge pattern" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

edge pattern must be preceded by a vertex pattern — 0A000

feature_not_supported

PostgreSQL error "edge pattern must be preceded by a vertex pattern" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

adjacent vertex patterns are not supported — 0A000

feature_not_supported

PostgreSQL error "adjacent vertex patterns are not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

path pattern cannot end with an edge pattern — 0A000

feature_not_supported

PostgreSQL error "path pattern cannot end with an edge pattern" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

multiple path patterns in one GRAPH_TABLE clause not supported — 0A000

feature_not_supported

PostgreSQL error "multiple path patterns in one GRAPH_TABLE clause not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

partition of hash-partitioned table cannot be split — 0A000

feature_not_supported

PostgreSQL error "partition of hash-partitioned table cannot be split" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

partition of hash-partitioned table cannot be merged — 0A000

feature_not_supported

PostgreSQL error "partition of hash-partitioned table cannot be merged" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

element patterns with same variable name “…” but different label ex… — 0A000

feature_not_supported

PostgreSQL error "element patterns with same variable name "…" but different label expressions are not supported" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot delete from view “…” using FOR PORTION OF “…” — 0A000

feature_not_supported

PostgreSQL error "cannot delete from view "…" using FOR PORTION OF "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

column “…” cannot be used in statistics because its type … has no d… — 0A000

feature_not_supported

PostgreSQL error "column "…" cannot be used in statistics because its type … has no default btree operator class" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

expression cannot be used in multivariate statistics because its ty… — 0A000

feature_not_supported

PostgreSQL error "expression cannot be used in multivariate statistics because its type … has no default btree operator class" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

INSERT…SELECT rule actions are not supported for queries having d… — 0A000

feature_not_supported

PostgreSQL error "INSERT...SELECT rule actions are not supported for queries having data-modifying statements in WITH" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

INSERT … SELECT rule actions are not supported for queries having… — 0A000

feature_not_supported

PostgreSQL error "INSERT ... SELECT rule actions are not supported for queries having data-modifying statements in WITH" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use column references in default expression — 0A000

feature_not_supported

PostgreSQL error "cannot use column references in default expression — 0A000" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot insert into view “…” — 0A000

feature_not_supported

PostgreSQL error "cannot insert into view … — 0A000" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot alter type of a column used by a view or rule — 0A000

feature_not_supported

PostgreSQL error "cannot alter type of a column used by a view or rule — 0A000" (SQLSTATE 0A000): what it means, common causes, and how to fix it.

Feature Not Supported
0B000 ERROR

Invalid Transaction Initiation — SQLSTATE 0B000

invalid_transaction_initiation

SQLSTATE 0B000 (invalid_transaction_initiation): A transaction could not be initiated.

Invalid Transaction Initiation
0F000 ERROR

Locator Exception — SQLSTATE 0F000

locator_exception

SQLSTATE 0F000 (locator_exception): A large-object locator is invalid.

Locator Exception
0F001 ERROR

Invalid Locator Specification — SQLSTATE 0F001

invalid_locator_specification

SQLSTATE 0F001 (invalid_locator_specification): A large-object locator is invalid.

Locator Exception