Re: Unique constraint across all partitions? - Mailing list pgsql-admin

From Ron
Subject Re: Unique constraint across all partitions?
Date
Msg-id 3d00c1f4-646c-59b7-e4dc-1d51190d2139@gmail.com
Whole thread Raw
In response to Unique constraint across all partitions?  (S Bob <sbob@quadratum-braccas.com>)
Responses Re: Unique constraint across all partitions?
List pgsql-admin
On 1/25/21 4:44 PM, S Bob wrote:
> All;
>
>
> Is it possible to enforce a unique constraint across all partitions for 
> either declarative or inheritance based partitioning? Preferably 
> declarative based.

You can create unique indexes on parent tables.  Or am I misunderstanding you?

-- 
Angular momentum makes the world go 'round.



pgsql-admin by date:

Previous
From: S Bob
Date:
Subject: Unique constraint across all partitions?
Next
From: "David G. Johnston"
Date:
Subject: Re: Unique constraint across all partitions?