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 1p03Tq-0007fP-F0 for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Nov 2022 16:29:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p03Tp-0007z3-BU for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Nov 2022 16:29:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p03To-0007jv-V3 for pgsql-hackers@lists.postgresql.org; Tue, 29 Nov 2022 16:29:09 +0000 Received: from mail-ej1-x62c.google.com ([2a00:1450:4864:20::62c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p03Tm-00054t-KJ for pgsql-hackers@lists.postgresql.org; Tue, 29 Nov 2022 16:29:07 +0000 Received: by mail-ej1-x62c.google.com with SMTP id fy37so35052430ejc.11 for ; Tue, 29 Nov 2022 08:29:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=oLyECX7EHugcqrrQc52K40WblOhtAX5kRg7K0sUdoRg=; b=hP1CBHbesDUso9ZYBu1TRnE+N52t4h44+eNs4EQIimzQ9n7EK83aw2/9gEOokPjjMJ r85PGO0Yy035Fb/kpQnLzpEdfsnDd0cz/gPX8y0dXHy7Q3UmdNKc6v7d5DQNxB8O1IoN d4nxBCPc41REcIXrvlIkY4zvXobRfxRQLuNyp1q1o6X9+qPWwo+1DSIZaq0hU43OFdk8 OwwUV2TeowLWymBAuxeMo631YGBIsQ95NifAGuKmtwZKSuk3nbSaJo8TDNsdexb5KVEz A9C4Ur33Fzl37VvNU+AmZYGm5OQ9jbJ4rbwTnD1w/paLQ45VtFqtVBQ0QSmLn28BGn8Q WFGw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=oLyECX7EHugcqrrQc52K40WblOhtAX5kRg7K0sUdoRg=; b=lGYOE8i5YjYqPoOou7MRYIm/T0/lfDRmofQJjlAVp+IMIPeQqKa1vbxwPUKSb4GePM kWQ5IAMAnKWGtEMakdxpFguwxPwzjIlExvMPmWKAsW8ZKC+YkXu+cQc8MJNbZTeaN8Gp nAtp62ZQxy1Qya+0Y+FPBWLXusDF560+/5woR5R65nppTk8+wQJX4TZJ7dM2lhjlPr/J h5hOES54nXjUD62XngOVMI9pylwpUMUxmLonjAkbgkBPScGjHR/2Sy3s6yFV7zTqMYIr Gh0KnbFCEoHfCwPLRNNr4sCJfO84SyWHbIP95L1EzNQe/GMIZ+/TvNeZ1C/kc6VD8tG8 VPqw== X-Gm-Message-State: ANoB5pkCADGBQSqLy1ClKxxAe17Ntpx/ByjwZHDrPv1SMAVFej3x35JI K5dD/tq9qiduMv+k9hvZALg2xg== X-Google-Smtp-Source: AA0mqf48RUZlSAXhzitd8/AKMdJxdai3MOxjGt05J6gS8tH/RYJPiGu225S0a3SK1g1ZDsiU+bbLBA== X-Received: by 2002:a17:907:d006:b0:7bc:ad2d:879d with SMTP id va6-20020a170907d00600b007bcad2d879dmr18107070ejc.603.1669739345064; Tue, 29 Nov 2022 08:29:05 -0800 (PST) Received: from localhost.localdomain ([2001:871:5e:b47b:e706:88d7:ceb1:a099]) by smtp.gmail.com with ESMTPSA id y12-20020a056402358c00b0046ac460da13sm5101412edc.53.2022.11.29.08.29.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 29 Nov 2022 08:29:04 -0800 (PST) Message-ID: <26fcfb7700783faa397c712ea9721090958e0e51.camel@cybertec.at> Subject: Re: Patch: Global Unique Index From: Laurenz Albe To: Vik Fearing , Cary Huang , Thomas Kellerer Cc: pgsql-hackers Date: Tue, 29 Nov 2022 17:29:04 +0100 In-Reply-To: References: <184879c5306.12490ea581628934.7312528450011769010@highgo.ca> <3866851668762233@ja6lqgzbqb6tniny.sas.yp-c.yandex.net> <2187643.1668783992@sss.pgh.pa.us> <6cdcb7b1-2567-1373-79d1-96467a9b305b@gmx.net> <184aada3c76.1258dc67d3231678.3658037825540104775@highgo.ca> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2022-11-29 at 13:58 +0100, Vik Fearing wrote: > I disagree.  A user does not need to know that a table is partitionned, > and if the user wants a unique constraint on the table then making them > type an extra word to get it is just annoying. Hmm. But if I created a primary key without thinking too hard about it, only to discover later that dropping old partitions has become a problem, I would not be too happy either. Yours, Laurenz Albe