WITH CHECK 子句
已记录的来源状态与原始语言说明；缺少版本证据时明确标为未知。
来源快照记录 PostgreSQL 8.1–18 的变化节点；历史矩阵独立记录 7.4–18 的状态。两者均未记录 PostgreSQL 19 或 20 的支持状态，较新版本明确保留为未知。这些来源声明与运行测量相互独立。
视图和物化视图
说明
自动可更新视图现在可以指定 INSERT 或 UPDATE 是否会更改行的状态，使其在视图中不再可见。使用 WITH CHECK OPTION 将防止任何此类更改发生。
所选版本: PostgreSQL 18
支持
比较版本
原始文档链接
已记录旧标识: 264
完整来源事实与出处
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "with-check-clause",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "WITH CHECK clause",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "WITH CHECK clause",
"NameLocale": "en",
"GroupKey": "views-materialized-views",
"GroupName": "Views \u0026 Materialized Views",
"GroupLocale": "en",
"Ordinal": 5,
"GroupOrder": 8,
"Facts": {
"feature": {
"description": "Auto-updatable views can now specify whether an INSERT or UPDATE would change the state of the row so that it would no longer be visible in the view. Using WITH CHECK OPTION will prevent any such changes from occuring.",
"name": "WITH CHECK clause",
"versions": {
"9.4": "Yes"
}
},
"group": "Views \u0026 Materialized Views",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "14",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.4",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.5",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.6",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.4",
"Supported": true,
"Original": "Yes"
}
],
"Texts": [
{
"Locale": "en",
"Title": "WITH CHECK clause",
"BodyHTML": "\u003cp\u003eAuto-updatable views can now specify whether an INSERT or UPDATE would change the state of the row so that it would no longer be visible in the view. Using WITH CHECK OPTION will prevent any such changes from occuring.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "9fbcca6ff3395fe726d594700775564b87c0e904bcede78a64a132767ce002c1",
"Payload": {
"description": "Auto-updatable views can now specify whether an INSERT or UPDATE would change the state of the row so that it would no longer be visible in the view. Using WITH CHECK OPTION will prevent any such changes from occuring.",
"name": "WITH CHECK clause",
"versions": {
"9.4": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "WITH CHECK 子句",
"BodyHTML": "\u003cp\u003e自动可更新视图现在可以指定 INSERT 或 UPDATE 是否会更改行的状态，使其在视图中不再可见。使用 WITH CHECK OPTION 将防止任何此类更改发生。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "c2809ad1189c1ea60887f494b1867454bc5d1bebac5f9a6aab3f6dfdf2f8c8d7",
"Payload": {
"description": "自动可更新视图现在可以指定 INSERT 或 UPDATE 是否会更改行的状态，使其在视图中不再可见。使用 WITH CHECK OPTION 将防止任何此类更改发生。",
"name": "WITH CHECK 子句"
}
}
],
"GroupTitles": {
"en": "Views \u0026 Materialized Views",
"zh-Hans": "视图和物化视图"
},
"LegacyIDs": [
"264"
]
}