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 1tYVHX-00BRaH-2O for pgsql-committers@arkaria.postgresql.org; Thu, 16 Jan 2025 19:11:55 +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 1tYVHU-000Mfp-UH for pgsql-committers@arkaria.postgresql.org; Thu, 16 Jan 2025 19:11:53 +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 1tYVHU-000Mff-Mv for pgsql-committers@lists.postgresql.org; Thu, 16 Jan 2025 19:11:53 +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 1tYVHT-000kyp-24 for pgsql-committers@lists.postgresql.org; Thu, 16 Jan 2025 19:11:52 +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 1tYVHS-005r4w-E9 for pgsql-committers@lists.postgresql.org; Thu, 16 Jan 2025 19:11:50 +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 1tYVHR-001xWD-Dw for pgsql-committers@lists.postgresql.org; Thu, 16 Jan 2025 19:11:49 +0000 Content-Type: multipart/mixed; boundary="===============1170612592395987948==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Seek zone abbreviations in the IANA data before timezone_abbrevi X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 16 Jan 2025 19:11:49 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1170612592395987948== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2VlayB6b25lIGFiYnJldmlhdGlvbnMgaW4gdGhlIElBTkEgZGF0YSBiZWZvcmUgdGltZXpvbmVf YWJicmV2aWF0aW9ucy4KCklmIGEgdGltZSB6b25lIGFiYnJldmlhdGlvbiB1c2VkIGluIGRhdGV0 aW1lIGlucHV0IGlzIGRlZmluZWQgaW4KdGhlIGN1cnJlbnRseSBhY3RpdmUgdGltZXpvbmUsIHVz ZSB0aGF0IGRlZmluaXRpb24gaW4gcHJlZmVyZW5jZQp0byBsb29raW5nIGluIHRoZSB0aW1lem9u ZV9hYmJyZXZpYXRpb25zIGxpc3QuICBUaGF0IGFsbG93cyB1cyB0bwpjb3JyZWN0bHkgaGFuZGxl IGFiYnJldmlhdGlvbnMgdGhhdCBoYXZlIGRpZmZlcmVudCBtZWFuaW5ncyBpbgpkaWZmZXJlbnQg dGltZXpvbmVzLiAgQWxzbywgaXQgZWxpbWluYXRlcyBhbiBpbmNvbnNpc3RlbmN5IGJldHdlZW4K ZGF0ZXRpbWUgaW5wdXQgYW5kIGRhdGV0aW1lIG91dHB1dDogdGhlIG5vbi1JU08gZGF0ZXN0eWxl cyBmb3IKdGltZXN0YW1wdHogaGF2ZSBhbHdheXMgcHJpbnRlZCBhYmJyZXZpYXRpb25zIHRha2Vu IGZyb20gdGhlIElBTkEKZGF0YSwgbm90IGZyb20gdGltZXpvbmVfYWJicmV2aWF0aW9ucy4gIEJl Zm9yZSB0aGlzIGZpeCwgaXQgd2FzCnBvc3NpYmxlIHRvIGRlbW9uc3RyYXRlIGNhc2VzIHdoZXJl IGNhc3RpbmcgYSB0aW1lc3RhbXAgdG8gdGV4dAphbmQgYmFjayBmYWlscyBvciBjaGFuZ2VzIHRo ZSB2YWx1ZSBzaWduaWZpY2FudGx5IGJlY2F1c2Ugb2YgdGhhdAppbmNvbnNpc3RlbmN5LgoKV2hp bGUgdGhpcyBjaGFuZ2UgcmVtb3ZlcyB0aGUgYWJpbGl0eSB0byBvdmVycmlkZSB0aGUgSUFOQSBk YXRhIGFib3V0CmFuIGFiYnJldmlhdGlvbiBrbm93biBpbiB0aGUgY3VycmVudCB6b25lLCBpdCdz IG5vdCBjbGVhciB0aGF0IHRoZXJlJ3MKYW55IHJlYWwgdXNlLWNhc2UgZm9yIGRvaW5nIHNvLiAg QnV0IGl0IGlzIGNsZWFyIHRoYXQgdGhpcyBtYWtlcyBsaWZlCmEgbG90IGVhc2llciBmb3IgZGVh bGluZyB3aXRoIGFiYnJldmlhdGlvbnMgdGhhdCBoYXZlIGNvbmZsaWN0cyBhY3Jvc3MKZGlmZmVy ZW50IHRpbWUgem9uZXMuCgpBbHNvIHVwZGF0ZSB0aGUgcGdfdGltZXpvbmVfYWJicmV2cyB2aWV3 IHRvIHJlcG9ydCBhYmJyZXZpYXRpb25zCnRoYXQgYXJlIHJlY29nbml6ZWQgdmlhIHRoZSBJQU5B IGRhdGEsIGFuZCAqbm90KiByZXBvcnQgYW55CnRpbWV6b25lX2FiYnJldmlhdGlvbnMgZW50cmll cyB0aGF0IGFyZSB0aGVyZWJ5IG92ZXJyaWRkZW4uClVuZGVyIHRoZSBob29kLCB0aGVyZSBhcmUg bm93IHR3byBTUkZzLCBvbmUgdGhhdCBwdWxscyB0aGUgSUFOQQpkYXRhIGFuZCBvbmUgdGhhdCBw dWxscyB0aW1lem9uZV9hYmJyZXZpYXRpb25zIGVudHJpZXMuICBUaGV5J3JlCmNvbWJpbmVkIGJ5 IGxvZ2ljIGluIHRoZSB2aWV3LiAgVGhpcyBhcHByb2FjaCB3YXMgdXNlZnVsIGZvcgpkZWJ1Z2dp bmcgKHNpbmNlIHRoZSBmdW5jdGlvbnMgY2FuIGJlIGNhbGxlZCBvbiB0aGVpciBvd24pLgpXaGls ZSBJIGRvbid0IGludGVuZCB0byBkb2N1bWVudCB0aGUgZnVuY3Rpb25zIGV4cGxpY2l0bHksCnRo ZXkgbWlnaHQgYmUgdXNlZnVsIHRvIGNhbGwgZGlyZWN0bHkuCgpBbHNvIGltcHJvdmUgRGVjb2Rl VGltZXpvbmVBYmJyZXYncyBjYWNoaW5nIGxvZ2ljIHNvIHRoYXQgaXQgY2FuCmNhY2hlIHpvbmUg YWJicmV2aWF0aW9ucyBmb3VuZCBpbiB0aGUgSUFOQSBkYXRhLiAgV2l0aG91dCB0aGF0LAp0aGlz IHBhdGNoIHdvdWxkIGhhdmUgY2F1c2VkIGEgbm90aWNlYWJsZSBkZWdyYWRhdGlvbiBvZiB0aGUK cnVudGltZSBvZiB0aW1lc3RhbXB0el9pbi4KClBlciByZXBvcnQgZnJvbSBBbGVrc2FuZGVyIEFs ZWtzZWV2IGFuZCBhZGRpdGlvbmFsIGludmVzdGlnYXRpb24uCgpEaXNjdXNzaW9uOiBodHRwczov L3Bvc3Rnci5lcy9tL0NBSjdjNlRPQVRqSnF2aG5Zc3VpMD1DTzVYRk1GNGR2VEdIK3NrekItLWpO aHFTUXU1Z0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0t LS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2Q3Njc0YzlmYWIw OWQ1YmFiNDI3YmEzYjliN2EyMGIxNjlhYmE3MTUKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0t LS0tCmRvYy9zcmMvc2dtbC9jb25maWcuc2dtbCAgICAgICAgICAgICAgICAgIHwgICA2ICstCmRv Yy9zcmMvc2dtbC9kYXRhdHlwZS5zZ21sICAgICAgICAgICAgICAgIHwgICA0ICsKZG9jL3NyYy9z Z21sL2RhdGV0aW1lLnNnbWwgICAgICAgICAgICAgICAgfCAgNDIgKysrKystCmRvYy9zcmMvc2dt bC9zeXN0ZW0tdmlld3Muc2dtbCAgICAgICAgICAgIHwgICA0ICstCnNyYy9iYWNrZW5kL2NhdGFs b2cvc3lzdGVtX3ZpZXdzLnNxbCAgICAgIHwgICA3ICstCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3Zh cmlhYmxlLmMgICAgICAgICAgIHwgICAyICsKc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2RhdGV0aW1l LmMgICAgICAgICAgfCAyNDIgKysrKysrKysrKysrKysrKysrKysrKysrKysrLS0tCnNyYy9pbmNs dWRlL2NhdGFsb2cvY2F0dmVyc2lvbi5oICAgICAgICAgIHwgICAyICstCnNyYy9pbmNsdWRlL2Nh dGFsb2cvcGdfcHJvYy5kYXQgICAgICAgICAgIHwgIDEyICstCnNyYy9pbmNsdWRlL3BndGltZS5o ICAgICAgICAgICAgICAgICAgICAgIHwgICA3ICsKc3JjL2luY2x1ZGUvdXRpbHMvZGF0ZXRpbWUu aCAgICAgICAgICAgICAgfCAgIDIgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2hvcm9sb2d5 Lm91dCAgICB8ICAgNiArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcnVsZXMub3V0ICAgICAg IHwgIDE3ICsrLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3N5c3ZpZXdzLm91dCAgICB8ICAg OCArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdGltZXN0YW1wdHoub3V0IHwgIDU5ICsrKysr KysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2hvcm9sb2d5LnNxbCAgICAgICAgIHwgICAxICsKc3Jj L3Rlc3QvcmVncmVzcy9zcWwvc3lzdmlld3Muc3FsICAgICAgICAgfCAgIDMgKwpzcmMvdGVzdC9y ZWdyZXNzL3NxbC90aW1lc3RhbXB0ei5zcWwgICAgICB8ICAxNyArKysKc3JjL3RpbWV6b25lL2xv Y2FsdGltZS5jICAgICAgICAgICAgICAgICAgfCAxMTQgKysrKysrKysrKysrKysKc3JjL3Rvb2xz L3BnaW5kZW50L3R5cGVkZWZzLmxpc3QgICAgICAgICAgfCAgIDEgKwoyMCBmaWxlcyBjaGFuZ2Vk LCA1MjEgaW5zZXJ0aW9ucygrKSwgMzUgZGVsZXRpb25zKC0pCgo= --===============1170612592395987948==--