try_or_bye

// troubleshooting guide · cockroachdb

CockroachDB 'Not Supported' / Postgres Compatibility Errors Fix

Status
Ongoing
platforms:
Self-hosted and CockroachDB Cloud
updated:
November 15, 2026
reports:
4
Method
how we research
Share

RUNBOOK · cockroachdb/postgres-incompatible-errors4 FIXES

// quick answer

CockroachDB speaks the PostgreSQL wire protocol but not every feature, so migrations hit 'unimplemented' errors for some extensions, triggers, stored procedure features and types.

Most likely fix: Read the error number

How to fix it

// try these in order, the most common fix is first

  1. FIX 1Read the error number

    1. 01Search the 'unimplemented' issue link in the error message on GitHub; many have workarounds
    Did this fix it?

  2. FIX 2Use the Schema Conversion tool

    1. 01Run MOLT Schema Conversion and MOLT Fetch to find and fix incompatible DDL before migrating
    Did this fix it?

  3. FIX 3Adapt IDs and sequences

    1. 01Use UUID primary keys or the sql.defaults.serial_normalization setting
    2. 02Avoid relying on gap-free sequences
    Did this fix it?

  4. FIX 4Check compatibility before committing

    1. 01Test your ORM and drivers on a trial cluster
    2. 02If too many gaps, consider Aurora, Postgres or YugabyteDB
    Did this fix it?

Symptoms

ERROR: unimplemented; feature not supported; pg_dump import fails; ORM migration errors; SERIAL behaves differently.

Why it happens

  • C-01Postgres extensions or features CockroachDB lacks or only partly supports
  • C-02SERIAL creates unique_rowid() values, not sequential integers
  • C-03Different default isolation (SERIALIZABLE) and locking behavior
  • C-04ORM or driver assuming Postgres internals (pg_catalog differences)

// this guide also covers

  • cockroachdb unimplemented
  • cockroachdb postgres compatibility
  • cockroachdb not supported
  • cockroachdb vs postgres differences
  • cockroachdb pg_dump import error

Still not working?

If CockroachDB keeps failing, you're not alone. See every CockroachDB problem users report or the alternatives people switch to.

Have an app idea? Our small team builds any software: web and mobile apps, games, desktop, AI tools. Price agreed together.

Talk to us

Watch CockroachDB Get an email when its price changes, it has an outage, or we publish a new fix. No spam.

Fixed it? Share this guide

The same problem in other apps

All not loading, error messages & connection guides →

Other CockroachDB errors