-
Notifications
You must be signed in to change notification settings - Fork 4.1k
ALTER TYPE DROP VALUE does not support "IF EXISTS" suffix #120801
Copy link
Copy link
Open
Labels
C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)O-communityOriginated from the communityOriginated from the communityP-3Issues/test failures with no fix SLAIssues/test failures with no fix SLAT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Description
Metadata
Metadata
Assignees
Labels
C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)O-communityOriginated from the communityOriginated from the communityP-3Issues/test failures with no fix SLAIssues/test failures with no fix SLAT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Type
Fields
Give feedbackNo fields configured for issues without a type.
Is your feature request related to a problem? Please describe.
It's extremely useful for DDL statements to be idempotent - the
IF NOT EXISTSsyntax is a part of CockroachDB and Postgres as a whole that makes this feasible.Describe the solution you'd like
Postgres' interface has this syntax already, but:
https://www.postgresql.org/docs/current/sql-altertype.html
By supporting this interface, it would be much easier to issue "idempotent DDL statements" to CockroachDB.
Jira issue: CRDB-36872
Epic CRDB-60817