Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jqJAX-000336-RF for pgsql-bugs@arkaria.postgresql.org; Tue, 30 Jun 2020 16:31:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jqJAW-0005t4-PI for pgsql-bugs@arkaria.postgresql.org; Tue, 30 Jun 2020 16:31:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jqJ0K-00036m-Hi for pgsql-bugs@lists.postgresql.org; Tue, 30 Jun 2020 16:21:04 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jqJ0I-000290-D0 for pgsql-bugs@lists.postgresql.org; Tue, 30 Jun 2020 16:21:04 +0000 Content-Type: multipart/mixed; boundary="===============2664067231710133081==" MIME-Version: 1.0 Subject: BUG #16519: SET SESSION ROLE in plpgsql requires string literal. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mbwiese@gmail.com Reply-To: mbwiese@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 30 Jun 2020 16:20:03 +0000 Message-ID: <16519-9ef04828d058a319@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============2664067231710133081== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjUxOQpMb2dnZWQgYnk6ICAgICAgICAgIE1hcmlhbm5lIEIuIFdpZXNl CkVtYWlsIGFkZHJlc3M6ICAgICAgbWJ3aWVzZUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxMC4xMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAxOC4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGRvY3VtZW50YXRpb24gc2F5czogDQpUaGlzIGNvbW1hbmQgc2V0cyB0aGUgY3Vy cmVudCB1c2VyIGlkZW50aWZpZXIgb2YgdGhlIGN1cnJlbnQgU1FMIHNlc3Npb24gdG8KYmUgcm9s ZV9uYW1lLiBUaGUgcm9sZSBuYW1lIGNhbiBiZSB3cml0dGVuIGFzIGVpdGhlciBhbiBpZGVudGlm aWVyIG9yIGEKc3RyaW5nIGxpdGVyYWwuIEFmdGVyIFNFVCBST0xFLCBwZXJtaXNzaW9ucyBjaGVj a2luZyBmb3IgU1FMIGNvbW1hbmRzIGlzCmNhcnJpZWQgb3V0IGFzIHRob3VnaCB0aGUgbmFtZWQg cm9sZSB3ZXJlIHRoZSBvbmUgdGhhdCBoYWQgbG9nZ2VkIGluCm9yaWdpbmFsbHkuDQoNCkhvd2V2 ZXIsIHRoZSBsb29wIGluIGJlbG93IGZ1bmN0aW9uIGdpdmVzIG1lIGFuIGVycm9yOg0KWzIyMDIz XSBFUlJPUjogcm9sZSAiaW51c2VyIiBkb2VzIG5vdCBleGlzdCBXaGVyZTogU1FMIHN0YXRlbWVu dCAiU0VUClNFU1NJT04gUk9MRSBUTyBJblVzZXIiIFBML3BnU1FMIGZ1bmN0aW9uIGNoYW5nZV91 c2VyKG5hbWUpIGxpbmUgOCBhdCBTUUwKc3RhdGVtZW50Lg0KDQpJIGNhbiBvbmx5IG1ha2UgaXQg d29yayB3aXRoIHN0cmluZyBsaXRlcmFscywgYXMgaW4gdGhlIGNvbW1lbnRlZCBvdXQKc2VjdGlv bi4NCg0KQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gcHVibGljLmNoYW5nZV91c2VyKEluVXNl ciBuYW1lKSBSRVRVUk5TIHZvaWQgQVMKJCQNCiAgICBERUNMQVJFDQogICAgciBSRUNPUkQ7DQog ICAgQkVHSU4NCiAgICAgICAgRk9SIHIgSU4gU0VMRUNUIHJvbGUgRlJPTSBwdWJsaWMuZWRpdG9y cw0KICAgICAgICAgICAgTE9PUA0KICAgICAgICAgICAgICAgIElGICggSW5Vc2VyID0gci5yb2xl ICkgVEhFTg0KICAgICAgICAgICAgICAgICAgICBTRVQgU0VTU0lPTiBST0xFIFRPIEluVXNlcjsN CiAgICAgICAgICAgICAgICBlbmQgaWY7DQogICAgICAgICAgICBFTkQgTE9PUDsNCi8qICAgICAg ICBJRiAoIEluVXNlciA9ICdtYndAZ2V1cy5kaycgKSBUSEVODQogICAgICAgICAgICBTRVQgU0VT U0lPTiBST0xFIFRPICdtYndAZ2V1cy5kayc7DQogICAgICAgIEVMU0VJRiAoIEluVXNlciA9ICdq b3RoQGdldXMuZGsnKSBUSEVODQogICAgICAgICAgICBTRVQgU0VTU0lPTiBST0xFIFRPICdqb3Ro QGdldXMuZGsnOw0KICAgICAgICBFTFNFIHJhaXNlIGludmFsaWRfcm9sZV9zcGVjaWZpY2F0aW9u IHVzaW5nIG1lc3NhZ2UgPSAnYXV0aGVudGljYXRvcgpjYW4gbm90IGJlIHx8ICcgKyBJblVzZXI7 DQogICAgICAgIEVORCBJRjsNCiovDQogICAgRU5EDQokJCBMQU5HVUFHRSBwbHBnc3FsOwoK --===============2664067231710133081==--