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 1qyqOC-00BV7P-1z for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Nov 2023 09:22:52 +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 1qyqOA-00HMq9-Mw for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Nov 2023 09:22:50 +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 1qyqOA-00HMq1-CZ for pgsql-hackers@lists.postgresql.org; Fri, 03 Nov 2023 09:22:50 +0000 Received: from mail-yb1-f173.google.com ([209.85.219.173]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qyqO8-004T1w-65 for pgsql-hackers@postgresql.org; Fri, 03 Nov 2023 09:22:49 +0000 Received: by mail-yb1-f173.google.com with SMTP id 3f1490d57ef6-d9a58f5f33dso1856544276.1 for ; Fri, 03 Nov 2023 02:22:48 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699003367; x=1699608167; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=fBq+jldAU5lEzWPdB+ElNTM6jh4WzepQigPODA/wdwY=; b=Ll8wHq4FF4OXmGKvoCEa2LlSxwj76PMxO2kN706D4ZXXCasRy2KuLsS+hFLJ6qiJpx daNCTQkFugXzAbrOQPttLsJf9iViu9QmS2HjhFQlUsZWmMz3VT3Is6MUc7DI6T7Qd4gi EGz3GWaPZQBPV+66GTX77gDg9yDnkDffIoWc1G8G2fTATnW/rU9cJnBjtSd9vJVE8g7j SeAlbyaCfKm09AVsY0Lq7m7OCHe77HAbFSYxL/UZrH9k380ffRChRelXG5FGsYRh9+BB xhhqzEiEylpxZFoPrqHDsAW7hEuqUK/7hkmZjAi++ZyhmJh033K8hsjegMlOaZEzGz+H +4Mg== X-Gm-Message-State: AOJu0YxNaRzxNrh8BFMi7ZsTlWKkxOZZYRG2MxOwYHZ8Nh4lFvNW4RMD lTB9hi+tZOF9Bj4ii5JyR9smMN2dZmBK1U0K5wWDiqMRmgW7n0VH8Ng= X-Google-Smtp-Source: AGHT+IFseG30kaePDilj+c0mVjK/PopXp0+16gZc3t1pFCkkBmjjJkTfV7bcBGuVaQujTRfG7VYXCWPPYiukufY1r6k= X-Received: by 2002:a25:e092:0:b0:d9a:e032:e1b5 with SMTP id x140-20020a25e092000000b00d9ae032e1b5mr19358280ybg.50.1699003366723; Fri, 03 Nov 2023 02:22:46 -0700 (PDT) MIME-Version: 1.0 References: <20849.1424445552@sss.pgh.pa.us> In-Reply-To: From: Jelte Fennema-Nio Date: Fri, 3 Nov 2023 10:22:35 +0100 Message-ID: Subject: Re: Report search_path value back to the client. To: Tom Lane Cc: Alexey Klyukin , Alexander Kukushkin , PostgreSQL-development Content-Type: multipart/mixed; boundary="00000000000025a0b306093c0cd1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000025a0b306093c0cd1 Content-Type: text/plain; charset="UTF-8" For completeness attached is a tiny patch implementing this, so this thread can be added to the commit fest. --00000000000025a0b306093c0cd1 Content-Type: application/octet-stream; name="v1-0001-Mark-search_path-as-GUC_REPORT.patch" Content-Disposition: attachment; filename="v1-0001-Mark-search_path-as-GUC_REPORT.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_loieprne0 RnJvbSAyMDBlY2RlYjBlOTc3MWY0ZDBiM2VjOGE1ZDdiMTFhNTU2MmE4NTYzIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBKZWx0ZSBGZW5uZW1hLU5pbyA8amVsdGUuZmVubmVtYUBtaWNy b3NvZnQuY29tPgpEYXRlOiBGcmksIDMgTm92IDIwMjMgMTA6MDk6NTIgKzAxMDAKU3ViamVjdDog W1BBVENIIHYxXSBNYXJrIHNlYXJjaF9wYXRoIGFzIEdVQ19SRVBPUlQKCkNvbm5lY3Rpb24gcG9v bGVycyB1c2UgR1VDX1JFUE9SVCB0byB0cmFjayBzZXNzaW9uIGxldmVsIFNFVCB3aGVuIHVzaW5n CnRyYW5zYWN0aW9uIHBvb2xpbmcuIHNlYXJjaF9wYXRoIGlzIG9uZSBvZiB0aGUgYmlnZ2VzdCBm b290IGd1bnMuIEhhdmluZwphbiB1bmV4cGVjdGVkIHNlYXJjaF9wYXRoIG9mdGVuIGJyZWFrcyBy dW5uaW5nIG9mIHF1ZXJpZXMuIEFuZCBtYW55CmFwcGxpY2F0aW9ucyBzZXQgYSBzZWFyY2hfcGF0 aCBhdCB0aGUgc2Vzc2lvbiBsZXZlbCwgcGdfZHVtcCBiZWluZyBvbmUKb2YgdGhvc2UuCi0tLQog c3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9ndWNfdGFibGVzLmMgfCAyICstCiAxIGZpbGUgY2hhbmdl ZCwgMSBpbnNlcnRpb24oKyksIDEgZGVsZXRpb24oLSkKCmRpZmYgLS1naXQgYS9zcmMvYmFja2Vu ZC91dGlscy9taXNjL2d1Y190YWJsZXMuYyBiL3NyYy9iYWNrZW5kL3V0aWxzL21pc2MvZ3VjX3Rh Ymxlcy5jCmluZGV4IDc2MDVlZmY5YjlkLi41MmU3MGRhNjYzOCAxMDA2NDQKLS0tIGEvc3JjL2Jh Y2tlbmQvdXRpbHMvbWlzYy9ndWNfdGFibGVzLmMKKysrIGIvc3JjL2JhY2tlbmQvdXRpbHMvbWlz Yy9ndWNfdGFibGVzLmMKQEAgLTQxMzUsNyArNDEzNSw3IEBAIHN0cnVjdCBjb25maWdfc3RyaW5n IENvbmZpZ3VyZU5hbWVzU3RyaW5nW10gPQogCQl7InNlYXJjaF9wYXRoIiwgUEdDX1VTRVJTRVQs IENMSUVOVF9DT05OX1NUQVRFTUVOVCwKIAkJCWdldHRleHRfbm9vcCgiU2V0cyB0aGUgc2NoZW1h IHNlYXJjaCBvcmRlciBmb3IgbmFtZXMgdGhhdCBhcmUgbm90IHNjaGVtYS1xdWFsaWZpZWQuIiks CiAJCQlOVUxMLAotCQkJR1VDX0xJU1RfSU5QVVQgfCBHVUNfTElTVF9RVU9URSB8IEdVQ19FWFBM QUlOCisJCQlHVUNfTElTVF9JTlBVVCB8IEdVQ19MSVNUX1FVT1RFIHwgR1VDX0VYUExBSU4gfCBH VUNfUkVQT1JUCiAJCX0sCiAJCSZuYW1lc3BhY2Vfc2VhcmNoX3BhdGgsCiAJCSJcIiR1c2VyXCIs IHB1YmxpYyIsCgpiYXNlLWNvbW1pdDogMzljOTU5ZWYyNWJkOWNkZDk2NmVlMDI0YWIxNGY4ZjQy MTRiYjI3NgotLSAKMi4zNC4xCgo= --00000000000025a0b306093c0cd1--