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 1tgK6M-009bTi-E8 for pgsql-committers@arkaria.postgresql.org; Fri, 07 Feb 2025 08:52:42 +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 1tgK6L-00HEUU-Jc for pgsql-committers@arkaria.postgresql.org; Fri, 07 Feb 2025 08:52:41 +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 1tgK6L-00HETi-8D for pgsql-committers@lists.postgresql.org; Fri, 07 Feb 2025 08:52:41 +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.96) (envelope-from ) id 1tgK6I-003hkX-2v for pgsql-committers@lists.postgresql.org; Fri, 07 Feb 2025 08:52:40 +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 1tgK6I-00HBMy-I1 for pgsql-committers@lists.postgresql.org; Fri, 07 Feb 2025 08:52:38 +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 1tgK6H-005ooT-PA for pgsql-committers@lists.postgresql.org; Fri, 07 Feb 2025 08:52:38 +0000 Content-Type: multipart/mixed; boundary="===============6772124136358450733==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Virtual generated columns X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 07 Feb 2025 08:52:38 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6772124136358450733== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VmlydHVhbCBnZW5lcmF0ZWQgY29sdW1ucwoKVGhpcyBhZGRzIGEgbmV3IHZhcmlhbnQgb2YgZ2Vu ZXJhdGVkIGNvbHVtbnMgdGhhdCBhcmUgY29tcHV0ZWQgb24gcmVhZAoobGlrZSBhIHZpZXcsIHVu bGlrZSB0aGUgZXhpc3Rpbmcgc3RvcmVkIGdlbmVyYXRlZCBjb2x1bW5zLCB3aGljaCBhcmUKY29t cHV0ZWQgb24gd3JpdGUsIGxpa2UgYSBtYXRlcmlhbGl6ZWQgdmlldykuCgpUaGUgc3ludGF4IGZv ciB0aGUgY29sdW1uIGRlZmluaXRpb24gaXMKCiAgICAuLi4gR0VORVJBVEVEIEFMV0FZUyBBUyAo Li4uKSBWSVJUVUFMCgphbmQgVklSVFVBTCBpcyBhbHNvIG9wdGlvbmFsLiAgVklSVFVBTCBpcyB0 aGUgZGVmYXVsdCByYXRoZXIgdGhhbgpTVE9SRUQgdG8gbWF0Y2ggdmFyaW91cyBvdGhlciBTUUwg cHJvZHVjdHMuICAoVGhlIFNRTCBzdGFuZGFyZCBtYWtlcwpubyBzcGVjaWZpY2F0aW9uIGFib3V0 IHRoaXMsIGJ1dCBpdCBhbHNvIGRvZXNuJ3Qga25vdyBhYm91dCBWSVJUVUFMIG9yClNUT1JFRC4p ICAoQWxzbywgdmlydHVhbCB2aWV3cyBhcmUgdGhlIGRlZmF1bHQsIHJhdGhlciB0aGFuCm1hdGVy aWFsaXplZCB2aWV3cy4pCgpWaXJ0dWFsIGdlbmVyYXRlZCBjb2x1bW5zIGFyZSBzdG9yZWQgaW4g dHVwbGVzIGFzIG51bGwgdmFsdWVzLiAgKEEKdmVyeSBlYXJseSB2ZXJzaW9uIG9mIHRoaXMgcGF0 Y2ggaGFkIHRoZSBhbWJpdGlvbiB0byBub3Qgc3RvcmUgdGhlbSBhdAphbGwuICBCdXQgc28gbXVj aCBzdHVmZiBicmVha3Mgb3IgZ2V0cyBjb25mdXNlZCBpZiB5b3UgaGF2ZSB0dXBsZXMKd2hlcmUg YSBjb2x1bW4gaW4gdGhlIG1pZGRsZSBpcyBjb21wbGV0ZWx5IG1pc3NpbmcuICBUaGlzIGlzIGEK Y29tcHJvbWlzZSwgYW5kIGl0IHN0aWxsIHNhdmVzIHNwYWNlIG92ZXIgYmVpbmcgZm9yY2VkIHRv IHVzZSBzdG9yZWQKZ2VuZXJhdGVkIGNvbHVtbnMuICBJZiB3ZSBldmVyIGZpbmQgYSB3YXkgdG8g aW1wcm92ZSB0aGlzLCBhIGJpdCBvZgpwZ191cGdyYWRlIGNsZXZlcm5lc3MgY291bGQgYWxsb3cg Zm9yIHVwZ3JhZGVzIHRvIGEgbmV3ZXIgc2NoZW1lLikKClRoZSBjYXBhYmlsaXRpZXMgYW5kIHJl c3RyaWN0aW9ucyBvZiB2aXJ0dWFsIGdlbmVyYXRlZCBjb2x1bW5zIGFyZQptb3N0bHkgdGhlIHNh bWUgYXMgZm9yIHN0b3JlZCBnZW5lcmF0ZWQgY29sdW1ucy4gIEluIHNvbWUgY2FzZXMsIHRoaXMK cGF0Y2gga2VlcHMgdmlydHVhbCBnZW5lcmF0ZWQgY29sdW1ucyBtb3JlIHJlc3RyaWN0ZWQgdGhh biB0aGV5IG1pZ2h0CnRlY2huaWNhbGx5IG5lZWQgdG8gYmUsIHRvIGtlZXAgdGhlIHR3byBraW5k cyBjb25zaXN0ZW50LiAgU29tZSBvZgp0aGF0IGNvdWxkIG1heWJlIGJlIHJlbGF4ZWQgbGF0ZXIg YWZ0ZXIgc2VwYXJhdGUgY2FyZWZ1bApjb25zaWRlcmF0aW9ucy4KClNvbWUgZnVuY3Rpb25hbGl0 eSB0aGF0IGlzIGN1cnJlbnRseSBub3Qgc3VwcG9ydGVkLCBidXQgY291bGQgcG9zc2libHkKYmUg YWRkZWQgYXMgaW5jcmVtZW50YWwgZmVhdHVyZXMsIHNvbWUgZWFzaWVyIHRoYW4gb3RoZXJzOgoK LSBpbmRleCBvbiBvciB1c2luZyBhIHZpcnR1YWwgY29sdW1uCi0gaGVuY2UgYWxzbyBubyB1bmlx dWUgY29uc3RyYWludHMgb24gdmlydHVhbCBjb2x1bW5zCi0gZXh0ZW5kZWQgc3RhdGlzdGljcyBv biB2aXJ0dWFsIGNvbHVtbnMKLSBmb3JlaWduLWtleSBjb25zdHJhaW50cyBvbiB2aXJ0dWFsIGNv bHVtbnMKLSBub3QtbnVsbCBjb25zdHJhaW50cyBvbiB2aXJ0dWFsIGNvbHVtbnMgKGNoZWNrIGNv bnN0cmFpbnRzIGFyZSBzdXBwb3J0ZWQpCi0gQUxURVIgVEFCTEUgLyBEUk9QIEVYUFJFU1NJT04K LSB2aXJ0dWFsIGNvbHVtbiBjYW5ub3QgaGF2ZSBkb21haW4gdHlwZQotIHZpcnR1YWwgY29sdW1u cyBhcmUgbm90IHN1cHBvcnRlZCBpbiBsb2dpY2FsIHJlcGxpY2F0aW9uCgpUaGUgdGVzdHMgaW4g Z2VuZXJhdGVkX3ZpcnR1YWwuc3FsIGhhdmUgYmVlbiBjb3BpZWQgb3ZlciBmcm9tCmdlbmVyYXRl ZF9zdG9yZWQuc3FsIHdpdGggdGhlIGtleXdvcmQgcmVwbGFjZWQuICBUaGlzIHdheSB3ZSBjYW4g bWFrZQpzdXJlIHRoZSBiZWhhdmlvciBpcyBtb3N0bHkgYWxpZ25lZCwgYW5kIHRoZSBkaWZmZXJl bmNlcyBjYW4gYmUKdmlzaWJsZS4gIFNvbWUgdGVzdHMgZm9yIGN1cnJlbnRseSBub3Qgc3VwcG9y dGVkIGZlYXR1cmVzIGFyZQpjdXJyZW50bHkgY29tbWVudGVkIG91dC4KClJldmlld2VkLWJ5OiBK aWFuIEhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBEZWFuIFJh c2hlZWQgPGRlYW4uYS5yYXNoZWVkQGdtYWlsLmNvbT4KVGVzdGVkLWJ5OiBTaGxvayBLeWFsIDxz aGxvay5reWFsLm9zc0BnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vd3d3LnBvc3RncmVz cWwub3JnL21lc3NhZ2UtaWQvZmxhdC9hMzY4MjQ4ZS02OWU0LTQwYmUtOWMwNy02YzNiNTg4MGIw YTZAZWlzZW50cmF1dC5vcmcKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0K aHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi84M2VhNmM1NDAyNWJlYTY3 YmNkNDk0OWE2ZDU4ZDNmYzExYzNlMjFiCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpj b250cmliL3BhZ2VpbnNwZWN0L2V4cGVjdGVkL3BhZ2Uub3V0ICAgICAgICAgICB8ICAgMzcgKwpj b250cmliL3BhZ2VpbnNwZWN0L3NxbC9wYWdlLnNxbCAgICAgICAgICAgICAgICB8ICAgMTkgKwpj b250cmliL3Bvc3RncmVzX2Zkdy9leHBlY3RlZC9wb3N0Z3Jlc19mZHcub3V0ICB8ICAgODEgKy0K Y29udHJpYi9wb3N0Z3Jlc19mZHcvc3FsL3Bvc3RncmVzX2Zkdy5zcWwgICAgICAgfCAgICA5ICst CmRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sICAgICAgICAgICAgICAgICAgICAgIHwgICAgNiAr LQpkb2Mvc3JjL3NnbWwvZGRsLnNnbWwgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgNDYg Ky0KZG9jL3NyYy9zZ21sL3JlZi9hbHRlcl90YWJsZS5zZ21sICAgICAgICAgICAgICAgfCAgIDE1 ICstCmRvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX2ZvcmVpZ25fdGFibGUuc2dtbCAgICAgIHwgICAx MSArLQpkb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sICAgICAgICAgICAgICB8ICAg MjIgKy0KZG9jL3NyYy9zZ21sL3RyaWdnZXIuc2dtbCAgICAgICAgICAgICAgICAgICAgICAgfCAg ICA0ICsKc3JjL2JhY2tlbmQvYWNjZXNzL2NvbW1vbi90dXBkZXNjLmMgICAgICAgICAgICAgfCAg ICAzICsKc3JjL2JhY2tlbmQvYWNjZXNzL2hlYXAvaGVhcGFtX2hhbmRsZXIuYyAgICAgICAgfCAg ICAyICsKc3JjL2JhY2tlbmQvY2F0YWxvZy9oZWFwLmMgICAgICAgICAgICAgICAgICAgICAgfCAg IDIzICstCnNyYy9iYWNrZW5kL2NhdGFsb2cvcGdfcHVibGljYXRpb24uYyAgICAgICAgICAgIHwg ICAxMCArLQpzcmMvYmFja2VuZC9jb21tYW5kcy9hbmFseXplLmMgICAgICAgICAgICAgICAgICB8 ICAgIDQgKwpzcmMvYmFja2VuZC9jb21tYW5kcy9pbmRleGNtZHMuYyAgICAgICAgICAgICAgICB8 ICAgMzMgKy0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvcHVibGljYXRpb25jbWRzLmMgICAgICAgICAg fCAgIDIzICstCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3N0YXRzY21kcy5jICAgICAgICAgICAgICAg IHwgICAyMCArLQpzcmMvYmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAgICAgICAg ICB8ICAxOTYgKysrLQpzcmMvYmFja2VuZC9jb21tYW5kcy90cmlnZ2VyLmMgICAgICAgICAgICAg ICAgICB8ICAgNDUgKy0Kc3JjL2JhY2tlbmQvZXhlY3V0b3IvZXhlY0V4cHJJbnRlcnAuYyAgICAg ICAgICAgfCAgICA0ICsKc3JjL2JhY2tlbmQvZXhlY3V0b3IvZXhlY01haW4uYyAgICAgICAgICAg ICAgICAgfCAgICA1ICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNVdGlscy5jICAgICAgICAg ICAgICAgIHwgICAgNCArLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlTW9kaWZ5VGFibGUuYyAg ICAgICAgICB8ICAgNDEgKy0Kc3JjL2JhY2tlbmQvcGFyc2VyL2dyYW0ueSAgICAgICAgICAgICAg ICAgICAgICAgfCAgIDE1ICstCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9yZWxhdGlvbi5jICAg ICAgICAgICAgIHwgICAgNiArLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfdXRpbGNtZC5jICAg ICAgICAgICAgICB8ICAgMTYgKy0Kc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vcGdvdXRwdXQvcGdv dXRwdXQuYyAgICAgfCAgICAzICstCnNyYy9iYWNrZW5kL3Jld3JpdGUvcmV3cml0ZUhhbmRsZXIu YyAgICAgICAgICAgIHwgIDEzMyArKy0Kc3JjL2JhY2tlbmQvdXRpbHMvY2FjaGUvcmVsY2FjaGUu YyAgICAgICAgICAgICAgfCAgICAzICsKc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXAuYyAgICAgICAg ICAgICAgICAgICAgICAgfCAgICAzICsKc3JjL2Jpbi9wZ19kdW1wL3QvMDAyX3BnX2R1bXAucGwg ICAgICAgICAgICAgICAgfCAgICA2ICstCnNyYy9iaW4vcHNxbC9kZXNjcmliZS5jICAgICAgICAg ICAgICAgICAgICAgICAgIHwgICAgNiArCnNyYy9pbmNsdWRlL2FjY2Vzcy90dXBkZXNjLmggICAg ICAgICAgICAgICAgICAgIHwgICAgMSArCnNyYy9pbmNsdWRlL2NhdGFsb2cvY2F0dmVyc2lvbi5o ICAgICAgICAgICAgICAgIHwgICAgMiArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2hlYXAuaCAgICAg ICAgICAgICAgICAgICAgICB8ICAgIDEgKwpzcmMvaW5jbHVkZS9jYXRhbG9nL3BnX2F0dHJpYnV0 ZS5oICAgICAgICAgICAgICB8ICAgIDEgKwpzcmMvaW5jbHVkZS9leGVjdXRvci9ub2RlTW9kaWZ5 VGFibGUuaCAgICAgICAgICB8ICAgIDYgKy0Kc3JjL2luY2x1ZGUvbm9kZXMvZXhlY25vZGVzLmgg ICAgICAgICAgICAgICAgICAgfCAgICAyICsKc3JjL2luY2x1ZGUvbm9kZXMvcGFyc2Vub2Rlcy5o ICAgICAgICAgICAgICAgICAgfCAgICAxICsKc3JjL2luY2x1ZGUvcGFyc2VyL2t3bGlzdC5oICAg ICAgICAgICAgICAgICAgICAgfCAgICAxICsKc3JjL2luY2x1ZGUvcmV3cml0ZS9yZXdyaXRlSGFu ZGxlci5oICAgICAgICAgICAgfCAgICAyICsKc3JjL3BsL3BscGVybC9leHBlY3RlZC9wbHBlcmxf dHJpZ2dlci5vdXQgICAgICAgfCAgICA3ICstCnNyYy9wbC9wbHBlcmwvcGxwZXJsLmMgICAgICAg ICAgICAgICAgICAgICAgICAgIHwgICAgMyArCnNyYy9wbC9wbHBlcmwvc3FsL3BscGVybF90cmln Z2VyLnNxbCAgICAgICAgICAgIHwgICAgMyArLQpzcmMvcGwvcGxweXRob24vZXhwZWN0ZWQvcGxw eXRob25fdHJpZ2dlci5vdXQgICB8ICAgIDcgKy0Kc3JjL3BsL3BscHl0aG9uL3BscHlfdHlwZWlv LmMgICAgICAgICAgICAgICAgICAgfCAgICAzICsKc3JjL3BsL3BscHl0aG9uL3NxbC9wbHB5dGhv bl90cmlnZ2VyLnNxbCAgICAgICAgfCAgICAzICstCnNyYy9wbC90Y2wvZXhwZWN0ZWQvcGx0Y2xf dHJpZ2dlci5vdXQgICAgICAgICAgIHwgICAxOSArLQpzcmMvcGwvdGNsL3BsdGNsLmMgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICB8ICAgIDMgKwpzcmMvcGwvdGNsL3NxbC9wbHRjbF90cmln Z2VyLnNxbCAgICAgICAgICAgICAgICB8ICAgIDMgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9jb2xsYXRlLmljdS51dGY4Lm91dCAgfCAgIDIwICsKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9jcmVhdGVfdGFibGVfbGlrZS5vdXQgfCAgIDIzICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0 ZWQvZmFzdF9kZWZhdWx0Lm91dCAgICAgIHwgICAxMiArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0 ZWQvZ2VuZXJhdGVkX3N0b3JlZC5vdXQgIHwgICAyMSArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVj dGVkL2dlbmVyYXRlZF92aXJ0dWFsLm91dCB8IDE0MDAgKysrKysrKysrKysrKysrKysrKysrKysK c3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wdWJsaWNhdGlvbi5vdXQgICAgICAgfCAgIDQ1ICst CnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcm93c2VjdXJpdHkub3V0ICAgICAgIHwgICAyOSAr CnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3RhdHNfZXh0Lm91dCAgICAgICAgIHwgICAyMyAr CnNyYy90ZXN0L3JlZ3Jlc3MvcGFyYWxsZWxfc2NoZWR1bGUgICAgICAgICAgICAgIHwgICAgMiAr LQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9jb2xsYXRlLmljdS51dGY4LnNxbCAgICAgICB8ICAgMTUg KwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9jcmVhdGVfdGFibGVfbGlrZS5zcWwgICAgICB8ICAgIDIg Ky0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvZmFzdF9kZWZhdWx0LnNxbCAgICAgICAgICAgfCAgIDEx ICsKc3JjL3Rlc3QvcmVncmVzcy9zcWwvZ2VuZXJhdGVkX3N0b3JlZC5zcWwgICAgICAgfCAgIDEy ICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2dlbmVyYXRlZF92aXJ0dWFsLnNxbCAgICAgIHwgIDcz NCArKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvcHVibGljYXRpb24uc3FsICAgICAg ICAgICAgfCAgIDQzICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3Jvd3NlY3VyaXR5LnNxbCAgICAg ICAgICAgIHwgICAyNyArCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3N0YXRzX2V4dC5zcWwgICAgICAg ICAgICAgIHwgICAxNCArCnNyYy90ZXN0L3N1YnNjcmlwdGlvbi90LzAxMV9nZW5lcmF0ZWQucGwg ICAgICAgIHwgICAzOSArLQpzcmMvdGVzdC9zdWJzY3JpcHRpb24vdC8wMjhfcm93X2ZpbHRlci5w bCAgICAgICB8ICAgMzggKy0Kc3JjL3Rlc3Qvc3Vic2NyaXB0aW9uL3QvMDMxX2NvbHVtbl9saXN0 LnBsICAgICAgfCAgICAyICstCjcxIGZpbGVzIGNoYW5nZWQsIDMyMjUgaW5zZXJ0aW9ucygrKSwg MjA5IGRlbGV0aW9ucygtKQoK --===============6772124136358450733==--