Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: Unique constraint across all partitions?
Date
Msg-id a605296b-8cdc-fe3b-3286-e02861fd5293@gmx.net
Whole thread Raw
In response to RE: Unique constraint across all partitions?  (Kanninen Anssi EXT <Anssi.Kanninen@digia.com>)
List pgsql-admin
Tree view 
Kanninen Anssi EXT schrieb am 26.01.2021 um 11:09:
> But why use global indexes?

To have unique constraints for values that should be unique across all partitions.

That also allows foreign keys _referencing_ the partitioned table.

pgsql-admin by date:

Previous
From: Kanninen Anssi EXT
Date:
Subject: RE: Unique constraint across all partitions?
Next
From: "Michel SALAIS"
Date:
Subject: RE: Unique constraint across all partitions?