SQLSTATE 01003 WARNING Class 01: Warning

null_value_eliminated_in_set_function Null Value Eliminated In Set Function — SQLSTATE 01003

SQLSTATE 01003 (null_value_eliminated_in_set_function): The statement succeeded but the server attached a warning.

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

Symptoms

The server reports SQLSTATE 01003 (null_value_eliminated_in_set_function), a condition in the Warning class.

  • The error is written to the server log and returned to the client carrying SQLSTATE 01003.
  • Any driver (libpq, JDBC, psycopg, npgsql, pgx) surfaces this code in its error object so you can branch on it programmatically.

Environment

Severity: WARNING  |  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

01003 belongs to Class 01 — Warning. In this class, the statement succeeded but the server attached a warning.

The first two characters (01) identify the error class, so application code can match the whole class via 01000 when the specific code is not needed.

Diagnostic Queries

Recovery

Read the warning text — the statement completed, but review the data or query it flagged (truncation, deprecated feature, eliminated nulls) before relying on the result.

Reference: PostgreSQL error codes — Class 01 (Warning).

Was this helpful?