Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql: unique indexes should not show up in pg_constraint #65885

Open
ajwerner opened this issue May 30, 2021 · 0 comments
Open

sql: unique indexes should not show up in pg_constraint #65885

ajwerner opened this issue May 30, 2021 · 0 comments
Labels
A-sql-vtables Virtual tables - pg_catalog, information_schema etc C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
SQL Foundations

Comments

@ajwerner
Copy link
Contributor

ajwerner commented May 30, 2021 •
edited by cockroach-jira-scripts

Describe the problem

Unique indexes do not show up in postgres's pg_catalog.pg_constraint. Cockroach only partially considered there to be a distinction between unique indexes and unique constraints until #65825. It's important to not include unique indexes so that it is possible to determine whether an index is in use to implement a constraint, or not.

Epic: CRDB-10239

Jira issue: CRDB-7786
@ajwerner ajwerner added the C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. label May 30, 2021
@ajwerner ajwerner added this to Triage in SQL Foundations via automation May 30, 2021
@ajwerner ajwerner moved this from Triage to Backlog in SQL Foundations Jun 1, 2021
@ajwerner ajwerner mentioned this issue Jun 1, 2021
Open
@jlinder jlinder added the T-sql-schema-deprecated Use T-sql-foundations instead label Jun 16, 2021
@ajwerner ajwerner mentioned this issue Sep 28, 2021
Open
@ohkinozomu ohkinozomu mentioned this issue Nov 5, 2022
Closed
@postamar postamar added the A-sql-vtables Virtual tables - pg_catalog, information_schema etc label Nov 10, 2022
@postamar postamar added this to Triage in SQL Sessions - Deprecated via automation Nov 10, 2022
@blathers-crl blathers-crl bot added the T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) label Nov 10, 2022
@postamar postamar moved this from Backlog to Cold storage in SQL Foundations Nov 10, 2022
@postamar postamar moved this from Cold storage to Backlog in SQL Foundations Nov 10, 2022
@ajwerner ajwerner mentioned this issue Nov 15, 2022
Open
@rafiss rafiss moved this from Triage to Longer term backlog in SQL Sessions - Deprecated Nov 17, 2022
@rafiss rafiss removed this from Longer term backlog in SQL Sessions - Deprecated Nov 17, 2022
@exalate-issue-sync exalate-issue-sync bot removed the T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) label Nov 17, 2022
@exalate-issue-sync exalate-issue-sync bot added T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) and removed T-sql-schema-deprecated Use T-sql-foundations instead labels May 10, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-vtables Virtual tables - pg_catalog, information_schema etc C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
SQL Foundations
  
Backlog
Milestone
No milestone
Development

No branches or pull requests
3 participants
@jlinder @ajwerner @postamar