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.96) (envelope-from ) id 1vQTHQ-008IbK-26 for pgsql-docs@arkaria.postgresql.org; Tue, 02 Dec 2025 16:31:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vQTHP-0092gr-2P for pgsql-docs@arkaria.postgresql.org; Tue, 02 Dec 2025 16:31:08 +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.96) (envelope-from ) id 1vQSuA-008n1h-2V for pgsql-docs@lists.postgresql.org; Tue, 02 Dec 2025 16:07:07 +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 1vQSu8-002m39-1Y for pgsql-docs@lists.postgresql.org; Tue, 02 Dec 2025 16:07:06 +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=lVkhgr9FpeBW+f0hJtEZIta4qdH2T02xC7vY/4mfscU=; b=mLEfvV6GqT+Q2cSs+Z48ZRV56R LzqLbAberSLYkPQmzoozD9s2lw0w2xs9cSQhjHEa2EqO35I74FhUP+eoL4SbBuoBtAMDNz6ECUhwn q5D+67XYK3HQmxxu1s5JeeF7QVUxGDhfSnkwmJrzy/JncFU3Qz8yRxzgL8umv9pUtzXVpY4ejhvF2 1xMMcBWW9vcJHjHWoNRu965BmADrrJ/URKru0hqj01y78PXUT77DDh/c/FlFuMEfM3sOWgAt2P6lp cdxHcLk2PFnuSHHbI+tqpbfscOrJlAEAiiwTMPIRlWuvaaCitlV+7rnHGyMd4AYB18o5rNm6k1oi0 j2by+yOg==; 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.96) (envelope-from ) id 1vQSu8-0044om-26 for pgsql-docs@lists.postgresql.org; Tue, 02 Dec 2025 16:07:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vQSu6-003qEB-0z for pgsql-docs@lists.postgresql.org; Tue, 02 Dec 2025 16:07:03 +0000 Content-Type: multipart/mixed; boundary="===============4800572460737366722==" MIME-Version: 1.0 Subject: Add "current_setting('role');" to trigger function examples of audit tables To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: mark@clow.es Reply-To: mark@clow.es, pgsql-docs@lists.postgresql.org Date: Tue, 02 Dec 2025 16:06:07 +0000 Message-ID: <176469156745.2921403.7483097841149354308@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 --===============4800572460737366722== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xOC9wbHBn c3FsLXRyaWdnZXIuaHRtbApEZXNjcmlwdGlvbjoKClRoZSBkb2MgcGFnZSBodHRwczovL3d3dy5w b3N0Z3Jlc3FsLm9yZy9kb2NzLzE4L3BscGdzcWwtdHJpZ2dlci5odG1sCmNvbnRhaW5zIGV4YW1w bGVzIG9mIHVzaW5nIHRyaWdnZXIgZnVuY3Rpb25zIHRvIG1ha2UgYW4gYXVkaXQgdGFibGUuIFdo ZW4KU0VDVVJJVFkgREVGSU5FUiBpcyB1c2VkIGluIGNvbmp1bmN0aW9uIHdpdGggU0VUIFJPTEUg aXQgd2FzIG5vdCBjbGVhciB0byBtZQpob3cgdG8gc3RvcmUgdGhlIGFjdGluZyByb2xlIGluIHRo ZSBhdWRpdCB0YWJsZSByYXRoZXIgdGhhbiB0aGUgb3duZXIgb2YgdGhlCnRyaWdnZXIgZnVuY3Rp b24gKGkuZS4gY3VycmVudF91c2VyLCBzZXNzaW9uX3VzZXIpLgoKSSBmb3VuZCBhbiBvbGQgbWFp bGluZyBsaXN0IG1lc3NhZ2UKaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9m bGF0LzAwMDgwMWM2NDE0MyUyNDMxM2JiYTUwJTI0MWUwMWE4YzAlNDB3ZWFzZWwKdGhhdCBzdWdn ZXN0cyB1c2luZyAiY3VycmVudF9zZXR0aW5nKCdyb2xlJyk7IiwgYW5kIHNlZW1zIHRvIGRvIGV4 YWN0bHkgd2hhdApJIG5lZWQuIFRoaXMgc2VlbXMgdG8gYmUgbGl0dGxlIGtub3duIGluZm9ybWF0 aW9uIGFzIHNlYXJjaGluZyB0aGUgd2ViCnN1Z2dlc3RzIGFsbCBzb3J0cyBvZiBkaWZmZXJlbnQg d29ya2Fyb3VuZHMgZm9yIHRoaXMgc2NlbmFyaW8gd2l0aCBCRUZPUkUKdHJpZ2dlcnMgb3IgY3Jl YXRpbmcgY3VzdG9tIHNldHRpbmdzLiBUaGVyZWZvcmUgSSBzdWdnZXN0IHRoaXMga25vd2xlZGdl IGlzCnJlZGlzY292ZXJlZCBhbmQgbWVudGlvbmVkIGluIHRoZSBvZmZpY2lhbCBkb2N1bWVudGF0 aW9uIGluCnBscGdzcWwtdHJpZ2dlci5odG1sLgo= --===============4800572460737366722==--