25005 — 分支事务没有活动 SQL 事务（no_active_sql_transaction_for_branch_transaction）
分支事务缺少活动的 SQL 事务。
英文手册覆盖始于 PostgreSQL 8.1. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
- aliases
- 未知
- class name
- Invalid Transaction State
- condition name
- no_active_sql_transaction_for_branch_transaction
- lang
- en
- sqlstate
- 25005
版本定义 PG 18
25005 — 分支事务没有活动 SQL 事务（no_active_sql_transaction_for_branch_transaction）
速览 {#at-a-glance}
25005 是分支事务版本的“没有活动 SQL 事务”条件，与 25P01 不同；固定 PostgreSQL 18.6 核心扫描没有解析出自然服务器调用点。
含义 {#meaning}
该码属于分支事务家族。普通会话在 BEGIN 外执行 SAVEPOINT 走的是其他页面展示的 25P01 路径，不应改称 25005。
诊断 {#diagnosis}
记录分支 API 操作以及当时是否有活动分支事务。固定扫描没有解析出核心报文，因此精确服务器文本必须来自实际发出该码的实现。
处理 {#response}
按该 API 契约结束或启动分支事务。不要仅凭名称套用通用回滚步骤，也不要伪造 PL/pgSQL 复现。
源码报文与运行边界 {#messages}
固定 errcodes.txt 定义了该条件和宏；raw/calls/REL_18_6.jsonl 的解析调用扫描没有直接报错组，因此本批不发布报文模板，也不构造自然 SQL 触发器。
适用边界与案例 {#case}
本批运行器在 PostgreSQL 18.6 与 10.21 的选定 case 均为 not_applicable，只记录源码边界，没有可复制的 SQL 触发过程。结构化证据 · 案例导出
版本与边界 {#versions}
锁定目录包含生成的历史成员事实。选定的 latest 与 PG10 case 都明确记录为仅源码边界，不算自然运行通过。
相关 {#related}
25P01 没有活动 SQL 事务、25003 分支事务访问模式、25P02 失败 SQL 事务。
来源 {#sources}
src.errcodes.18.6(SHA-2566e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba)src.calls.REL_18_6—raw/calls/REL_18_6.jsonl(SHA-2569ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf)
比较版本
SQLSTATE 证据与已记录的运行版本
cases · branch_transaction_boundary
{
"assertions": [
"No fabricated SQL trigger is included; the selected run records a definition/source boundary."
],
"case_id": "branch_transaction_boundary",
"cleanup": "Drop the case schema with an owner connection.",
"has_snippet": false,
"position": 0,
"preconditions": [
"A runner-owned disposable target is provisioned."
],
"repair": "Follow the explicit transaction or source boundary described by the case.",
"trigger": "Source/definition evidence only; no natural SQL trigger is claimed.",
"versions": [
"10",
"18"
]
}claims · identity
{
"claim_id": "identity",
"limits": "It is distinct from 25P01 no_active_sql_transaction.",
"method": "Read the fixed condition row and macro.",
"position": 0,
"runtime": [],
"sources": [
"src.errcodes.18.6"
],
"statement": "25005 is no_active_sql_transaction_for_branch_transaction in Class 25."
}claims · source-boundary
{
"claim_id": "source-boundary",
"limits": "No ordinary SQL trigger or format string is asserted.",
"method": "Scan fixed source call records for SQLSTATE 25005.",
"position": 1,
"runtime": [],
"sources": [
"src.calls.REL_18_6"
],
"statement": "The exhaustive resolved PostgreSQL 18.6 call scan contains no direct 25005 report group; this batch records definition evidence only."
}runtimes · runtime.25005-batch2-latest-20260909.latest · 18.6 (Homebrew) · not_applicable
{
"cases": [
"branch_transaction_boundary"
],
"limits": "",
"position": 0,
"raw": {
"case_manifest": {
"path": "verify/cases/25005/cases.json",
"sha256": "c231ee08c385544e970e4035dbd1ba239daab1baeb8f8c2f69bdc61f37e1453a"
},
"case_status": "not_applicable",
"cases": [
"branch_transaction_boundary"
],
"id": "runtime.25005-batch2-latest-20260909.latest",
"observed": {
"case_status": "not_applicable"
},
"raw": "verify/results/25005-batch2-latest-20260909/latest/raw.jsonl",
"raw_sha256": "5fcd5aeae18c6f30610715133b631ef0da3b18fc69783b39aa239641a71a14bf",
"run_id": "25005-batch2-latest-20260909",
"server_version": "18.6 (Homebrew)",
"server_version_num": 180006,
"status": "not_applicable",
"summary": "verify/results/25005-batch2-latest-20260909/latest/summary.json",
"summary_sha256": "c6e53e9208d851535466317c6f559e4cedcb45bd9c8bd3d4318ab20c854944d3",
"target": "latest",
"target_status": "passed"
},
"run_id": "25005-batch2-latest-20260909",
"runtime_id": "runtime.25005-batch2-latest-20260909.latest",
"server_version": "18.6 (Homebrew)",
"status": "not_applicable",
"target": "latest"
}runtimes · runtime.25005-batch2-pg10-20260909.pg10 · 10.21 (Debian 10.21-1.pgdg90+1) · not_applicable
{
"cases": [
"branch_transaction_boundary"
],
"limits": "",
"position": 1,
"raw": {
"case_manifest": {
"path": "verify/cases/25005/cases.json",
"sha256": "c231ee08c385544e970e4035dbd1ba239daab1baeb8f8c2f69bdc61f37e1453a"
},
"case_status": "not_applicable",
"cases": [
"branch_transaction_boundary"
],
"id": "runtime.25005-batch2-pg10-20260909.pg10",
"observed": {
"case_status": "not_applicable"
},
"raw": "verify/results/25005-batch2-pg10-20260909/pg10/raw.jsonl",
"raw_sha256": "9c3349caa7ecc2ae79a5043132f5f3a341139cf94e819341ae92aa1ec17b5f8f",
"run_id": "25005-batch2-pg10-20260909",
"server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
"server_version_num": 100021,
"status": "not_applicable",
"summary": "verify/results/25005-batch2-pg10-20260909/pg10/summary.json",
"summary_sha256": "3110b481d755a035443258247bd83acc2440a291b6ff257253454b6833f1b163",
"target": "pg10",
"target_status": "passed"
},
"run_id": "25005-batch2-pg10-20260909",
"runtime_id": "runtime.25005-batch2-pg10-20260909.pg10",
"server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
"status": "not_applicable",
"target": "pg10"
}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": ""
}来源引用
定义来源
center · PostgreSQL 18 · english-manuals:fbf2dace73fcc58ca5ff1fae4ea6efada33112fd07f81b2491520fc5a7c5d2d2
正文语言: zh-Hans · english-manuals:fbf2dace73fcc58ca5ff1fae4ea6efada33112fd07f81b2491520fc5a7c5d2d2