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 1ukV0g-003Bjx-HS for pgsql-docs@arkaria.postgresql.org; Fri, 08 Aug 2025 21:52: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 1ukV0f-00Gkem-8j for pgsql-docs@arkaria.postgresql.org; Fri, 08 Aug 2025 21:52:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ukFRd-006MRQ-AH for pgsql-docs@lists.postgresql.org; Fri, 08 Aug 2025 05:15:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ukFRa-001NqA-2c for pgsql-docs@lists.postgresql.org; Fri, 08 Aug 2025 05:15:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=zIw/8a5bO6lIYBaVivImG7TEfs5g0eIfWz6KfjpSSsg=; b=uBZMJ/6Sf7JY0Ss0OP2167avgl +Ge0H98p452Ry0Pcm0R6HiZGIuRvIOU4MrupVBL6UpwDpsDI0DDZrfwK3GX8LLHzML+BpA2ngp8Lk IJ7A9fvOGh+AqSV/n0xDf9p99+adDk/lhpzrVzqTAzm9movTLQOR6wZKTpA+h3xbY/kQNxQVqouUz hEtmNOBIuEd7un2JeL5jShQucsPAbS3RrlwKkzdF+jlgzy3Crp606iKVq88Gvs9MeftDQJjdAcZQC tuyLn2riE6rZAQkRuut9XDdhSqV7eSKiXDFmrOGy5SMaWuAx2LRIKYBP+rGhECyI1WRXssX8O9LXY 7D7ZXM5A==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ukFRY-003cNM-Oo for pgsql-docs@lists.postgresql.org; Fri, 08 Aug 2025 05:15:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ukFRX-006txz-1r for pgsql-docs@lists.postgresql.org; Fri, 08 Aug 2025 05:15:03 +0000 Content-Type: multipart/mixed; boundary="===============2972502519149110580==" MIME-Version: 1.0 Subject: Removing publicly-writable schemas from search_path with ECPG To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: lance.robson@gmail.com Reply-To: lance.robson@gmail.com, pgsql-docs@lists.postgresql.org Date: Fri, 08 Aug 2025 05:14:56 +0000 Message-ID: <175463009658.797.7673870651535719486@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2972502519149110580== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNy9lY3Bn LWNvbm5lY3QuaHRtbApEZXNjcmlwdGlvbjoKCkhlbGxvLAoKVGhpcyBjb21tZW50IHJlbGF0ZXMg dG8gdGhlIGxhc3QgcGFyYWdyYXBoIG9mIHNlY3Rpb24gMzQuMi4xIG9mIHRoZSBQb3N0Z3Jlcwox NiBkb2N1bWVudGF0aW9uLgoKSSBhbSBsZWFybmluZyB0byB1c2UgRUNQRyBhbmQgdHJ5aW5nIHRv IGZvbGxvdyBiZXN0IHByYWN0aWNlcy4KCkFmdGVyIGNvbm5lY3RpbmcgdG8gbXkgZGF0YWJhc2Us IEkgYW0gdHJ5aW5nIHRvIHJlbW92ZSBwdWJsaWNseS13cml0YWJsZQpzY2hlbWFzIGZyb20gc2Vh cmNoX3BhdGggdXNpbmcgdGhlIGNvbW1hbmQgIkVYRUMgU1FMIFNFTEVDVApwZ19jYXRhbG9nLnNl dF9jb25maWcoJ3NlYXJjaF9wYXRoJywgJycsIGZhbHNlKSIuICBVbmZvcnR1bmF0ZWx5LCB0aGF0 CmNvbW1hbmQgc2VlbXMgdG8gZmFpbC4KClRoZSBmb2xsb3dpbmcgZnVuY3Rpb24gKGZyb20gc2Vj dGlvbiAzNi44LjIuIG9mIHRoZSBkb2N1bWVudGF0aW9uKQogIHZvaWQKICAgIHByaW50X3NxbGNh KCkKICB7CiAgICBmcHJpbnRmKHN0ZGVyciwgIj09PT0gc3FsY2EgPT09PVxuIik7CiAgICBmcHJp bnRmKHN0ZGVyciwgInNxbGNvZGU6ICVsZFxuIiwgc3FsY2Euc3FsY29kZSk7CiAgICBmcHJpbnRm KHN0ZGVyciwgInNxbGVycm0uc3FsZXJybWw6ICVkXG4iLCBzcWxjYS5zcWxlcnJtLnNxbGVycm1s KTsKICAgIGZwcmludGYoc3RkZXJyLCAic3FsZXJybS5zcWxlcnJtYzogJXNcbiIsIHNxbGNhLnNx bGVycm0uc3FsZXJybWMpOwogICAgZnByaW50ZihzdGRlcnIsICJzcWxlcnJkOiAlbGQgJWxkICVs ZCAlbGQgJWxkICVsZFxuIiwKICAgICAgICAgICAgc3FsY2Euc3FsZXJyZFswXSxzcWxjYS5zcWxl cnJkWzFdLHNxbGNhLnNxbGVycmRbMl0sCiAgICAgICAgICAgIHNxbGNhLnNxbGVycmRbM10sc3Fs Y2Euc3FsZXJyZFs0XSxzcWxjYS5zcWxlcnJkWzVdKTsKICAgIGZwcmludGYoc3RkZXJyLCAic3Fs d2FybjogJWQgJWQgJWQgJWQgJWQgJWQgJWQgJWRcbiIsCiAgICAgICAgICAgIHNxbGNhLnNxbHdh cm5bMF0sIHNxbGNhLnNxbHdhcm5bMV0sIHNxbGNhLnNxbHdhcm5bMl0sCiAgICAgICAgICAgIHNx bGNhLnNxbHdhcm5bM10sIHNxbGNhLnNxbHdhcm5bNF0sIHNxbGNhLnNxbHdhcm5bNV0sCiAgICAg ICAgICAgIHNxbGNhLnNxbHdhcm5bNl0sIHNxbGNhLnNxbHdhcm5bN10pOwogICAgZnByaW50Zihz dGRlcnIsICJzcWxzdGF0ZTogJTVzXG4iLCBzcWxjYS5zcWxzdGF0ZSk7CiAgICBmcHJpbnRmKHN0 ZGVyciwgIj09PT09PT09PT09PT09PVxuIik7CiAgfQpwcm9kdWNlcyB0aGUgZm9sbG93aW5nIG91 dHB1dDoKPT09PSBzcWxjYSA9PT09CnNxbGNvZGU6IC0yMDIKc3FsZXJybS5zcWxlcnJtbDogMjgK c3FsZXJybS5zcWxlcnJtYzogdG9vIGZldyBhcmd1bWVudHMgb24gbGluZSAyNQpzcWxlcnJkOiAw IDAgMSAwIDAgMApzcWx3YXJuOiAwIDAgMCAwIDAgMCAwIDAKc3Fsc3RhdGU6IDA3MDAyCj09PT09 PT09PT09PT09PQpMaW5lIDI1IG9mIG15IC5wZ2MgZmlsZSBpcyB3aGVyZSBJIGNhbGwgRVhFQyBT UUwgU0VMRUNUCnBnX2NhdGFsb2cuc2V0X2NvbmZpZy4KCkkgd291bGQgYXBwcmVjaWF0ZSBhbnkg Z3VpZGFuY2UuICBQbGVhc2UgbGV0IG1lIGtub3cgaWYgdGhpcyBpbnF1aXJ5IHdvdWxkCmJlIGJl dHRlciBzdWl0ZWQgZm9yIGEgZGlmZmVyZW50IGZvcnVtLCBzdWNoIGFzIHN0YWNrZXhjaGFuZ2Uu Cg== --===============2972502519149110580==--