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 1rPmKT-00E4lc-JY for pgsql-committers@arkaria.postgresql.org; Tue, 16 Jan 2024 16:30:22 +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 1rPmKS-0057Nd-KU for pgsql-committers@arkaria.postgresql.org; Tue, 16 Jan 2024 16:30:20 +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 1rPmKS-0057NV-DE for pgsql-committers@lists.postgresql.org; Tue, 16 Jan 2024 16:30:20 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPmKP-001q9p-LM for pgsql-committers@lists.postgresql.org; Tue, 16 Jan 2024 16:30:19 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPmKO-005aiB-91 for pgsql-committers@lists.postgresql.org; Tue, 16 Jan 2024 16:30:17 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rPmKO-001hi6-JW for pgsql-committers@lists.postgresql.org; Tue, 16 Jan 2024 16:30:16 +0000 Content-Type: multipart/mixed; boundary="===============8858512842903254350==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Support identity columns in partitioned tables X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 16 Jan 2024 16:30:16 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8858512842903254350== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U3VwcG9ydCBpZGVudGl0eSBjb2x1bW5zIGluIHBhcnRpdGlvbmVkIHRhYmxlcwoKUHJldmlvdXNs eSwgaWRlbnRpdHkgY29sdW1ucyB3ZXJlIGRpc2FsbG93ZWQgb24gcGFydGl0aW9uZWQgdGFibGVz LgooVGhlIHJlYXNvbiB3YXMgbWFpbmx5IHRoYXQgbm8gb25lIGhhZCBnb3R0ZW4gYXJvdW5kIHRv IHdvcmtpbmcKdGhyb3VnaCBhbGwgdGhlIGRldGFpbHMgdG8gbWFrZSBpdCB3b3JrLikgIFRoaXMg bWFrZXMgaXQgd29yayBub3cuCgpTb21lIGRldGFpbHMgb24gdGhlIGJlaGF2aW9yOgoKKiBBIG5l d2x5IGNyZWF0ZWQgcGFydGl0aW9uIGluaGVyaXRzIGlkZW50aXR5IHByb3BlcnR5CgogIFRoZSBw YXJ0aXRpb25zIG9mIGEgcGFydGl0aW9uZWQgdGFibGUgYXJlIGludGVncmFsIHBhcnQgb2YgdGhl CiAgcGFydGl0aW9uZWQgdGFibGUuICBBIHBhcnRpdGlvbiBpbmhlcml0cyBpZGVudGl0eSBjb2x1 bW5zIGZyb20gdGhlCiAgcGFydGl0aW9uZWQgdGFibGUuICBBbiBpZGVudGl0eSBjb2x1bW4gb2Yg YSBwYXJ0aXRpb24gc2hhcmVzIHRoZQogIGlkZW50aXR5IHNwYWNlIHdpdGggdGhlIGNvcnJlc3Bv bmRpbmcgY29sdW1uIG9mIHRoZSBwYXJ0aXRpb25lZAogIHRhYmxlLiAgSW4gb3RoZXIgd29yZHMs IHRoZSBzYW1lIGlkZW50aXR5IGNvbHVtbiBhY3Jvc3MgYWxsCiAgcGFydGl0aW9ucyBvZiBhIHBh cnRpdGlvbmVkIHRhYmxlIHNoYXJlIHRoZSBzYW1lIGlkZW50aXR5IHNwYWNlLgogIFRoaXMgaXMg ZWZmZWN0ZWQgYnkgc2hhcmluZyB0aGUgc2FtZSB1bmRlcmx5aW5nIHNlcXVlbmNlLgoKICBXaGVu IElOU0VSVGluZyBkaXJlY3RseSBpbnRvIGEgcGFydGl0aW9uLCB0aGUgc2VxdWVuY2UgYXNzb2Np YXRlZAogIHdpdGggdGhlIHRvcG1vc3QgcGFydGl0aW9uZWQgdGFibGUgaXMgdXNlZCB0byBjYWxj dWxhdGUgdGhlIHZhbHVlIG9mCiAgdGhlIGNvcnJlc3BvbmRpbmcgaWRlbnRpdHkgY29sdW1uLgoK ICBJbiByZWd1bGFyIGluaGVyaXRhbmNlLCBpZGVudGl0eSBjb2x1bW5zIGFuZCB0aGVpciBwcm9w ZXJ0aWVzIGluIGEKICBjaGlsZCB0YWJsZSBhcmUgaW5kZXBlbmRlbnQgb2YgdGhvc2UgaW4gaXRz IHBhcmVudCB0YWJsZXMuICBBIGNoaWxkCiAgdGFibGUgZG9lcyBub3QgaW5oZXJpdCBpZGVudGl0 eSBjb2x1bW5zIG9yIHRoZWlyIHByb3BlcnRpZXMKICBhdXRvbWF0aWNhbGx5IGZyb20gdGhlIHBh cmVudC4gIChUaGlzIGlzIHVuY2hhbmdlZC4pCgoqIEF0dGFjaGVkIHBhcnRpdGlvbiBpbmhlcml0 cyBpZGVudGl0eSBjb2x1bW4KCiAgQSB0YWJsZSBiZWluZyBhdHRhY2hlZCBhcyBhIHBhcnRpdGlv biBpbmhlcml0cyB0aGUgaWRlbnRpdHkgcHJvcGVydHkKICBmcm9tIHRoZSBwYXJ0aXRpb25lZCB0 YWJsZS4gIFRoaXMgc2hvdWxkIGJlIGZpbmUgc2luY2Ugd2UgZXhwZWN0CiAgdGhhdCB0aGUgcGFy dGl0aW9uIHRhYmxlJ3MgY29sdW1uIGhhcyB0aGUgc2FtZSB0eXBlIGFzIHRoZQogIHBhcnRpdGlv bmVkIHRhYmxlJ3MgY29ycmVzcG9uZGluZyBjb2x1bW4uICBJZiB0aGUgdGFibGUgYmVpbmcKICBh dHRhY2hlZCBpcyBhIHBhcnRpdGlvbmVkIHRhYmxlLCB0aGUgaWRlbnRpdHkgcHJvcGVydGllcyBh cmUKICBwcm9wYWdhdGVkIGRvd24gaXRzIHBhcnRpdGlvbiBoaWVyYXJjaHkuCgogIEFuIGlkZW50 aXR5IGNvbHVtbiBpbiB0aGUgcGFydGl0aW9uZWQgdGFibGUgaXMgYWxzbyBtYXJrZWQgYXMgTk9U CiAgTlVMTC4gIFRoZSBjb3JyZXNwb25kaW5nIGNvbHVtbiBpbiB0aGUgcGFydGl0aW9uIG5lZWRz IHRvIGJlIG1hcmtlZAogIGFzIE5PVCBOVUxMIGZvciB0aGUgYXR0YWNoIHRvIHN1Y2NlZWQuCgoq IERyb3AgaWRlbnRpdHkgcHJvcGVydHkgd2hlbiBkZXRhY2hpbmcgcGFydGl0aW9uCgogIEEgcGFy dGl0aW9uJ3MgaWRlbnRpdHkgY29sdW1uIHNoYXJlcyB0aGUgaWRlbnRpdHkgc3BhY2UKICAoaS5l LiB1bmRlcmx5aW5nIHNlcXVlbmNlKSBhcyB0aGUgY29ycmVzcG9uZGluZyBjb2x1bW4gb2YgdGhl CiAgcGFydGl0aW9uZWQgdGFibGUuICBJZiBhIHBhcnRpdGlvbiBpcyBkZXRhY2hlZCBpdCBjYW4g bG9uZ2VyIHNoYXJlCiAgdGhlIGlkZW50aXR5IHNwYWNlIGFzIGJlZm9yZS4gIEhlbmNlIHRoZSBp ZGVudGl0eSBjb2x1bW5zIG9mIHRoZQogIHBhcnRpdGlvbiBiZWluZyBkZXRhY2hlZCBsb29zZSB0 aGVpciBpZGVudGl0eSBwcm9wZXJ0eS4KCiAgV2hlbiBpZGVudGl0eSBvZiBhIGNvbHVtbiBvZiBh IHJlZ3VsYXIgdGFibGUgaXMgZHJvcHBlZCBpdCByZXRhaW5zCiAgdGhlIE5PVCBOVUxMIGNvbnN0 cmFpbnQgdGhhdCBjYW1lIHdpdGggdGhlIGlkZW50aXR5IHByb3BlcnR5LgogIFNpbWlsYXJseSB0 aGUgY29sdW1ucyBvZiB0aGUgcGFydGl0aW9uIGJlaW5nIGRldGFjaGVkIHJldGFpbiB0aGUgTk9U CiAgTlVMTCBjb25zdHJhaW50cyB0aGF0IGNhbWUgd2l0aCBpZGVudGl0eSBwcm9wZXJ0eSwgZXZl biB0aG91Z2ggdGhlCiAgaWRlbnRpdHkgcHJvcGVydHkgaXRzZWxmIGlzIGxvc3QuCgogIFRoZSBz ZXF1ZW5jZSBhc3NvY2lhdGVkIHdpdGggdGhlIGlkZW50aXR5IHByb3BlcnR5IGlzIGxpbmtlZCB0 byB0aGUKICBwYXJ0aXRpb25lZCB0YWJsZSAoYW5kIG5vdCB0aGUgcGFydGl0aW9uIGJlaW5nIGRl dGFjaGVkKS4gIFRoYXQKICBzZXF1ZW5jZSBpcyBub3QgZHJvcHBlZCBhcyBwYXJ0IG9mIGRldGFj aCBvcGVyYXRpb24uCgoqIFBhcnRpdGlvbnMgd2l0aCB0aGVpciBvd24gaWRlbnRpdHkgY29sdW1u cyBhcmUgbm90IGFsbG93ZWQuCgoqIFRoZSB1c3VhbCBBTFRFUiBvcGVyYXRpb25zIChhZGQgaWRl bnRpdHkgY29sdW1uLCBhZGQgaWRlbnRpdHkKICBwcm9wZXJ0eSB0byBleGlzdGluZyBjb2x1bW4s IGFsdGVyIHByb3BlcnRpZXMgb2YgYW4gaW5kZW50aXR5CiAgY29sdW1uLCBkcm9wIGlkZW50aXR5 IHByb3BlcnR5KSBhcmUgc3VwcG9ydGVkIGZvciBwYXJ0aXRpb25lZAogIHRhYmxlcy4gIENoYW5n aW5nIGEgY29sdW1uIG9ubHkgaW4gYSBwYXJ0aXRpb25lZCB0YWJsZSBvciBhCiAgcGFydGl0aW9u IGlzIG5vdCBhbGxvd2VkOyB0aGUgY2hhbmdlIG5lZWRzIHRvIGJlIGFwcGxpZWQgdG8gdGhlCiAg d2hvbGUgcGFydGl0aW9uIGhpZXJhcmNoeS4KCkF1dGhvcjogQXNodXRvc2ggQmFwYXQgPGFzaHV0 b3NoLmJhcGF0Lm9zc0BnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBQZXRlciBFaXNlbnRyYXV0IDxw ZXRlckBlaXNlbnRyYXV0Lm9yZz4KRGlzY3Vzc2lvbjogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5v cmcvbWVzc2FnZS1pZC9mbGF0L0NBRXhIVzV1T3lrdVRDK0M2UjF5RFNwPW84UTgzanI4eEpkWnhn UGt4ZloxVWU1UlJHZ0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFp bHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzY5OTU4 NjMxNTcwNGE4MjY4ODA4ZTNiZGJhNGNiNTkyNGEwMzhjNDkKCk1vZGlmaWVkIEZpbGVzCi0tLS0t LS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9kZGwuc2dtbCAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIHwgICA0ICstCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jICAgICAgICAgICAg ICAgICAgIHwgMjIxICsrKysrKysrKysrKysrKysrKy0tLQpzcmMvYmFja2VuZC9yZXdyaXRlL3Jl d3JpdGVIYW5kbGVyLmMgICAgICAgICAgICAgICB8ICAxOSArLQouLi4vdGVzdF9kZGxfZGVwYXJz ZS9leHBlY3RlZC9hbHRlcl90YWJsZS5vdXQgICAgICB8ICAgNiArLQpzcmMvdGVzdC9yZWdyZXNz L2V4cGVjdGVkL2dlbmVyYXRlZC5vdXQgICAgICAgICAgICB8ICAgMyArLQpzcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL2lkZW50aXR5Lm91dCAgICAgICAgICAgICB8IDE5OSArKysrKysrKysrKysr KysrKystCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2lkZW50aXR5LnNxbCAgICAgICAgICAgICAgICAg IHwgMTEwICsrKysrKysrKy0KNyBmaWxlcyBjaGFuZ2VkLCA1MTUgaW5zZXJ0aW9ucygrKSwgNDcg ZGVsZXRpb25zKC0pCgo= --===============8858512842903254350==--