Unique constraint across all partitions?

From: S Bob <sbob(at)quadratum-braccas(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Unique constraint across all partitions?
Date: 2021-01-25 22:44:32
Message-ID: e46db75f-02fc-1a79-5d04-92bc5ea05216@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

All;

Is it possible to enforce a unique constraint across all partitions for
either declarative or inheritance based partitioning? Preferably
declarative based.

Thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2021-01-25 23:02:02 Re: Unique constraint across all partitions?
Previous Message Wells Oliver 2021-01-25 22:41:33 json_build_object, numeric types, and function limits on 100 arguments