25004 — 分支事务隔离级别不适用（inappropriate_isolation_level_for_branch_transaction）
分支事务使用了不适用的隔离级别。
英文手册覆盖始于 PostgreSQL 8.1. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
- aliases
- 未知
- class name
- Invalid Transaction State
- condition name
- inappropriate_isolation_level_for_branch_transaction
- lang
- en
- sqlstate
- 25004
版本定义 PG 18
25004 — 分支事务隔离级别不适用（inappropriate_isolation_level_for_branch_transaction）
速览 {#at-a-glance}
25004 表示分支事务使用了不适用的隔离级别。固定 PostgreSQL 18.6 核心解析调用扫描没有该码的直接报错组，因此不声称存在普通 SQL 复现。
含义 {#meaning}
这是分支事务条件，区别于 40001 可串行化失败，也区别于普通事务中 SET TRANSACTION ISOLATION LEVEL 的检查。
诊断 {#diagnosis}
诊断时应同时保留分支 API、请求的隔离级别和事务状态。现有源码证据不足以借用其他隔离级别错误的报文。
处理 {#response}
修正分支 API 的隔离级别协商后，只有 API 明确定义可重试时才重试。普通 SQL 会话应按实际返回的 SQLSTATE 诊断。
源码报文与运行边界 {#messages}
固定 errcodes.txt 定义了该条件和宏；raw/calls/REL_18_6.jsonl 的解析调用扫描没有直接报错组，因此本批不发布报文模板，也不构造自然 SQL 触发器。
适用边界与案例 {#case}
本批运行器在 PostgreSQL 18.6 与 10.21 的选定 case 均为 not_applicable，只记录源码边界，没有可复制的 SQL 触发过程。结构化证据 · 案例导出
版本与边界 {#versions}
生成事实记录锁定的目录快照。两个 runner 目标都是 case 状态为 not_applicable 的源码边界观察，不把自然触发计入运行覆盖。
相关 {#related}
25003 分支事务访问模式、40001 可串行化失败、25P01 没有活动 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": "The condition name alone does not identify a supported ordinary-SQL trigger.",
"method": "Read the fixed condition row and macro.",
"position": 0,
"runtime": [],
"sources": [
"src.errcodes.18.6"
],
"statement": "25004 is inappropriate_isolation_level_for_branch_transaction in Class 25."
}claims · source-boundary
{
"claim_id": "source-boundary",
"limits": "Do not substitute a different isolation-level error or a hand-written RAISE example.",
"method": "Scan fixed source call records for SQLSTATE 25004.",
"position": 1,
"runtime": [],
"sources": [
"src.calls.REL_18_6"
],
"statement": "The exhaustive resolved PostgreSQL 18.6 call scan contains no direct 25004 report group; no natural SQL reproduction is claimed."
}runtimes · runtime.25004-batch2-latest-20260909.latest · 18.6 (Homebrew) · not_applicable
{
"cases": [
"branch_transaction_boundary"
],
"limits": "",
"position": 0,
"raw": {
"case_manifest": {
"path": "verify/cases/25004/cases.json",
"sha256": "6e616ecb1ea8026eef7515be693af96fad4452d1a1ad804a504546491178e206"
},
"case_status": "not_applicable",
"cases": [
"branch_transaction_boundary"
],
"id": "runtime.25004-batch2-latest-20260909.latest",
"observed": {
"case_status": "not_applicable"
},
"raw": "verify/results/25004-batch2-latest-20260909/latest/raw.jsonl",
"raw_sha256": "f0d2933f7323aca4846fa9d962b2bff160db9f8c65cb430f6c4f41662203eafc",
"run_id": "25004-batch2-latest-20260909",
"server_version": "18.6 (Homebrew)",
"server_version_num": 180006,
"status": "not_applicable",
"summary": "verify/results/25004-batch2-latest-20260909/latest/summary.json",
"summary_sha256": "6e892b767ad9feef596f0533e1b72620dd5c5e47cfef320c8ace0cfedffa3e7d",
"target": "latest",
"target_status": "passed"
},
"run_id": "25004-batch2-latest-20260909",
"runtime_id": "runtime.25004-batch2-latest-20260909.latest",
"server_version": "18.6 (Homebrew)",
"status": "not_applicable",
"target": "latest"
}runtimes · runtime.25004-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/25004/cases.json",
"sha256": "6e616ecb1ea8026eef7515be693af96fad4452d1a1ad804a504546491178e206"
},
"case_status": "not_applicable",
"cases": [
"branch_transaction_boundary"
],
"id": "runtime.25004-batch2-pg10-20260909.pg10",
"observed": {
"case_status": "not_applicable"
},
"raw": "verify/results/25004-batch2-pg10-20260909/pg10/raw.jsonl",
"raw_sha256": "f956881ba6ff4cc6f036e014e518813fffccb61a6044710a8d1a12d3fe44e8b2",
"run_id": "25004-batch2-pg10-20260909",
"server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
"server_version_num": 100021,
"status": "not_applicable",
"summary": "verify/results/25004-batch2-pg10-20260909/pg10/summary.json",
"summary_sha256": "aec6940d7ab31fd4a9e0fdd6639119dba287bada8c3195ab9e621e0a57bf8e1b",
"target": "pg10",
"target_status": "passed"
},
"run_id": "25004-batch2-pg10-20260909",
"runtime_id": "runtime.25004-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:ff3d8caa9aef4c97400e28e05ddec460333e1dcaefb43ffab988dd40b8df85f9
正文语言: zh-Hans · english-manuals:ff3d8caa9aef4c97400e28e05ddec460333e1dcaefb43ffab988dd40b8df85f9