pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Thomas Kellerer <shammat@gmx.net>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Unique constraint across all partitions?
Date: Tue, 26 Jan 2021 12:08:08 +0100
Message-ID: <a605296b-8cdc-fe3b-3286-e02861fd5293@gmx.net> (raw)
In-Reply-To: <DB6PR02MB3254BBDA5F3220F0B460B4A399BC0@DB6PR02MB3254.eurprd02.prod.outlook.com>
References: <e46db75f-02fc-1a79-5d04-92bc5ea05216@quadratum-braccas.com>
	<3d00c1f4-646c-59b7-e4dc-1d51190d2139@gmail.com>
	<CAKFQuwZx-3A4Oqk69DTBk0MaVa9W7f=LPnmQpx1Q5Nj+=9PPVw@mail.gmail.com>
	<e91069b5-f6a8-c812-a4c9-9c5c4383cb4f@gmail.com>
	<5ebaba7ee42d89f8bfb2599de203612024c86e8e.camel@cybertec.at>
	<6a847296-d02f-6582-3dcb-e3e60dbc56b6@gmx.net>
	<CAGnEbog8zbwc4_TBd7hZJALR5mUL_yZxm5+EUtgZCv3D34-wPQ@mail.gmail.com>
	<DB6PR02MB3254BBDA5F3220F0B460B4A399BC0@DB6PR02MB3254.eurprd02.prod.outlook.com>

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.






view thread (11+ messages)  latest in thread

Message-ID: <a605296b-8cdc-fe3b-3286-e02861fd5293@gmx.net>
Permalink:  ../a605296b-8cdc-fe3b-3286-e02861fd5293@gmx.net/
Also on:    postgresql.org/message-id/a605296b-8cdc-fe3b-3286-e02861fd5293@gmx.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: shammat@gmx.net, pgsql-admin@lists.postgresql.org
  Subject: Re: Unique constraint across all partitions?
  In-Reply-To: <a605296b-8cdc-fe3b-3286-e02861fd5293@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox