cockroachdb / cockroachdb/cockroach
schemachanger: support DROP COLUMN for PK columns
Open
A-schema-changer-impl
C-enhancement
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Presently, the declarative schema changer only supports dropping columns which are not part of the primary key. In postgres, dropping a PK column cascades into dropping the PK constraint also. In CRDB, the PK is tied to the primary index, therefore perhaps what we should do is rebuild the primary index using the `rowid` column as a PK.
Jira issue: CRDB-29946
Contributor guide
Assessment
This issue has not been assessed yet.