SQLSTATE 00000 LOG Class 00: Successful Completion

successful_completion Successful Completion — SQLSTATE 00000

SQLSTATE 00000 (successful_completion): The operation completed successfully — this is not an error.

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

Symptoms

The server reports SQLSTATE 00000 (successful_completion), a condition in the Successful Completion class.

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

Environment

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

00000 belongs to Class 00 — Successful Completion. In this class, the operation completed successfully — this is not an error.

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

Diagnostic Queries

Recovery

No action is required. This status indicates normal, successful completion.

Reference: PostgreSQL error codes — Class 00 (Successful Completion).

Was this helpful?