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

Index "Nulls Not Distinct" support #844

Open
ldhasson opened this issue Dec 22, 2024 · 1 comment
Open

Index "Nulls Not Distinct" support #844

ldhasson opened this issue Dec 22, 2024 · 1 comment

Comments

@ldhasson
Copy link
Collaborator

No description provided.

@ldhasson ldhasson converted this from a draft issue Dec 22, 2024
ldhasson added a commit that referenced this issue Dec 22, 2024
@ldhasson
Index NULLS NOT DISTINCT #844
3805ab9 
+ adding index comment

HOWEVER, migration is still an issue: the JDBC driver doesn't return
comments on indices, and there is no attribute to check NULLS NOT
DISTINCT. Need to devise another fuller solution by querying the comment
directly maybe?

NEED FOLLOW UP!
@ldhasson
Copy link
Collaborator Author

Investigate

SELECT description
FROM   pg_description
WHERE  objoid = 'public.test_xxx_main'::regclass;

where test_xxx_main is the name of the index. Gotta be careful about performance. May need to read ALL indices for a given schema in one shot.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
Tilda - Main
Status: Implementation
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ldhasson