25007 — 不支持混合模式与数据语句（schema_and_data_statement_mixing_not_supported）
事务中不支持混合模式语句与数据语句。
英文手册覆盖始于 PostgreSQL 8.1. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
- aliases
- 未知
- class name
- Invalid Transaction State
- condition name
- schema_and_data_statement_mixing_not_supported
- lang
- en
- sqlstate
- 25007
版本定义 PG 18
25007 — 不支持混合模式与数据语句（schema_and_data_statement_mixing_not_supported）
速览 {#at-a-glance}
25007 表示混合模式语句与数据语句的事务状态条件。固定 PostgreSQL 18.6 核心扫描没有解析出直接报错组，因此本文不制造 SQL 示例。
含义 {#meaning}
该条件名描述狭窄的语句组合边界，不能泛化为语法错误、只读事务错误或活动事务错误。
诊断 {#diagnosis}
应同时保留协议或 API 操作、语句序列和服务器精确 SQLSTATE。固定核心证据没有可引用的报文模板，也没有确认安全的自然案例。
处理 {#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 目标的 case 都是 not_applicable 源码边界，不声称有自然运行覆盖。
相关 {#related}
25006 只读 SQL 事务、25008 持有游标隔离级别、25P01 没有活动 SQL 事务。
来源 {#sources}
src.errcodes.18.6(SHA-2566e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba)src.calls.REL_18_6—raw/calls/REL_18_6.jsonl(SHA-2569ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf)
比较版本
SQLSTATE 证据与已记录的运行版本
cases · schema_data_statement_boundary
{
"assertions": [
"No fabricated SQL trigger is included; the selected run records a definition/source boundary."
],
"case_id": "schema_data_statement_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 points to a statement-composition boundary, not a generic DDL error.",
"method": "Read the fixed condition row and macro.",
"position": 0,
"runtime": [],
"sources": [
"src.errcodes.18.6"
],
"statement": "25007 is schema_and_data_statement_mixing_not_supported in Class 25."
}claims · source-boundary
{
"claim_id": "source-boundary",
"limits": "This batch does not turn SQL/MED or protocol-only assumptions into a backend case.",
"method": "Scan fixed source call records for SQLSTATE 25007.",
"position": 1,
"runtime": [],
"sources": [
"src.calls.REL_18_6"
],
"statement": "The exhaustive resolved PostgreSQL 18.6 call scan contains no direct 25007 report group; no natural SQL reproduction or message template is published here."
}runtimes · runtime.25007-batch2-latest-20260909.latest · 18.6 (Homebrew) · not_applicable
{
"cases": [
"schema_data_statement_boundary"
],
"limits": "",
"position": 0,
"raw": {
"case_manifest": {
"path": "verify/cases/25007/cases.json",
"sha256": "67528005b2b118f14485e2ae1985c95db2ebd71747e096284928827db74b708a"
},
"case_status": "not_applicable",
"cases": [
"schema_data_statement_boundary"
],
"id": "runtime.25007-batch2-latest-20260909.latest",
"observed": {
"case_status": "not_applicable"
},
"raw": "verify/results/25007-batch2-latest-20260909/latest/raw.jsonl",
"raw_sha256": "9d49d76e1cf0b453fb58c1555208f6067dfeee21354a6c72e2130925d80890ce",
"run_id": "25007-batch2-latest-20260909",
"server_version": "18.6 (Homebrew)",
"server_version_num": 180006,
"status": "not_applicable",
"summary": "verify/results/25007-batch2-latest-20260909/latest/summary.json",
"summary_sha256": "ec85372f3a83dd2b9de52641c1c453a42fdf5e70bc858036603cb43256986af2",
"target": "latest",
"target_status": "passed"
},
"run_id": "25007-batch2-latest-20260909",
"runtime_id": "runtime.25007-batch2-latest-20260909.latest",
"server_version": "18.6 (Homebrew)",
"status": "not_applicable",
"target": "latest"
}runtimes · runtime.25007-batch2-pg10-20260909.pg10 · 10.21 (Debian 10.21-1.pgdg90+1) · not_applicable
{
"cases": [
"schema_data_statement_boundary"
],
"limits": "",
"position": 1,
"raw": {
"case_manifest": {
"path": "verify/cases/25007/cases.json",
"sha256": "67528005b2b118f14485e2ae1985c95db2ebd71747e096284928827db74b708a"
},
"case_status": "not_applicable",
"cases": [
"schema_data_statement_boundary"
],
"id": "runtime.25007-batch2-pg10-20260909.pg10",
"observed": {
"case_status": "not_applicable"
},
"raw": "verify/results/25007-batch2-pg10-20260909/pg10/raw.jsonl",
"raw_sha256": "f5b6ca10542fbb30d88cf5f0bb8cb6d386c1c7246f4d0ab3f0d60ffd180c5758",
"run_id": "25007-batch2-pg10-20260909",
"server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
"server_version_num": 100021,
"status": "not_applicable",
"summary": "verify/results/25007-batch2-pg10-20260909/pg10/summary.json",
"summary_sha256": "c98d845addf0188ae17a7182426ddf65dd4e4803df7554930d1c484d311dfccc",
"target": "pg10",
"target_status": "passed"
},
"run_id": "25007-batch2-pg10-20260909",
"runtime_id": "runtime.25007-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:c5bd2981756cd2a35a616c0ccf362ac123de0b1df0c3f69f0ffd88dd67b21b68
正文语言: zh-Hans · english-manuals:c5bd2981756cd2a35a616c0ccf362ac123de0b1df0c3f69f0ffd88dd67b21b68