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 1r8kNk-00BSDz-MY for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Nov 2023 16:59:20 +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 1r8kNj-001aLR-CP for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Nov 2023 16:59:19 +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 1r8kNi-001aLH-QL for pgsql-hackers@lists.postgresql.org; Thu, 30 Nov 2023 16:59:19 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r8kNg-0088P0-3Q for pgsql-hackers@lists.postgresql.org; Thu, 30 Nov 2023 16:59:17 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-a00ac0101d9so175806366b.0 for ; Thu, 30 Nov 2023 08:59:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1701363554; x=1701968354; darn=lists.postgresql.org; h=mime-version:user-agent:autocrypt:references:in-reply-to:date:cc:to :from:subject:message-id:from:to:cc:subject:date:message-id:reply-to; bh=goq3XAzLlNsgg0fPMFQKYZL7olDKpJn61f3FjPRWvgU=; b=veJMZKsNFQJQVDcReLf3m3OFUq7UGSvyNQdv1BZIAhfHn8qJWR7XwxcPJLb3khTL2U 87X6K3Ty3WIHpPOU906Gs3ziMcC4i9yDJ1r9L4cVleSP56A9VLb04b2bmltrbwcidHKB O0YkQlyjNSqb2YwP9JGQTdOI1kQUsDEvkRzdXhm9vfGc43SDf1TksuCBQyyz4zD8Ook5 W9U+r/OXLP3LNQVih2OGzRY9IkcJCJzRIWu8NpWuW16AYnkPDGhQkOW+MPtkb0VK48j2 crFnxphBMaQLlrxmOdKco8aiJn4MxpuiR+uUhlENFjLzOSgxDzxZajiEj7/jYlKnfaZ0 d9Sw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1701363554; x=1701968354; h=mime-version:user-agent:autocrypt: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=goq3XAzLlNsgg0fPMFQKYZL7olDKpJn61f3FjPRWvgU=; b=BW8QzhmUsdHUsbd/cFao7ISZG5240E8QPcV5gzWXMN0SANCTMCq/nJMy/tQDuhxljf Lak2Ty9xRIEknN2lO20OAorIREhYaHcEIcFLdPqEjgYKTn1AdiN9PMAgnitZczIofk1a qgqoYTJFOLMd5uwSvhpmYfTLw5dwLu1ad8V4dNFmx7qEkTmkc/KUlnE51OQuHr1udED2 lhQvcKb/sV4fn6mi0ZPZAH3b+e3jIXSe0FhU1+8gYnExn59pucxteyg26A2ILtoUiIFg DErnZqAoTKdmCcz61Oa8zSucHZd9o6y4iYvozSOLi3cDPpxUbvt0kbkCEp7WbYIVS4z9 ZyUQ== X-Gm-Message-State: AOJu0YxFYgFJy+DCUYrJPbhpQRJLxDQYvboLWMVppoongHSHmlK1t2rg SoRPqc6HN2KV8Vdqj2YcQWqCxA== X-Google-Smtp-Source: AGHT+IFl23UYDAVxaUPVwzzsWeY7AmnRBzJCZB7e+mnlL0i/k0MNq934YCxMXpLE3kf7sNccxkRsbw== X-Received: by 2002:a17:906:5490:b0:9e6:59d5:71c1 with SMTP id r16-20020a170906549000b009e659d571c1mr62788ejo.58.1701363545478; Thu, 30 Nov 2023 08:59:05 -0800 (PST) Received: from localhost.localdomain ([2001:871:260:66fa:ce71:15a5:4ba0:eb87]) by smtp.gmail.com with ESMTPSA id z25-20020a170906241900b00a18850d2240sm884322eja.143.2023.11.30.08.59.05 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 30 Nov 2023 08:59:05 -0800 (PST) Message-ID: <11521998cd8c04a71bd6775fa545ac08f071ce13.camel@cybertec.at> Subject: Re: Postgres Partitions Limitations (5.11.2.3) From: Laurenz Albe To: Ashutosh Bapat Cc: navbarry@gmail.com, pgsql-hackers@lists.postgresql.org Date: Thu, 30 Nov 2023 17:59:04 +0100 In-Reply-To: References: <167299368731.659.16130012959616771853@wrigleys.postgresql.org> <40f7af960311be131d6d4bcb2caf7d93b79ddf5c.camel@cybertec.at> Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: multipart/mixed; boundary="=-mmIU0+kxZwjC6pGeGzBh" User-Agent: Evolution 3.50.1 (3.50.1-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-mmIU0+kxZwjC6pGeGzBh Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, 2023-11-30 at 19:22 +0530, Ashutosh Bapat wrote: > May be attach the patch to hackers thread (this) as well? If you want, sure. I thought it was good enough if the thread is accessible via the commitfest app. Yours, Laurenz Albe --=-mmIU0+kxZwjC6pGeGzBh Content-Disposition: attachment; filename*0=0001-Fix-omission-in-partitioning-limitation-documentatio.pat; filename*1=ch Content-Transfer-Encoding: base64 Content-Type: text/x-patch; name="0001-Fix-omission-in-partitioning-limitation-documentatio.patch"; charset="UTF-8" RnJvbSBlY2RjZTc0MDU4NmUzM2VlYjM5NGQ0NzU2NGIxMGY4MTM4OTZmZjExIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogTW9uLCA5IEphbiAyMDIzIDE2OjM4OjU4ICswMTAwClN1YmplY3Q6IFtQQVRDSF0g Rml4IG9taXNzaW9uIGluIHBhcnRpdGlvbmluZyBsaW1pdGF0aW9uIGRvY3VtZW50YXRpb24KClVO SVFVRSBhbmQgUFJJTUFSWSBLRVkgY29uc3RyYWludHMgY2FuIGJlIGNyZWF0ZWQgb24gT05MWSB0 aGUKcGFydGl0aW9uZWQgdGFibGUuICBXZSBhbHJlYWR5IGhhZCBhbiBleGFtcGxlIGRlbW9uc3Ry YXRpbmcgdGhhdCwKYnV0IGZvcmdvdCB0byBtZW50aW9uIGl0IGluIHRoZSBkb2N1bWVudGF0aW9u IG9mIHRoZSBsaW1pdHMgb2YKcGFydGl0aW9uaW5nLgoKQXV0aG9yOiBMYXVyZW56IEFsYmUKRGlz Y3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xNjcyOTkzNjg3MzEuNjU5LjE2MTMwMDEyOTU5 NjE2NzcxODUzQHdyaWdsZXlzLnBvc3RncmVzcWwub3JnCi0tLQogZG9jL3NyYy9zZ21sL2RkbC5z Z21sIHwgNSArKysrLQogMSBmaWxlIGNoYW5nZWQsIDQgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlv bigtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9kZGwuc2dtbCBiL2RvYy9zcmMvc2dtbC9k ZGwuc2dtbAppbmRleCA2ZTkyYmJkZGQyLi5iNGE3NWY5YzhmIDEwMDY0NAotLS0gYS9kb2Mvc3Jj L3NnbWwvZGRsLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL2RkbC5zZ21sCkBAIC00MjgyLDcgKzQy ODIsMTAgQEAgQUxURVIgSU5ERVggbWVhc3VyZW1lbnRfY2l0eV9pZF9sb2dkYXRlX2tleQogICAg ICAgICBVc2luZyA8bGl0ZXJhbD5PTkxZPC9saXRlcmFsPiB0byBhZGQgb3IgZHJvcCBhIGNvbnN0 cmFpbnQgb24gb25seQogICAgICAgICB0aGUgcGFydGl0aW9uZWQgdGFibGUgaXMgc3VwcG9ydGVk IGFzIGxvbmcgYXMgdGhlcmUgYXJlIG5vCiAgICAgICAgIHBhcnRpdGlvbnMuICBPbmNlIHBhcnRp dGlvbnMgZXhpc3QsIHVzaW5nIDxsaXRlcmFsPk9OTFk8L2xpdGVyYWw+Ci0gICAgICAgIHdpbGwg cmVzdWx0IGluIGFuIGVycm9yLiAgSW5zdGVhZCwgY29uc3RyYWludHMgb24gdGhlIHBhcnRpdGlv bnMKKyAgICAgICAgd2lsbCByZXN1bHQgaW4gYW4gZXJyb3IgKHRoZSBleGNlcHRpb24gdG8gdGhp cyBhcmUKKyAgICAgICAgPGxpdGVyYWw+VU5JUVVFPC9saXRlcmFsPiBhbmQgPGxpdGVyYWw+UFJJ TUFSWSBLRVk8L2xpdGVyYWw+CisgICAgICAgIGNvbnN0cmFpbnRzLCB3aGljaCB3aWxsIGJlIGNy ZWF0ZWQgd2l0aCBhbiBpbnZhbGlkIGluZGV4LCBhcyBzaG93biBpbgorICAgICAgICB0aGUgZXhh bXBsZSBhYm92ZSkuICBJbnN0ZWFkLCBjb25zdHJhaW50cyBvbiB0aGUgcGFydGl0aW9ucwogICAg ICAgICB0aGVtc2VsdmVzIGNhbiBiZSBhZGRlZCBhbmQgKGlmIHRoZXkgYXJlIG5vdCBwcmVzZW50 IGluIHRoZSBwYXJlbnQKICAgICAgICAgdGFibGUpIGRyb3BwZWQuCiAgICAgICAgPC9wYXJhPgot LSAKMi4zOS4wCgo= --=-mmIU0+kxZwjC6pGeGzBh--