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.

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

Address level unique name constraint inadequate when the address is at top level #769

Open
petmongrels opened this issue Aug 2, 2024 · 0 comments

Comments

@petmongrels
Copy link
Contributor

petmongrels commented Aug 2, 2024

Check in staging db, for example.

select type_id, title, is_voided, parent_id, organisation_id from address_level where title = 'Harichandanpur (Block)';

We need custom constraint for this as well.

We could other places in the system where such issues exist due to null treatment of postgres unique constraints

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: Triaged
Development

No branches or pull requests

1 participant