PostgreSQL Error Reference

Every error, explained

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

2768 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 408 of 2768 errors

0A000 ERROR

ttdummy (…): you cannot change … and/or … columns (use set_ttdummy) — 0A000

feature_not_supported

PostgreSQL error "ttdummy (…): you cannot change … and/or … columns (use set_ttdummy)" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY DEFAULT only available using COPY FROM — 0A000

feature_not_supported

PostgreSQL error "COPY DEFAULT only available using COPY FROM" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY delimiter must not appear in the DEFAULT specification — 0A000

feature_not_supported

PostgreSQL error "COPY delimiter must not appear in the DEFAULT specification" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

CSV quote character must not appear in the DEFAULT specification — 0A000

feature_not_supported

PostgreSQL error "CSV quote character must not appear in the DEFAULT specification" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

NULL specification and DEFAULT specification cannot be the same — 0A000

feature_not_supported

PostgreSQL error "NULL specification and DEFAULT specification cannot be the same" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

BUFFER_USAGE_LIMIT cannot be specified for VACUUM FULL — 0A000

feature_not_supported

PostgreSQL error "BUFFER_USAGE_LIMIT cannot be specified for VACUUM FULL" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ONLY_DATABASE_STATS cannot be specified with a list of tables — 0A000

feature_not_supported

PostgreSQL error "ONLY_DATABASE_STATS cannot be specified with a list of tables" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

ONLY_DATABASE_STATS cannot be specified with other VACUUM options — 0A000

feature_not_supported

PostgreSQL error "ONLY_DATABASE_STATS cannot be specified with other VACUUM options" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use JSON format with non-string output types — 0A000

feature_not_supported

PostgreSQL error "cannot use JSON format with non-string output types" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot set JSON encoding for non-bytea output types — 0A000

feature_not_supported

PostgreSQL error "cannot set JSON encoding for non-bytea output types" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

returning SETOF types is not supported in SQL/JSON functions — 0A000

feature_not_supported

PostgreSQL error "returning SETOF types is not supported in SQL/JSON functions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use JSON FORMAT ENCODING clause for non-bytea input types — 0A000

feature_not_supported

PostgreSQL error "cannot use JSON FORMAT ENCODING clause for non-bytea input types" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

client sent proto_version=n but server only supports protocol n or… — 0A000

feature_not_supported

PostgreSQL error "client sent proto_version=n but server only supports protocol n or lower" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

client sent proto_version=n but server only supports protocol n or… — 0A000

feature_not_supported

PostgreSQL error "client sent proto_version=n but server only supports protocol n or higher" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

COPY … requires CSV mode — 0A000

feature_not_supported

PostgreSQL error "COPY … requires CSV mode" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

tag filtering is not supported for login event triggers — 0A000

feature_not_supported

PostgreSQL error "tag filtering is not supported for login event triggers" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot match partition key to index on column “…” using non-equal o… — 0A000

feature_not_supported

PostgreSQL error "cannot match partition key to index on column "…" using non-equal operator "…"" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

don’t have transaction information for this type of tuple — 0A000

feature_not_supported

PostgreSQL error "don't have transaction information for this type of tuple" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

don’t have a storage tuple in this context — 0A000

feature_not_supported

PostgreSQL error "don't have a storage tuple in this context" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

returning pseudo-types is not supported in SQL/JSON functions — 0A000

feature_not_supported

PostgreSQL error "returning pseudo-types is not supported in SQL/JSON functions" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

huge pages not supported with the current “shared_memory_type” setting — 0A000

feature_not_supported

PostgreSQL error "huge pages not supported with the current "shared_memory_type" setting" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot enable failover for a replication slot created on the standby — 0A000

feature_not_supported

PostgreSQL error "cannot enable failover for a replication slot created on the standby" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot enable failover for a temporary replication slot — 0A000

feature_not_supported

PostgreSQL error "cannot enable failover for a temporary replication slot" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported
0A000 ERROR

cannot use … with a physical replication slot — 0A000

feature_not_supported

PostgreSQL error "cannot use … with a physical replication slot" (SQLSTATE 0A000, feature_not_supported): what it means, common causes, and how to fix it.

Feature Not Supported