SQLSTATE / CLASS 02 · NO DATA (THIS IS ALSO A WARNING CLASS PER THE SQL STANDARD)

02001

no_additional_dynamic_result_sets_returned

SQLSTATE: 02001
Condition name: no_additional_dynamic_result_sets_returned
Class: No Data (this is also a warning class per the SQL standard)
Source macro: ERRCODE_NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED
Evidence: Definition only

Analysis & operational context

English SQLSTATE atlas: authored explanations and source/runtime evidence are separate from the manual definitions. View source ↗

<h1>02001 — no_additional_dynamic_result_sets_returned</h1>

At a glance

02001 is a no-data-category condition about additional dynamic result sets, not about an ordinary query returning no rows. No resolved 18.6 core/contrib report group was found.

Meaning

The definition names exhaustion of additional dynamic result sets, but the fixed source scan does not identify an implementation path.

Messages and diagnostics

No resolved 18.6 message variant was found. Preserve the producing routine/interface, result-set position, client API, and complete diagnostics.

Diagnosis

Locate the dynamic-result-set contract that produced the code and determine whether the caller requested another result set. Do not substitute ordinary row-count checks or PL/pgSQL NO_DATA_FOUND handling.

Response

Handle the end of the result-set sequence according to the identified interface, or correct the caller's expected count. An unchanged transaction retry does not create another result set.

Versions

02001 is present from the locked 9.0.23 snapshot through 18.6 and 19 Beta 3, with known_present_by 7.4. This is definition evidence only for the fixed 18.6 scan.

Sources

errcodes.txt — definition, SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba.
Structured evidence — fixed sources, message groups, and runtime boundary.

Source evidence

Evidence belongs to the frozen source and runtime versions listed here. It is not a runtime verification of the selected manual version.

02001 is no_additional_dynamic_result_sets_returned in SQLSTATE Class 02.

Method: Read the fixed errcodes definition row and macro.

src.errcodes.18.6

No resolved 02001 report group was found in the locked PostgreSQL 18.6 core/contrib call scan.

Method: Compare resolved report groups with the fixed macro mapping.

Limits: This scan does not cover external clients, drivers, extensions, remote systems, or other implementations; absence from the scan is not an absolute absence claim.

src.calls.REL_18_6 src.errcodes.18.6

The locked release definitions establish catalogue presence, not a precise introducing release or runtime use.

Method: Compare the canonical release-definition facts with the available history boundary.

Limits: Definition presence is not an emitting-path observation.

src.errcodes.18.6

src/backend/utils/errcodes.txt · REL_18_6 ·
724edf9bde9d356724ad384a2e196edc3c9f80f7
raw/calls/REL_18_6.jsonl · ·

Message templates

No extracted message template is attached to this condition.

Reproduction & repair cases

No reproduction case is attached to this condition.

Recorded runtime evidence

No runtime observation is attached to this entry.

Definition snapshot: english-manuals:1804cc614ca1149b517d872caf2… · English manual source