Skip to content

Partial unique indices are not marked as UNIQUE #1172

Description

@frodsan

Hello,

In the indices table, partial unique indices are not marked as UNIQUE. They are shown as INDEX instead:

Image

The index is defined as:

CREATE UNIQUE INDEX idx_invoices_on_checksum_partial_unique ON public.invoices USING btree (company_id, checksum) WHERE (archived_at IS NULL);

I wanted to ask you if this is intentional before sending a patch.

Thanks 🙏

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions