ALTER TABLE ... ADD UNIQUE/PRIMARY KEY USING INDEX
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.
数据定义语言 (DDL)
Description
允许使用已有的唯一索引来定义主键或唯一约束，包括并发创建的唯一索引。
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 · cefead5532f5b170f80b4e47f9ae4ed5547f2dbb8612fb24906d6218376e9da7
{
"Key": "213",
"SourceKind": "legacy",
"SourceDatabase": "center",
"SourceTable": "featurematrix_feature",
"SourceKey": "213",
"SourceHash": "cefead5532f5b170f80b4e47f9ae4ed5547f2dbb8612fb24906d6218376e9da7",
"Name": "ALTER TABLE ... ADD UNIQUE/PRIMARY KEY USING INDEX",
"NameLocale": "en",
"GroupKey": "14",
"GroupName": "数据定义语言 (DDL)",
"GroupLocale": "zh-Hans",
"Ordinal": 0,
"GroupOrder": 7,
"Facts": {
"featuredescription": "允许使用已有的唯一索引来定义主键或唯一约束，包括并发创建的唯一索引。",
"featurename": "ALTER TABLE ... ADD UNIQUE/PRIMARY KEY USING INDEX",
"group_id": 14,
"id": 213,
"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": "en",
"Title": "ALTER TABLE ... ADD UNIQUE/PRIMARY KEY USING INDEX",
"BodyHTML": "",
"SourceHash": "cefead5532f5b170f80b4e47f9ae4ed5547f2dbb8612fb24906d6218376e9da7",
"ContentHash": "8be808ee2582d4c2657936a863706da5f40ad4b03e3652b0598e5a6a0c39320a",
"Payload": {
"name": "ALTER TABLE ... ADD UNIQUE/PRIMARY KEY USING INDEX"
}
},
{
"Locale": "zh-Hans",
"Title": "",
"BodyHTML": "\u003cp\u003e允许使用已有的唯一索引来定义主键或唯一约束，包括并发创建的唯一索引。\u003c/p\u003e\n",
"SourceHash": "cefead5532f5b170f80b4e47f9ae4ed5547f2dbb8612fb24906d6218376e9da7",
"ContentHash": "d4f3416b18c41532a4d627cd7cbcc1c096407936c2f5f2dde40fd5f4f2d7a384",
"Payload": {
"description": "允许使用已有的唯一索引来定义主键或唯一约束，包括并发创建的唯一索引。"
}
}
],
"GroupTitles": {
"zh-Hans": "数据定义语言 (DDL)"
},
"RelatedKey": "alter-table-add-uniqueprimary-key-using-index"
}