undefined_object Undefined Object — SQLSTATE 42704

A referenced object (type, collation, constraint, etc.) does not exist.

• The error is written to the server log and returned to the client carrying SQLSTATE 42704.
• 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 undefined_object THEN.

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).

The named object is missing from the database or the current search_path.

Steps to resolve 42704:

1. Check the object name and schema.
2. Create or install the missing object or extension (CREATE EXTENSION ...;).

Reference: PostgreSQL error codes — Class 42 (Syntax Error or Access Rule Violation).