02001 — no_additional_dynamic_result_sets_returned

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.

English manual coverage begins with PostgreSQL 8.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

aliases: Unknown
class name: No Data (this is also a warning class per the SQL standard)
condition name: no_additional_dynamic_result_sets_returned
lang: en
sqlstate: 02001

Definition PG 18

02001 — no_additional_dynamic_result_sets_returned

At a glance {#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 {#meaning}

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

Messages and diagnostics {#messages}

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

Diagnosis {#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 {#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 {#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.

Related {#related}

0100C concerns dynamic result sets returned; P0002 is PL/pgSQL no-data-found; 02000 is the general no-data condition.

Sources {#sources}

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

Compare versions

SQLSTATE evidence and recorded runtime versions

claims · identity

{
  "claim_id": "identity",
  "limits": "",
  "method": "Read the fixed errcodes definition row and macro.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "02001 is no_additional_dynamic_result_sets_returned in SQLSTATE Class 02."
}

claims · scan-boundary

{
  "claim_id": "scan-boundary",
  "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.",
  "method": "Compare resolved report groups with the fixed macro mapping.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.calls.REL_18_6",
    "src.errcodes.18.6"
  ],
  "statement": "No resolved 02001 report group was found in the locked PostgreSQL 18.6 core/contrib call scan."
}

claims · history-boundary

{
  "claim_id": "history-boundary",
  "limits": "Definition presence is not an emitting-path observation.",
  "method": "Compare the canonical release-definition facts with the available history boundary.",
  "position": 2,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "The locked release definitions establish catalogue presence, not a precise introducing release or runtime use."
}

sources · src.errcodes.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/utils/errcodes.txt",
  "position": 0,
  "sha256": "6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba",
  "source_id": "src.errcodes.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/errcodes.txt"
}

sources · src.calls.REL_18_6

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "raw/calls/REL_18_6.jsonl",
  "position": 1,
  "sha256": "9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf",
  "source_id": "src.calls.REL_18_6",
  "tag": "",
  "url": ""
}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · english-manuals:ce61c203aa8e7e84ba6b52a9d31be0e7bd12899db900b8b2ca77e4cc71e107df

Text language: en · english-manuals:ce61c203aa8e7e84ba6b52a9d31be0e7bd12899db900b8b2ca77e4cc71e107df