Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uSKe2-006Haf-4L for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Jun 2025 19:09:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uSKe0-00E6lI-4d for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Jun 2025 19:09:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uSKdz-00E6l3-NM for pgsql-hackers@lists.postgresql.org; Thu, 19 Jun 2025 19:09:52 +0000 Received: from mail-pl1-x62b.google.com ([2607:f8b0:4864:20::62b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uSKdy-002wH8-0T for pgsql-hackers@lists.postgresql.org; Thu, 19 Jun 2025 19:09:51 +0000 Received: by mail-pl1-x62b.google.com with SMTP id d9443c01a7336-235f9ea8d08so9668225ad.1 for ; Thu, 19 Jun 2025 12:09:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=illuminatedcomputing-com.20230601.gappssmtp.com; s=20230601; t=1750360189; x=1750964989; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:to:subject:user-agent:mime-version:date:message-id:from :to:cc:subject:date:message-id:reply-to; bh=0frqMf+ZZOJ3+ETnxLs+t1CZCkkp+nLZCAW0UNAzoQ4=; b=HpfhOg3SCLuzVetGXmg1ofSIGrP1Diuz0Vmb0XQBCMRVxeiKNBPPv64DdQSNNhPOzK wrWA3u0Jk0VA9Y6eEEuwnJKHtDz4kQfbCZRj5ACGjkWTfkdo2j1C7v14rhywhtghCiot WxfpO8mmbFeFgM46TIJe/JeaKMFQQ3kGVD2ETwJsmmXGZ/AULDiJnENVLmPVW9/E6gxU T72CIVwjlZkZFUNDEuZrcw2KLfFybfqlmRQmwSN1tSwxFpR7/a9KH5XUIYYxhtd2TeXq PoOdKRn7/IdhKKmH0XOySgtBw4E39b9KHFGVDxH99OTIbItJYHQzI3mpeK7MHVQxJWKE VFBQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750360189; x=1750964989; h=content-transfer-encoding:in-reply-to:from:content-language :references:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=0frqMf+ZZOJ3+ETnxLs+t1CZCkkp+nLZCAW0UNAzoQ4=; b=q+1m93BsDy1dE/gszu0RN/vRIVk8IFIfyVuadmTkaXXZaV7A3MUUFB/dRdCh8/MXwu GtH2YzIzageaZ6CQMb+nevOGGOERwBjP6fnjm2oDEZvGI01Zl7wxneP20eR7vTKPrYEA N+/RCQ8X2DQASijnn4epM/BiAr1rrb1/BmVRuYiwHAe8DT0nGa/ilkuN268mnStjKObK AIXS0nbjJcqVhmbx16CveTRRkOXd3of00dsDjynXKO7b6L01a2TLPHcovKGB7qRSbQaT iiIJGsxvkPF7cZiDhAmMoOgH07e7XiAvJsGy3Egfy6tmPa1Q2ZLlZCv3HCNq0GpfhcLl G6Gw== X-Forwarded-Encrypted: i=1; AJvYcCW3l8moUtCnw/3xlYS9hNNCBL6kPU0BYgpW4S+pRHzw3uHQpgq6lThP11gBk7weNVRY/Kgy0k5f+Px7gz3x@lists.postgresql.org X-Gm-Message-State: AOJu0YyCSAmI9rrxViwfiylIi0B2yhleFDmTAj6dMzUYZscDdRkvN3Cn eFungsQAmJAlYUzqeLYFRy5RVZqKd4d/4xpSnlIT+AkdCkRazsQ3A1p9HymjiHAmma8= X-Gm-Gg: ASbGncv1E7vCCzEWOx5Th0GO+kJ2Iocjv2D2Ss/6c0jzMQE1yk7AOx9JNkRcvoLF4sw tcPfmbXZbcE29630OCcrb45Bu6BsPDDs2g8/IVmBdQR50IaxaHQqGUzC/kXrJvwQ5u986kGciU/ QAVbJedYyW4cgKRVY6CfMDuFch2xdD3yYcFwKmq+0BVKXHHWGVWO4RVFCCm3vqZcTl47mJiztcC EZ2s3qfCZIDefMPqqBk6hZeq0kOo4Ikrjbz9q3FCDxP0ZlDxRcSHh3nq9HALYt1uiSPyO4BiMUx 9OtXYIJ9l8m+i44ZGgQhbiA+C2iND+NNz+l7oe38jVE9o4rq1oEg1CXsBJsiiu01tUN6yY3xk2o = X-Google-Smtp-Source: AGHT+IG01Y89d4m+lGrnVRy0iqG3d4wdY5ULUa1qo6Fv6omYnOy9qA/Fd0Z1U0sUL9SEieV3ZOvLcg== X-Received: by 2002:a17:902:e88f:b0:236:6f5f:caaf with SMTP id d9443c01a7336-237d9742d6bmr115945ad.15.1750360188658; Thu, 19 Jun 2025 12:09:48 -0700 (PDT) Received: from [192.168.2.139] ([50.39.255.79]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-237d86a3083sm930645ad.195.2025.06.19.12.09.47 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 19 Jun 2025 12:09:47 -0700 (PDT) Message-ID: <1fcbd87d-2f82-41af-8d8e-caf48d7cc1ef@illuminatedcomputing.com> Date: Thu, 19 Jun 2025 12:09:47 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Correct docs about partitions and EXCLUDE constraints To: Jeff Davis , PostgreSQL Hackers References: <6fe608e71db6d9805a798b77c26f8f4ede96ef1c.camel@j-davis.com> Content-Language: en-US From: Paul Jungwirth In-Reply-To: <6fe608e71db6d9805a798b77c26f8f4ede96ef1c.camel@j-davis.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 6/19/25 08:43, Jeff Davis wrote: > Leaving it in the entry for PARTITION BY seems out of place; shouldn't > it be moved to the entry for EXCLUDE? I also merged your wording with > some similar wording from the entry about UNIQUE. Attached. I agree this new location makes more sense. The wording looks good. Thanks! -- Paul ~{:-) pj@illuminatedcomputing.com