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 1pFi7x-0005Lo-AM for pgsql-committers@arkaria.postgresql.org; Wed, 11 Jan 2023 20:55:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pFi7v-0002Ws-NR for pgsql-committers@arkaria.postgresql.org; Wed, 11 Jan 2023 20:55:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pFi7v-0002Wi-GW for pgsql-committers@lists.postgresql.org; Wed, 11 Jan 2023 20:55:15 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pFi7s-0002y9-TF for pgsql-committers@lists.postgresql.org; Wed, 11 Jan 2023 20:55:15 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pFi7r-0000qZ-Dv for pgsql-committers@lists.postgresql.org; Wed, 11 Jan 2023 20:55:11 +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 1pFi7q-003BDS-DH for pgsql-committers@lists.postgresql.org; Wed, 11 Jan 2023 20:55:10 +0000 Content-Type: multipart/mixed; boundary="===============5338977597578745173==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve handling of inherited GENERATED expressions. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 11 Jan 2023 20:55:10 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5338977597578745173== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBoYW5kbGluZyBvZiBpbmhlcml0ZWQgR0VORVJBVEVEIGV4cHJlc3Npb25zLgoKSW4g Ym90aCBwYXJ0aXRpb25pbmcgYW5kIHRyYWRpdGlvbmFsIGluaGVyaXRhbmNlLCByZXF1aXJlIGNo aWxkCmNvbHVtbnMgdG8gYmUgR0VORVJBVEVEIGlmIGFuZCBvbmx5IGlmIHRoZWlyIHBhcmVudChz KSBhcmUuCkZvcm1lcmx5IHdlIGFsbG93ZWQgdGhlIGNhc2Ugb2YgYW4gaW5oZXJpdGVkIGNvbHVt biBiZWluZwpHRU5FUkFURUQgd2hlbiBpdHMgcGFyZW50IGlzbid0LCBidXQgdGhhdCByZXN1bHRz IGluIGluY29uc2lzdGVudApiZWhhdmlvcjogdGhlIGNvbHVtbiBjYW4gYmUgZGlyZWN0bHkgdXBk YXRlZCB0aHJvdWdoIGFuIFVQREFURQpvbiB0aGUgcGFyZW50IHRhYmxlLCBsZWFkaW5nIHRvIGl0 IGNvbnRhaW5pbmcgYSB1c2VyLXN1cHBsaWVkCnZhbHVlIHRoYXQgbWlnaHQgbm90IG1hdGNoIHRo ZSBnZW5lcmF0aW9uIGV4cHJlc3Npb24uICBUaGlzIGFsc28KZml4ZXMgYW4gb3ZlcnNpZ2h0IHRo YXQgd2UgZW5mb3JjZWQgcGFydGl0aW9uLWtleS1jb2x1bW5zLWNhbid0LQpiZS1HRU5FUkFURUQg YWdhaW5zdCBwYXJlbnQgdGFibGVzLCBidXQgbm90IGFnYWluc3QgY2hpbGQgdGFibGVzCnRoYXQg d2VyZSBkeW5hbWljYWxseSBhdHRhY2hlZCB0byB0aGVtLgoKQWxzbywgcmVtb3ZlIHRoZSByZXN0 cmljdGlvbiB0aGF0IHRoZSBjaGlsZCdzIGdlbmVyYXRpb24gZXhwcmVzc2lvbgpiZSBlcXVpdmFs ZW50IHRvIHRoZSBwYXJlbnQncy4gIEluIHRoZSB3YWtlIG9mIGNvbW1pdCAzZjc4MzZmZjYsCnRo ZXJlIGRvZXNuJ3Qgc2VlbSB0byBiZSBhbnkgcmVhc29uIHRoYXQgd2UgbmVlZCB0aGF0IHJlc3Ry aWN0aW9uLApzaW5jZSBnZW5lcmF0aW9uIGV4cHJlc3Npb25zIGFyZSBhbHdheXMgY29tcHV0ZWQg cGVyLXRhYmxlIGFueXdheS4KQnkgcmVtb3ZpbmcgdGhpcywgd2UgY2FuIGFsc28gYWxsb3cgYSBj aGlsZCB0byBtZXJnZSBtdWx0aXBsZQppbmhlcml0YW5jZSBwYXJlbnRzIHdpdGggaW5jb25zaXN0 ZW50IGdlbmVyYXRpb24gZXhwcmVzc2lvbnMsIGJ5Cm92ZXJyaWRpbmcgdGhlbSB3aXRoIGl0cyBv d24gZXhwcmVzc2lvbiwgbXVjaCBhcyB3ZSd2ZSBsb25nIGFsbG93ZWQKZm9yIERFRkFVTFQgZXhw cmVzc2lvbnMuCgpTaW5jZSB3ZSdyZSByZWplY3RpbmcgYSBjYXNlIHRoYXQgd2UgdXNlZCB0byBh Y2NlcHQsIHRoaXMgZG9lc24ndApzZWVtIGxpa2UgYSBiYWNrLXBhdGNoYWJsZSBjaGFuZ2UuICBH aXZlbiB0aGUgbGFjayBvZiBmaWVsZApjb21wbGFpbnRzIGFib3V0IHRoZSBpbmNvbnNpc3RlbnQg YmVoYXZpb3IsIGl0J3MgbGlrZWx5IHRoYXQgbm8Kb25lIGlzIGRvaW5nIHRoaXMgYW55d2F5LCBi dXQgd2Ugd29uJ3QgY2hhbmdlIGl0IGluIG1pbm9yIHJlbGVhc2VzLgoKQW1pdCBMYW5nb3RlIGFu ZCBUb20gTGFuZQoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8yNzkzMzgzLjE2NzI5 NDQ3OTlAc3NzLnBnaC5wYS51cwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0t LQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzhiZjZlYzNiYTNhNDQ0 NDg4MTdhZjQ3YTA4MDU4N2YzYjcxYmVlMDgKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0t CmRvYy9zcmMvc2dtbC9kZGwuc2dtbCAgICAgICAgICAgICAgICAgICB8ICA0NyArKysrKysrKy0t LQpzcmMvYmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAgfCAxMjQgKysrKysrKysr KystLS0tLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfdXRpbGNtZC5jICAg ICAgfCAgIDUgLS0Kc3JjL2Jpbi9wZ19kdW1wL2NvbW1vbi5jICAgICAgICAgICAgICAgIHwgIDQz ICsrKysrKy0tLS0Kc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXAuYyAgICAgICAgICAgICAgIHwgIDEy ICstLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dlbmVyYXRlZC5vdXQgfCAxNDEgKysrKysr KysrKysrKysrKysrKystLS0tLS0tLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvZ2VuZXJhdGVk LnNxbCAgICAgIHwgIDY0ICsrKysrKysrLS0tLS0tLQo3IGZpbGVzIGNoYW5nZWQsIDI0MCBpbnNl cnRpb25zKCspLCAxOTYgZGVsZXRpb25zKC0pCgo= --===============5338977597578745173==--