↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / SQLSTATE

25003 — 分支事务访问模式不适用(inappropriate_access_mode_for_branch_transaction)

分支事务使用了不适用的访问模式。

英文手册覆盖始于 PostgreSQL 8.1. 来源历史与运行验证各自保留独立版本边界。

当前阅读 PG 18·选择有来源记录的版本

aliases
未知
class name
Invalid Transaction State
condition name
inappropriate_access_mode_for_branch_transaction
lang
en
sqlstate
25003

版本定义 PG 18

25003 — 分支事务访问模式不适用(inappropriate_access_mode_for_branch_transaction)

速览 {#at-a-glance}

25003 表示分支事务使用了不适用的访问模式。固定的 PostgreSQL 18.6 核心调用扫描没有解析出直接报错点,因此本文记录定义边界,不虚构普通 SQL 触发器。

含义 {#meaning}

该条件名属于 Class 25,描述的是分支事务管理。不要把它当作 25006 只读 SQL 事务、25P01 缺少事务块或应用自定义异常的同义词。

诊断 {#diagnosis}

若分支事务 API 报出此码,应保留精确 SQLSTATE、API 操作、访问模式和事务上下文。当前固定核心证据没有确认服务器报文模板,也没有安全的 SQL 复现。

处理 {#response}

先按分支事务 API 的契约修正访问模式,再决定是否重试。不要用 RAISE 替代缺失路径,也不要把普通只读语句误按此码重试。

源码报文与运行边界 {#messages}

固定 errcodes.txt 定义了该条件和宏;raw/calls/REL_18_6.jsonl 的解析调用扫描没有直接报错组,因此本批不发布报文模板,也不构造自然 SQL 触发器。

适用边界与案例 {#case}

本批运行器在 PostgreSQL 18.6 与 10.21 的选定 case 均为 not_applicable,只记录源码边界,没有可复制的 SQL 触发过程。结构化证据 · 案例导出

版本与边界 {#versions}

锁定目录按上方生成事实记录该条件的已知边界和快照。运行状态明确为不适用:两个选定 runner 目标记录的是仅源码边界,不是自然触发通过。

相关 {#related}

25004 分支事务隔离级别、25006 只读 SQL 事务、25P01 没有活动 SQL 事务。

来源 {#sources}

  • src.errcodes.18.6 (SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba)
  • src.calls.REL_18_6 — raw/calls/REL_18_6.jsonl (SHA-256 9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf)

比较版本

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 name describes a branch-transaction access-mode condition; it is not a proof that ordinary SQL can raise it.",
  "method": "Read the fixed condition row and macro.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "25003 is inappropriate_access_mode_for_branch_transaction in Class 25."
}
claims · source-boundary
{
  "claim_id": "source-boundary",
  "limits": "An extension or a branch-transaction API may have a separate path; this page does not invent one.",
  "method": "Scan fixed source call records for SQLSTATE 25003.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.calls.REL_18_6"
  ],
  "statement": "The exhaustive resolved PostgreSQL 18.6 call scan contains no direct 25003 report group, so this batch does not claim a natural SQL trigger or message template."
}
runtimes · runtime.25003-batch2-latest-20260909.latest · 18.6 (Homebrew) · not_applicable
{
  "cases": [
    "branch_transaction_boundary"
  ],
  "limits": "",
  "position": 0,
  "raw": {
    "case_manifest": {
      "path": "verify/cases/25003/cases.json",
      "sha256": "ab9486aa7775f7f7f49791e18adfa961e13759a247deb73819a9434ded03846d"
    },
    "case_status": "not_applicable",
    "cases": [
      "branch_transaction_boundary"
    ],
    "id": "runtime.25003-batch2-latest-20260909.latest",
    "observed": {
      "case_status": "not_applicable"
    },
    "raw": "verify/results/25003-batch2-latest-20260909/latest/raw.jsonl",
    "raw_sha256": "5c00b2a0692b3a3c48b5465ae1db681bc3edcee9444e22ab515368775a6aab89",
    "run_id": "25003-batch2-latest-20260909",
    "server_version": "18.6 (Homebrew)",
    "server_version_num": 180006,
    "status": "not_applicable",
    "summary": "verify/results/25003-batch2-latest-20260909/latest/summary.json",
    "summary_sha256": "603b6af5a7fde2bf4c7503816af9ec8e091cf9eb5125d6efa324eb08590aa00d",
    "target": "latest",
    "target_status": "passed"
  },
  "run_id": "25003-batch2-latest-20260909",
  "runtime_id": "runtime.25003-batch2-latest-20260909.latest",
  "server_version": "18.6 (Homebrew)",
  "status": "not_applicable",
  "target": "latest"
}
runtimes · runtime.25003-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/25003/cases.json",
      "sha256": "ab9486aa7775f7f7f49791e18adfa961e13759a247deb73819a9434ded03846d"
    },
    "case_status": "not_applicable",
    "cases": [
      "branch_transaction_boundary"
    ],
    "id": "runtime.25003-batch2-pg10-20260909.pg10",
    "observed": {
      "case_status": "not_applicable"
    },
    "raw": "verify/results/25003-batch2-pg10-20260909/pg10/raw.jsonl",
    "raw_sha256": "a34c4d65a6b30ab85b31ca178d2a9bc17cc837d4396f8df4736ff3e4d7aa5c7b",
    "run_id": "25003-batch2-pg10-20260909",
    "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
    "server_version_num": 100021,
    "status": "not_applicable",
    "summary": "verify/results/25003-batch2-pg10-20260909/pg10/summary.json",
    "summary_sha256": "d335d9fd5997ab7dcc342f129beba862143021dd8daa2e39465606587a00f4c6",
    "target": "pg10",
    "target_status": "passed"
  },
  "run_id": "25003-batch2-pg10-20260909",
  "runtime_id": "runtime.25003-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": ""
}

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · english-manuals:fcfebd7818813a251b423b245dffe5f69644e6a4200449fec96a4f28e3f56068

正文语言: zh-Hans · english-manuals:fcfebd7818813a251b423b245dffe5f69644e6a4200449fec96a4f28e3f56068