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 1rhJpb-00ApOh-1E for pgsql-committers@arkaria.postgresql.org; Tue, 05 Mar 2024 01:42:59 +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 1rhJpY-00CGQX-Mw for pgsql-committers@arkaria.postgresql.org; Tue, 05 Mar 2024 01:42:57 +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 1rhJpX-00CGQP-US for pgsql-committers@lists.postgresql.org; Tue, 05 Mar 2024 01:42:56 +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 1rhJpP-002tBy-Cq for pgsql-committers@lists.postgresql.org; Tue, 05 Mar 2024 01:42:54 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=9NZbVLHCedyRS3/fMU9eF+BrQoRCs/nbQov0ZLEqMqE=; b=eG3IrAeCsJGWFRk7Ldqkwib37t DBkdP3PFNwqb5lyAT05FITjKfjZ/ecQj52PZ3kodee6mIQnRCC5vQRM/9HkNroXcPpFm+eQ4D0jLk 5zVVIjzlLkcHWH04y93KXznnSG2xl7Ku9BVIuiup5O4J+0dlTSCSUzrRFauTXJi09ilY79f6hqBRd JGxtc0cRu8+yFHu1j8OYwZoyIrF48WYyrDjTKBvQZt1xG8Pe8vgpziutFW13IMS+xX/E0dae7HXoY IIDg8Kofr+2bVTI3sZXpWD0AEjx1wjXpEAj/Ps4Fwh3kvPTxQRyCEY54I+8B5Cnre+ARmnHx+d+Wc AZEfEWSg==; 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 1rhJpP-006qBb-9a for pgsql-committers@lists.postgresql.org; Tue, 05 Mar 2024 01:42:47 +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 1rhJpO-0027Wf-9L for pgsql-committers@lists.postgresql.org; Tue, 05 Mar 2024 01:42:46 +0000 Content-Type: multipart/mixed; boundary="===============8545499516831941654==" MIME-Version: 1.0 From: Jeff Davis To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix search_path to a safe value during maintenance operations. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 05 Mar 2024 01:42:46 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8545499516831941654== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHNlYXJjaF9wYXRoIHRvIGEgc2FmZSB2YWx1ZSBkdXJpbmcgbWFpbnRlbmFuY2Ugb3BlcmF0 aW9ucy4KCldoaWxlIGV4ZWN1dGluZyBtYWludGVuYW5jZSBvcGVyYXRpb25zIChBTkFMWVpFLCBD TFVTVEVSLCBSRUZSRVNICk1BVEVSSUFMSVpFRCBWSUVXLCBSRUlOREVYLCBvciBWQUNVVU0pLCBz ZXQgc2VhcmNoX3BhdGggdG8KJ3BnX2NhdGFsb2csIHBnX3RlbXAnIHRvIHByZXZlbnQgaW5jb25z aXN0ZW50IGJlaGF2aW9yLgoKRnVuY3Rpb25zIHRoYXQgYXJlIHVzZWQgZm9yIGZ1bmN0aW9uYWwg aW5kZXhlcywgaW4gaW5kZXggZXhwcmVzc2lvbnMsCm9yIGluIG1hdGVyaWFsaXplZCB2aWV3cyBh bmQgZGVwZW5kIG9uIGEgZGlmZmVyZW50IHNlYXJjaCBwYXRoIG11c3QgYmUKZGVjbGFyZWQgd2l0 aCBDUkVBVEUgRlVOQ1RJT04gLi4uIFNFVCBzZWFyY2hfcGF0aD0nLi4uJy4KClRoaXMgY2hhbmdl IHdhcyBwcmV2aW91c2x5IGNvbW1pdHRlZCBhcyAwNWUxNzM3MzUxLCB0aGVuIHJldmVydGVkIGlu CmNvbW1pdCAyZmNjN2VlN2FmIGJlY2F1c2UgaXQgd2FzIHRvbyBsYXRlIGluIHRoZSBjeWNsZS4K ClByZXBhcmF0aW9uIGZvciB0aGUgTUFJTlRBSU4gcHJpdmlsZWdlLCB3aGljaCB3YXMgcHJldmlv dXNseSByZXZlcnRlZApkdWUgdG8gc2VhcmNoX3BhdGggbWFuaXB1bGF0aW9uIGhhemFyZHMuCgpE aXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL2Q0Y2NhZjM2NThjYjNjMjgxZWM4OGM4NTFh MDk3MzNjZDk0ODJmMjIuY2FtZWxAai1kYXZpcy5jb20KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS9FMXE3ajdZLTAwMHoxSC1IciU0MGdlbXVsb24ucG9zdGdyZXNxbC5vcmcKRGlzY3Vz c2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9lNDQzMjcxNzllNWM5MDE1YzhkZGE2NzM1MWMwNGRh NTUyMDY2MDE3LmNhbWVsJTQwai1kYXZpcy5jb20KUmV2aWV3ZWQtYnk6IEdyZWcgU3RhcmssIE5h dGhhbiBCb3NzYXJ0LCBOb2FoIE1pc2NoCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwot LS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMmFmMDdlMmY3 NDlhOTIwOGNhMWVkODRmYTFkOGZlMGU3NTgzMzI4OAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0t LS0tLS0KY29udHJpYi9hbWNoZWNrL3QvMDA0X3ZlcmlmeV9uYnRyZWVfdW5pcXVlLnBsICAgICAg fCAzMyArKysrKysrKystLS0tLS0tCmNvbnRyaWIvYW1jaGVjay92ZXJpZnlfbmJ0cmVlLmMgICAg ICAgICAgICAgICAgICAgIHwgIDIgKwpkb2Mvc3JjL3NnbWwvYW1jaGVjay5zZ21sICAgICAgICAg ICAgICAgICAgICAgICAgICB8ICAzICsrCmRvYy9zcmMvc2dtbC9icmluLnNnbWwgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIHwgIDQgKy0KZG9jL3NyYy9zZ21sL3JlZi9hbmFseXplLnNnbWwg ICAgICAgICAgICAgICAgICAgICAgfCAgNiArKysKZG9jL3NyYy9zZ21sL3JlZi9jbHVzdGVyLnNn bWwgICAgICAgICAgICAgICAgICAgICAgfCAgNiArKysKZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVf aW5kZXguc2dtbCAgICAgICAgICAgICAgICAgfCAgNiArKysKZG9jL3NyYy9zZ21sL3JlZi9yZWZy ZXNoX21hdGVyaWFsaXplZF92aWV3LnNnbWwgICAgfCAgNiArKysKZG9jL3NyYy9zZ21sL3JlZi9y ZWluZGV4LnNnbWwgICAgICAgICAgICAgICAgICAgICAgfCAgNiArKysKZG9jL3NyYy9zZ21sL3Jl Zi92YWN1dW0uc2dtbCAgICAgICAgICAgICAgICAgICAgICAgfCAgNiArKysKc3JjL2JhY2tlbmQv YWNjZXNzL2JyaW4vYnJpbi5jICAgICAgICAgICAgICAgICAgICAgfCAgMiArCnNyYy9iYWNrZW5k L2NhdGFsb2cvaW5kZXguYyAgICAgICAgICAgICAgICAgICAgICAgIHwgIDkgKysrKysKc3JjL2Jh Y2tlbmQvY2F0YWxvZy9uYW1lc3BhY2UuYyAgICAgICAgICAgICAgICAgICAgfCAgMyArKwpzcmMv YmFja2VuZC9jb21tYW5kcy9hbmFseXplLmMgICAgICAgICAgICAgICAgICAgICB8ICAyICsKc3Jj L2JhY2tlbmQvY29tbWFuZHMvY2x1c3Rlci5jICAgICAgICAgICAgICAgICAgICAgfCAgMiArCnNy Yy9iYWNrZW5kL2NvbW1hbmRzL2luZGV4Y21kcy5jICAgICAgICAgICAgICAgICAgIHwgIDggKysr KwpzcmMvYmFja2VuZC9jb21tYW5kcy9tYXR2aWV3LmMgICAgICAgICAgICAgICAgICAgICB8ICAy ICsKc3JjL2JhY2tlbmQvY29tbWFuZHMvdmFjdXVtLmMgICAgICAgICAgICAgICAgICAgICAgfCAg MiArCnNyYy9iaW4vc2NyaXB0cy90LzEwMF92YWN1dW1kYi5wbCAgICAgICAgICAgICAgICAgIHwg IDQgLS0Kc3JjL2luY2x1ZGUvdXRpbHMvZ3VjLmggICAgICAgICAgICAgICAgICAgICAgICAgICAg fCAgNiArKysKLi4uL3Rlc3Rfb2F0X2hvb2tzL2V4cGVjdGVkL2FsdGVyX3RhYmxlLm91dCAgICAg ICAgfCAgMiArCi4uLi90ZXN0X29hdF9ob29rcy9leHBlY3RlZC90ZXN0X29hdF9ob29rcy5vdXQg ICAgIHwgIDQgKysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9tYXR2aWV3Lm91dCAgICAgICAg ICAgICAgfCAgNCArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL25hbWVzcGFjZS5vdXQgICAg ICAgICAgICB8IDQ0ICsrKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC9wcml2aWxlZ2VzLm91dCAgICAgICAgICAgfCAxMiArKystLS0Kc3JjL3Rlc3QvcmVncmVz cy9leHBlY3RlZC92YWN1dW0ub3V0ICAgICAgICAgICAgICAgfCAgMiArLQpzcmMvdGVzdC9yZWdy ZXNzL3NxbC9tYXR2aWV3LnNxbCAgICAgICAgICAgICAgICAgICB8ICA0ICstCnNyYy90ZXN0L3Jl Z3Jlc3Mvc3FsL25hbWVzcGFjZS5zcWwgICAgICAgICAgICAgICAgIHwgMzIgKysrKysrKysrKysr KysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9wcml2aWxlZ2VzLnNxbCAgICAgICAgICAgICAgICB8 ICA4ICsrLS0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvdmFjdXVtLnNxbCAgICAgICAgICAgICAgICAg ICAgfCAgMiArLQozMCBmaWxlcyBjaGFuZ2VkLCAyMDAgaW5zZXJ0aW9ucygrKSwgMzIgZGVsZXRp b25zKC0pCgo= --===============8545499516831941654==--