标记为 NOT VALID 的外键
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
No translation of this description is recorded. The original Chinese description is shown. The source label is retained in Chinese; no translated label is recorded.
性能
Description
引入了创建外键时的新选项 NOT VALID，之后可以修改为 VALIDATED 并执行验证检查。这使得你可以在对读写操作影响最小的情况下添加外键。
Selected version: PostgreSQL 18
No
Compare versions
Original documentation links
Related source snapshot entry · The original source supplies this relationship; each matrix retains its own states.
Complete source facts and provenance
legacy · center · ed4d7401f73984da4b671c96b06b18b0171f428ddf5b33f568e737c24b005862
{
"Key": "214",
"SourceKind": "legacy",
"SourceDatabase": "center",
"SourceTable": "featurematrix_feature",
"SourceKey": "214",
"SourceHash": "ed4d7401f73984da4b671c96b06b18b0171f428ddf5b33f568e737c24b005862",
"Name": "标记为 NOT VALID 的外键",
"NameLocale": "zh-Hans",
"GroupKey": "1",
"GroupName": "性能",
"GroupLocale": "zh-Hans",
"Ordinal": 0,
"GroupOrder": 10,
"Facts": {
"featuredescription": "引入了创建外键时的新选项 NOT VALID，之后可以修改为 VALIDATED 并执行验证检查。这使得你可以在对读写操作影响最小的情况下添加外键。",
"featurename": "标记为 NOT VALID 的外键",
"group_id": 1,
"id": 214,
"v10": 1,
"v11": 1,
"v12": 1,
"v13": 1,
"v14": 0,
"v15": 0,
"v16": 0,
"v17": 0,
"v18": 0,
"v74": 0,
"v80": 0,
"v81": 0,
"v82": 0,
"v83": 0,
"v84": 0,
"v90": 0,
"v91": 1,
"v92": 1,
"v93": 1,
"v94": 1,
"v95": 1,
"v96": 1
},
"Cells": [
{
"Version": "10",
"State": "yes",
"EvidenceKind": "legacy-database:v10",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "legacy-database:v11",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "legacy-database:v12",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "legacy-database:v13",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "14",
"State": "no",
"EvidenceKind": "legacy-database:v14",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "15",
"State": "no",
"EvidenceKind": "legacy-database:v15",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "16",
"State": "no",
"EvidenceKind": "legacy-database:v16",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "17",
"State": "no",
"EvidenceKind": "legacy-database:v17",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "18",
"State": "no",
"EvidenceKind": "legacy-database:v18",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "7.4",
"State": "no",
"EvidenceKind": "legacy-database:v74",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.0",
"State": "no",
"EvidenceKind": "legacy-database:v80",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "legacy-database:v81",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "legacy-database:v82",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "legacy-database:v83",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "legacy-database:v84",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "legacy-database:v90",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.1",
"State": "yes",
"EvidenceKind": "legacy-database:v91",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "9.2",
"State": "yes",
"EvidenceKind": "legacy-database:v92",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "9.3",
"State": "yes",
"EvidenceKind": "legacy-database:v93",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "9.4",
"State": "yes",
"EvidenceKind": "legacy-database:v94",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "9.5",
"State": "yes",
"EvidenceKind": "legacy-database:v95",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "9.6",
"State": "yes",
"EvidenceKind": "legacy-database:v96",
"TransitionVersion": "",
"Supported": true,
"Original": 1
}
],
"Texts": [
{
"Locale": "zh-Hans",
"Title": "标记为 NOT VALID 的外键",
"BodyHTML": "\u003cp\u003e引入了创建外键时的新选项 NOT VALID，之后可以修改为 VALIDATED 并执行验证检查。这使得你可以在对读写操作影响最小的情况下添加外键。\u003c/p\u003e\n",
"SourceHash": "ed4d7401f73984da4b671c96b06b18b0171f428ddf5b33f568e737c24b005862",
"ContentHash": "4a76a201e77536a4f9683da49e9d8cc61b3bc94d3a5501805145e5cb07c479b1",
"Payload": {
"description": "引入了创建外键时的新选项 NOT VALID，之后可以修改为 VALIDATED 并执行验证检查。这使得你可以在对读写操作影响最小的情况下添加外键。",
"name": "标记为 NOT VALID 的外键"
}
}
],
"GroupTitles": {
"zh-Hans": "性能"
},
"RelatedKey": "foreign-keys-marked-as-not-valid"
}