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 1uRxVs-001NcH-Kl for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jun 2025 18:27:56 +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 1uRxVq-003sM9-OY for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jun 2025 18:27:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uRxTS-003ncu-8w for pgsql-hackers@lists.postgresql.org; Wed, 18 Jun 2025 18:25:27 +0000 Received: from mail-pg1-x534.google.com ([2607:f8b0:4864:20::534]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uRxTQ-002o2Y-10 for pgsql-hackers@lists.postgresql.org; Wed, 18 Jun 2025 18:25:26 +0000 Received: by mail-pg1-x534.google.com with SMTP id 41be03b00d2f7-b2c4e46a89fso1527a12.2 for ; Wed, 18 Jun 2025 11:25:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=illuminatedcomputing-com.20230601.gappssmtp.com; s=20230601; t=1750271121; x=1750875921; darn=lists.postgresql.org; h=subject:to:from:content-language:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=ngyDN7HimBgYLbs7KkoTS5qH9ppNFkPG4hgvtCXsLHA=; b=tSYY9P2RflJx3ETb1n4T51djJUqVdrdGmWux0yGpuA9Jfhb0BSVyWwD91LuwF9EKtm cJobUZAzpl2Q9L3BzeD8cs8T3JmSWYq1Ye3yA+gBYY05b/tHaxnv1n1kircrPJ/i7wVs 4GguOXL8sWR9HE/EMjG0zimdpf0unxU8p+IWgmSEY8wBKu94Q6W0V4DOcV0k0AbJQf6N gOxFFChbr06U7Bw7ymulK7nfRemHBaTet2IU9CMJn1b0HxKKIC3bRbN4Tr2od0IKOpq+ /pVYfvmD1ru22CqmmCf47I597YToIZGhaQTlPNoraNmXFown/1Wj56HXO05ZcwZGP/IT nwug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750271121; x=1750875921; h=subject:to:from:content-language:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=ngyDN7HimBgYLbs7KkoTS5qH9ppNFkPG4hgvtCXsLHA=; b=Ri086T94N7zsiY0E74bAgU9I7KBoK3i4eueXBKVB11WNmrneJLm5OvH8JiU/OT0gas 4jImH/sBHbqtLSb3+lPCeRi8FF+CDaqt6oljDanXkJq7qwSFLqShsxGxsZhxOyAu6X7V vobHX5SQEygb2aj5/yln8CNZLTD4QVJH9qOCXw0K//zosIiOTpSXNfZlUj+glASSpABU NxDl1IWEd9Cdj1qyINymKxfW23nlM2Asps3HhoA2q9VYgbqSJpR91DAnuocH18EmaCJm NcAMjJhIp1W+qqzQxoHOw2jntrz4NCsB51NqOnU6oRz1aZEET23xUZ6clbClXkj4ntb/ sxzw== X-Gm-Message-State: AOJu0YwXOrWHR388Mlk5SWA8FrybwbbuBwP0T4wZWlr1xOgFvAd6nNV7 ZnFSaWw0mMyyA8qNCb9Hbmzoqr8QAPWj3wQf5XJ/ZMFrIUIFd47OtxaxI4cx3gJXcwtYykHvNlS 26zCRJJs= X-Gm-Gg: ASbGncsWrLQQ1UV1ivJ1SEkzCALgcFCkLCmCTWPkVRYJd9CCnNOx0i6bayWzcouVh0S ddQUqkyG0v9oeVfjXA9P7ks1BAfwb+NBn+qKs1g2h2vQbaQ4Bs7DI0Ej5fHHVuMhnItVgFAEkZp RsPGoliM00lxGxtzqFg3rAO9GMpnxIxhlk2IRzubcOtxLM3KeFIwtKvIGtyiA12JEjjADwEbWny eNWteGCsagooqKCT3OabOvL91Gq7KDnZJvFG629OTi7JUaPxMZ/YcFL+jK9yV074LUxKQQ5j3KS cLtHE5DzVpahgy7uRGkTqGJyBhjqLlOH5zYMwVmqTLaoMIGTGSyGsf//Y2tOL4Okqo4+JmZCzEE = X-Google-Smtp-Source: AGHT+IFFPOBDUQua7YMTqcqRMiYir56HvvTfeqVIawYfkkPMjdx/tbNf2fa5jobH5bYuXPxKgPoDFA== X-Received: by 2002:a05:6a21:6d8c:b0:21a:bfb6:1c74 with SMTP id adf61e73a8af0-21fbd58c764mr32139977637.34.1750271121137; Wed, 18 Jun 2025 11:25:21 -0700 (PDT) Received: from [192.168.2.139] ([50.39.255.79]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-b2fe1680eeasm11333515a12.46.2025.06.18.11.25.20 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 18 Jun 2025 11:25:20 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------DLSE570uvq0ZEFIHifAvdmRZ" Message-ID: Date: Wed, 18 Jun 2025 11:25:20 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: en-US From: Paul Jungwirth To: PostgreSQL Hackers Subject: Correct docs about partitions and EXCLUDE constraints List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------DLSE570uvq0ZEFIHifAvdmRZ Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hi Hackers, In pg17 we added support for cross-partition EXCLUDE constraints, as long as they included all partition key columns and compared them with equality (see 8c852ba9a4). I updated the docs for exclusion constraints, but I missed that the docs for CREATE TABLE still said that they were not supported. This commit fixes that. I don't see a similar message in the ALTER TABLE docs. I take it we should apply this patch to both v18 and v17? Yours, -- Paul ~{:-) pj@illuminatedcomputing.com --------------DLSE570uvq0ZEFIHifAvdmRZ Content-Type: text/x-patch; charset=UTF-8; name="v1-0001-Correct-docs-about-partitions-and-EXCLUDE-constra.patch" Content-Disposition: attachment; filename*0="v1-0001-Correct-docs-about-partitions-and-EXCLUDE-constra.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSA5NDM2ZjNiZGZlMzAxYmU5ZDMxZDQ4YThiNDdlYjBlODAyYjY3MTUyIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiAiUGF1bCBBLiBKdW5nd2lydGgiIDxwakBpbGx1bWlu YXRlZGNvbXB1dGluZy5jb20+CkRhdGU6IFR1ZSwgMTcgSnVuIDIwMjUgMjA6NDg6NTYgLTA3 MDAKU3ViamVjdDogW1BBVENIIHYxXSBDb3JyZWN0IGRvY3MgYWJvdXQgcGFydGl0aW9ucyBh bmQgRVhDTFVERSBjb25zdHJhaW50cwoKSW4gcGcxNyB3ZSBhZGRlZCBzdXBwb3J0IGZvciBj cm9zcy1wYXJ0aXRpb24gRVhDTFVERSBjb25zdHJhaW50cywgYXMKbG9uZyBhcyB0aGV5IGlu Y2x1ZGVkIGFsbCBwYXJ0aXRpb24ga2V5IGNvbHVtbnMgYW5kIGNvbXBhcmVkIHRoZW0gd2l0 aAplcXVhbGl0eSAoc2VlIDhjODUyYmE5YTQzNDdjNDc3OGNjNjEwYWQ1YTljYjUwZWE3MDFi NWMpLiBJIHVwZGF0ZWQgdGhlCmRvY3MgZm9yIGV4Y2x1c2lvbiBjb25zdHJhaW50cywgYnV0 IEkgbWlzc2VkIHRoYXQgdGhlIGRvY3MgZm9yIENSRUFURQpUQUJMRSBzdGlsbCBzYWlkIHRo YXQgdGhleSB3ZXJlIG5vdCBzdXBwb3J0ZWQuIFRoaXMgY29tbWl0IGZpeGVzIHRoYXQuCgpB dXRob3I6IFBhdWwgQS4gSnVuZ3dpcnRoIDxwakBpbGx1bWluYXRlZGNvbXB1dGluZy5jb20+ Ci0tLQogZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbCB8IDcgKysrKystLQog MSBmaWxlIGNoYW5nZWQsIDUgaW5zZXJ0aW9ucygrKSwgMiBkZWxldGlvbnMoLSkKCmRpZmYg LS1naXQgYS9kb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sIGIvZG9jL3NyYy9z Z21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbAppbmRleCA0YTQxYjJmNTUzMC4uNjJlYjI3MzIz NmIgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxlLnNnbWwKKysr IGIvZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbApAQCAtNDQ4LDggKzQ0OCwx MSBAQCBXSVRIICggTU9EVUxVUyA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+bnVt ZXJpY19saXRlcmFsPC9yZXBsYWNlYWJsZT4sIFJFTQogICAgICA8L3BhcmE+CiAKICAgICAg PHBhcmE+Ci0gICAgICBQYXJ0aXRpb25lZCB0YWJsZXMgZG8gbm90IHN1cHBvcnQgPGxpdGVy YWw+RVhDTFVERTwvbGl0ZXJhbD4gY29uc3RyYWludHM7Ci0gICAgICBob3dldmVyLCB5b3Ug Y2FuIGRlZmluZSB0aGVzZSBjb25zdHJhaW50cyBvbiBpbmRpdmlkdWFsIHBhcnRpdGlvbnMu CisgICAgICBQYXJ0aXRpb25lZCB0YWJsZXMgc3VwcG9ydCA8bGl0ZXJhbD5FWENMVURFPC9s aXRlcmFsPiBjb25zdHJhaW50cworICAgICAgaWYgdGhlIGNvbnN0cmFpbnQgaW5jbHVkZXMg YWxsIHRoZSBwYXJ0aXRpb24ga2V5IGNvbHVtbnMKKyAgICAgIGFuZCBpdCBjb21wYXJlcyBh bGwgdGhvc2UgY29sdW1ucyBmb3IgZXF1YWxpdHkuIEl0IG1heSBpbmNsdWRlIGFkZGl0aW9u YWwKKyAgICAgIGNvbHVtbnMgYW5kIGNvbXBhcmUgdGhlbSBob3dldmVyIGl0IGxpa2VzIChl LmcuIHdpdGggPGxpdGVyYWw+JmFtcDsmYW1wOzwvbGl0ZXJhbD4pLgorICAgICAgVGhpcyBl bnN1cmVzIHRoYXQgYW55IHJvd3MgdGhhdCBtaWdodCBjb25mbGljdCB3aWxsIGZhbGwgaW4g dGhlIHNhbWUgcGFydGl0aW9uLgogICAgICA8L3BhcmE+CiAKICAgICAgPHBhcmE+Ci0tIAoy LjM5LjUKCg== --------------DLSE570uvq0ZEFIHifAvdmRZ--