↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SQLSTATE / CLASS HV · FOREIGN DATA WRAPPER ERROR (SQL/MED)

HV014

Read PG 18 manual ↗

fdw_too_many_handles

SQLSTATE
HV014
Condition name
fdw_too_many_handles
Class
Foreign Data Wrapper Error (SQL/MED)
Source macro
ERRCODE_FDW_TOO_MANY_HANDLES
Evidence
Definition only
Analysis & operational context

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

<h1>HV014 — fdw_too_many_handles</h1>

At a glance

HV014 identifies an FDW condition involving too many handles. No resolved HV014 report group was found in the locked PostgreSQL 18.6 core/contrib call scan, so no native handle limit or message is attributed.

Meaning

A handle can be an implementation-owned reference to a connection, cursor, result, or execution object. The class definition does not specify the handle kind, scope of the limit, or whether the limit belongs to a wrapper, driver, or remote service.

Messages and diagnostics

No resolved 18.6 core/contrib message variant was found. Preserve the complete diagnostic, handle kind, count or limit if reported, operation phase, wrapper/driver version, and foreign server identity.

Diagnosis

Find the wrapper code that allocates or tracks handles and determine whether the limit is per statement, session, process, server, or remote connection. Check for handles that were not closed after errors, while keeping the wrapper's own ownership rules as the authority.

Response

Close or release the handles that the wrapper identifies as no longer needed, or use its supported pooling/limit configuration after confirming the scope. If a failed operation may have sent work remotely, verify remote state before retrying it.

Versions

HV014 is present in the locked definition snapshots from 9.1.24 through 18.6 and 19 Beta 3, with known_present_by 9.1.0. The available pre-9 definition material does not establish an exact introduction release.

Sources

  • errcodes.txt — definition, SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba.
  • fdwapi.h — generic FDW callback boundary.
  • Structured evidence — fixed 18.6 sources and bounded scan.

Source evidence

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

HV014 is fdw_too_many_handles in SQL/MED Class HV.

Method: Read the fixed errcodes definition row and macro.

src.errcodes.18.6

The condition name identifies an FDW handle-limit state. The handle kind, count scope, and owner remain implementation-specific because no emitting path was resolved.

Method: Read the fixed FDW callback signatures and FdwRoutine structure.

Limits: Generic API context is background only and does not prove an emitting path for this SQLSTATE.

src.fdwapi.18.6

No resolved HV014 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 wrappers, drivers, remote systems, or user callbacks; absence from the scan is not an absolute absence claim.

src.calls.REL_18_6 src.errcodes.18.6

The locked release definition snapshots establish presence from the known 9.1.0 boundary; the available pre-9 material does not establish an exact introduction release.

Method: Compare the canonical release-definition facts with the available pre-9 source boundary.

Limits: Definition presence does not prove runtime use.

src.errcodes.18.6

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.

Version history 1
  1. PG 9.0 → 9.1added

Definition snapshot: english-manuals:c056bc5908eab9f6dd617e36db4… · English manual source