Skip to content

sql: partial unique indexes and unique expression indexes should be given the _idx suffix, not _key #73556

@mgartner

Description

@mgartner

In Postgres, anonymous partial unique indexes are given a suffix of _idx. CRDB currently gives these indexes a suffix of _key. We should match Postgres's behavior.

Related to #65825

Jira issue: CRDB-11642

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.E-quick-winLikely to be a quick win for someone experienced.T-sql-queriesSQL Queries Team

    Type

    No type
    No fields configured for issues without a type.

    Projects

    Status
    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions