cockroachdb / cockroachdb/cockroach

schemachanger: support DROP COLUMN for PK columns

Open
#107,206 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.