SQLSTATE 0A000 ERROR Class 0A: Feature Not Supported

feature_not_supported Feature Not Supported — SQLSTATE 0A000

The requested feature is not supported in this context or version.

PG 12, 13, 14, 15, 16, 17, 18 Official docs
Last reviewed May 2025 Grounded in source

Symptoms

The requested feature is not supported in this context or version.

  • The error is written to the server log and returned to the client carrying SQLSTATE 0A000.
  • Any driver (libpq, JDBC, psycopg, npgsql, pgx) surfaces this code in its error object so you can branch on it programmatically.
  • PL/pgSQL can trap it by name: EXCEPTION WHEN feature_not_supported THEN.

Environment

Severity: ERROR  |  PostgreSQL versions: 12, 13, 14, 15, 16, 17

Reproduce with the exact statement and read the full message in the server log (raise log_min_messages / set log_min_error_statement for more context).

Root Cause

PostgreSQL parsed the request but cannot perform it as written — the feature is unavailable here.

Common causes:

  • Using a clause unsupported on this object (for example certain ALTER operations).
  • A feature that exists only in a newer PostgreSQL version.
  • An operation not allowed on a view, foreign table, or partition.

Diagnostic Queries

Recovery

Steps to resolve 0A000:

  1. Check the documentation for the exact statement and your version.
  2. Rewrite using a supported alternative (for example recreate instead of an unsupported ALTER).
  3. Upgrade PostgreSQL if the feature was added in a later release.

Reference: PostgreSQL error codes — Class 0A (Feature Not Supported).

Was this helpful?