39001
Read PG 18 manual ↗invalid_sqlstate_returned
- SQLSTATE
- 39001
- Condition name
- invalid_sqlstate_returned
- Class
- External Routine Invocation Exception
- Source macro
- ERRCODE_E_R_I_E_INVALID_SQLSTATE_RETURNED
- Evidence
- Definition only
English SQLSTATE atlas: authored explanations and source/runtime evidence are separate from the manual definitions. View source ↗
At a glance
The fixed definition contains this member, but the resolved PostgreSQL 18.6 core/contrib scan found no report group. The name describes an external routine returning an invalid SQLSTATE; it does not identify a current PostgreSQL handler path.
Meaning
Keep the returned text, external language, routine, and wrapper that rejected it. Do not replace the member with XX000 or infer the bad value from a routine name.
Messages
No fixed PostgreSQL message variant was adopted because the bounded scan did not resolve a native report group.
Diagnosis
Find the fixed external routine handler or driver validator and inspect the five-character value and message. The bounded scan leaves the native source boundary unresolved.
Response
Repair the routine’s returned SQLSTATE or the interface contract according to its owner. Do not retry until the invalid return and completion state are understood.
Versions
The locked catalogue places this condition at least by PostgreSQL 7.4. The facts block lists the published snapshots; source-path status is limited to the fixed PostgreSQL 18.6 evidence below.
Sources
See the fixed source links and message limits in the structured evidence record.
Source evidence
Evidence belongs to the frozen source and runtime versions listed here. It is not a runtime verification of the selected manual version.
39001 is invalid_sqlstate_returned in SQLSTATE Class 39.
Method: Read the fixed errcodes definition row, severity, and macro.
No resolved 39001 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: The scan does not cover external wrappers, drivers, extensions, remote systems, or user code; absence from this scan is not absolute.
Locked release definitions establish catalogue presence from 7.4; they do not establish a precise introducing release or runtime use.
Method: Compare canonical release facts with the available history boundary.
Limits: Definition presence is not an emitting-path observation.
- 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:bd41e2e31e9f9606b043281aa55… · English manual source