Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l4MCq-00034L-RX for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jan 2021 11:08:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l4MCp-0007DC-F7 for pgsql-admin@arkaria.postgresql.org; Tue, 26 Jan 2021 11:08:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l4MCp-0007D5-5v for pgsql-admin@lists.postgresql.org; Tue, 26 Jan 2021 11:08:19 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l4MCi-0004CC-Lu for pgsql-admin@lists.postgresql.org; Tue, 26 Jan 2021 11:08:18 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1611659290; bh=pSBQxfskp40+DqHEUR9uVJLY5gH18fDMDoyuk0VyixE=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=kWUAF1GNxVOQuEtjPnpC9s/ZTU9CGCQkkVC6IVpua7cNvoUUFIeb1SqsxwYrs+PnA xiO4QNokqVWt1ya9pZR/6TrCUSvA4uc07/p6mkcQ6DVH5HdQDzbmczV3gEnk0kizFs GJo24ehXyJiyLyzhtZDDsEgq2bZs6esB7oRILFDE= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [10.1.33.240] ([185.40.248.10]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1N79uI-1m4n9p49b2-017UrA for ; Tue, 26 Jan 2021 12:08:10 +0100 Subject: Re: Unique constraint across all partitions? To: pgsql-admin@lists.postgresql.org References: <3d00c1f4-646c-59b7-e4dc-1d51190d2139@gmail.com> <5ebaba7ee42d89f8bfb2599de203612024c86e8e.camel@cybertec.at> <6a847296-d02f-6582-3dcb-e3e60dbc56b6@gmx.net> From: Thomas Kellerer Message-ID: Date: Tue, 26 Jan 2021 12:08:08 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:/Y5PKP0YOr4xgjTNS+dSUKw0gvuhq3p2z8qy2+XnICGC/n2O+Ed 49Ef3FCBiObyHSgR9pRdSjjU1y8Kd89SgwTIQs6S3MOgsQYO6u6gm86m8AKT32XPE1PnIxx QqzLETmUL03iI/uAXoJMnFMOncguk2M6d8uicuNztpzcCp5fQZ2pEiDGOPJUdXRyIIp5BRr tdg+bbd2pHiHrmtpARI/w== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:yezUiiF3Itg=:ybH3nre5FSSyYV7XMp+9nd IKd0N2bg6mSotm7IqxXHbwn34HX4fELzBZSAa9/juiujomd8uyxLJ8xpfYDfcmud3XH4kGc8G 2Qz77hplDBIJOS1Y06CLQZJ2Iy6LOibBrI75SgiEZNwtANtgeXkASWat5ZX0I284isJmrKO1W jECvfpb2ktX0VmJvX46e7PYOKLqF/FzeXTgTWwN2saNdPH7cUMFlOENzayR5oQXDMlPb7kbNd Dio9FcgvyTUR25ZY7KbPg6IuKvdgWN5MTcIJaOrQoNIGnO4hhN0Yx0XjA8rLdOJzDGpbOLAZg k0K47eTu8ksKS/ilJp2XlBRa66dtZWqRVjP90v0REmmRMyLCShF7pYzZ89Fl/hewQOitBZQEv BSxX42Y9uKXc0GD6eYyooWQuzynz1bLXiJLcjVgwCkZmHWZ0vHP6A2w7IFTbPWpKsta/jBDaH 0STy2VzgkYfcm10CA0YH6Mm9oNvf09hq63hrV9Eh3kFW9JV2Ksl3v+ejV11v5VVAQ4pZolFGO XABoy9Y0SXgyjoSYgRd7eoswVGczT0la0z8OT4yaEdhh0Xy5hG+PZmBfrzhEUe0m04Ve6s01y 4cHTPolpZ7uw6CnQ0tcFFohIGNc0nCZ2sofS/DnV2ZUDDqqt5LANdPKF822ZYQnV8QLuJdufg QVPQUctJsB0RjIRf8X//W5ZQCbyFVr4y7FX7t1gNcIxnDfI5EAvhVSjGK56vBlhU2GX7mLZig zrYxo4UNdROSkCpHe66vhXuKunnEiwv5VHE7MLP1i5126tqWYs9YPWBACNodYQxMtoHNZV7WT 554eFdStyGHNJoLfiPJ4YL/6D+sciBsnoBVVP/EnpwXWzle/ouzJ4kNEI7Qz+k7KXfnDItFfT IxWjhKM4OMVD4WxWMAyQ== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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.