# Postgres error 0A000: feature not supported

> The statement asks for something Postgres (or this server configuration) does not implement.

Source: https://scribase.com/postgres-errors/0a000

SQLSTATE class: Feature Not Supported. Over PostgREST/supabase-js this maps to HTTP 400.

## Causes

- Using a feature in a context that does not allow it, for example a set-returning function where it is not allowed, or FOR UPDATE with GROUP BY.
- Statements a connection pooler in transaction mode cannot carry across transactions, such as session-level advisory locks or LISTEN.
- Altering a column type that a view or rule depends on.

## Fixes

- Read the full message: it names the unsupported part. Rewrite the query around it (for example lock rows in a subquery, then aggregate).
- Use a session-mode or direct connection for features that need a persistent session.
- Drop and recreate dependent views around a column type change.