Re: Unique constraint across all partitions?

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Unique constraint across all partitions?
Date: 2021-01-26 11:08:08
Message-ID: a605296b-8cdc-fe3b-3286-e02861fd5293@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michel SALAIS 2021-01-26 11:13:04 RE: Unique constraint across all partitions?
Previous Message Kanninen Anssi EXT 2021-01-26 10:09:07 RE: Unique constraint across all partitions?