Skip to content

sql/schemachanger: support ALTER TABLE ... ALTER COLUMN ... [ADD | SET] ... IDENTITY in declarative schema changer #142918

@rafiss

Description

@rafiss

This tracks support for statements such as ALTER TABLE t ALTER COLUMN c ADD GENERATED ALWAYS AS IDENTITY (sequence_options) and ALTER TABLE t ALTER COLUMN c SET GENERATED ALWAYS AS IDENTITY in the declarative schema changer.

Support for ADD COLUMN ... IDENTITY was added in #139135. This change will have some similar parts, but for modifying an existing column.

Jira issue: CRDB-48584

Metadata

Metadata

Assignees

Labels

A-schema-changer-implRelated to the implementation of the new schema changerC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)E-starterMight be suitable for a starter project for new employees or team members.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions