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 1tb0yB-007Db3-0J for pgsql-committers@arkaria.postgresql.org; Thu, 23 Jan 2025 17:26:19 +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 1tb0y9-0019mE-Um for pgsql-committers@arkaria.postgresql.org; Thu, 23 Jan 2025 17:26:17 +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 1tb0y9-0019m6-O3 for pgsql-committers@lists.postgresql.org; Thu, 23 Jan 2025 17:26:17 +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 1tb0y6-0017dC-1K for pgsql-committers@lists.postgresql.org; Thu, 23 Jan 2025 17:26:17 +0000 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 1tb0y4-009UbS-SR for pgsql-committers@lists.postgresql.org; Thu, 23 Jan 2025 17:26:12 +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 1tb0y4-0037sb-1e for pgsql-committers@lists.postgresql.org; Thu, 23 Jan 2025 17:26:12 +0000 Content-Type: multipart/mixed; boundary="===============5825366081711030227==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Ensure that AFTER triggers run as the instigating user. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 23 Jan 2025 17:26:12 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5825366081711030227== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RW5zdXJlIHRoYXQgQUZURVIgdHJpZ2dlcnMgcnVuIGFzIHRoZSBpbnN0aWdhdGluZyB1c2VyLgoK V2l0aCBkZWZlcnJlZCB0cmlnZ2VycywgaXQgaXMgcG9zc2libGUgdGhhdCB0aGUgY3VycmVudCBy b2xlIGNoYW5nZXMKYmV0d2VlbiB0aGUgdGltZSB3aGVuIHRoZSB0cmlnZ2VyIGlzIHF1ZXVlZCBh bmQgdGhlIHRpbWUgaXQgaXMKZXhlY3V0ZWQgKGZvciBleGFtcGxlLCB0aGUgdHJpZ2dlcmluZyBk YXRhIG1vZGlmaWNhdGlvbiBjb3VsZCBoYXZlCmJlZW4gZXhlY3V0ZWQgaW4gYSBTRUNVUklUWSBE RUZJTkVSIGZ1bmN0aW9uKS4KClVwIHRvIG5vdywgZGVmZXJyZWQgdHJpZ2dlciBmdW5jdGlvbnMg d291bGQgcnVuIHdpdGggdGhlIGN1cnJlbnQgcm9sZQpzZXQgdG8gd2hhdGV2ZXIgd2FzIGFjdGl2 ZSBhdCBjb21taXQgdGltZS4gIFRoYXQgZG9lcyBub3QgbWF0dGVyIGZvcgpmb3JlaWduLWtleSBj b25zdHJhaW50cywgd2hvc2UgY29ycmVjdG5lc3MgZG9lc24ndCBkZXBlbmQgb24gdGhlCmN1cnJl bnQgcm9sZS4gIEJ1dCBmb3IgdXNlci13cml0dGVuIHRyaWdnZXJzLCB0aGUgY3VycmVudCByb2xl CmNlcnRhaW5seSBjYW4gbWF0dGVyLgoKSGVuY2UsIGZpeCB0aGluZ3Mgc28gdGhhdCBBRlRFUiB0 cmlnZ2VycyBhcmUgZmlyZWQgdW5kZXIgdGhlIHJvbGUKdGhhdCB3YXMgYWN0aXZlIHdoZW4gdGhl eSB3ZXJlIHF1ZXVlZCwgbWF0Y2hpbmcgdGhlIGJlaGF2aW9yIG9mCkJFRk9SRSB0cmlnZ2VycyB3 aGljaCB3b3VsZCBoYXZlIGFjdHVhbGx5IGZpcmVkIGF0IHRoYXQgdGltZS4KKElmIHRoZSB0cmln Z2VyIGZ1bmN0aW9uIGlzIG1hcmtlZCBTRUNVUklUWSBERUZJTkVSLCB0aGF0IG9mIGNvdXJzZQpv dmVycmlkZXMgdGhpcywgYXMgaXQgYWx3YXlzIGhhcy4pCgpUaGlzIGRvZXMgbm90IGNyZWF0ZSBh bnkgbmV3IHNlY3VyaXR5IGV4cG9zdXJlOiBpZiB5b3UgZG8gRE1MIG9uIGEKdGFibGUgb3duZWQg YnkgYSBob3N0aWxlIHVzZXIsIHRoYXQgdXNlciBoYXMgYWx3YXlzIGhhZCB2YXJpb3VzIHdheXMK dG8gZXhwbG9pdCB5b3VyIHBlcm1pc3Npb25zLCBzdWNoIGFzIHRoZSBhZm9yZW1lbnRpb25lZCBC RUZPUkUKdHJpZ2dlcnMsIGRlZmF1bHQgZXhwcmVzc2lvbnMsIGV0Yy4gIEl0IG1pZ2h0IHJlbW92 ZSBzb21lIHNlY3VyaXR5CmV4cG9zdXJlLCBiZWNhdXNlIHRoZSBvbGQgYmVoYXZpb3IgY291bGQg cG90ZW50aWFsbHkgZXhwb3NlIHNvbWUKb3RoZXIgcm9sZSBiZXNpZGVzIHRoZSBvbmUgZGlyZWN0 bHkgbW9kaWZ5aW5nIHRoZSB0YWJsZS4KClRoZXJlIHdhcyBkaXNjdXNzaW9uIG9mIG1ha2luZyBh IGxhcmdlciBjaGFuZ2UsIHN1Y2ggYXMgcnVubmluZyBhcwp0aGUgdHJpZ2dlcidzIG93bmVyLiAg SG93ZXZlciwgdGhhdCB3b3VsZCBicmVhayB0aGUgY29tbW9uIGlkaW9tIG9mCmNhcHR1cmluZyB0 aGUgdmFsdWUgb2YgQ1VSUkVOVF9VU0VSIGluIGEgdHJpZ2dlciBmb3IgYXVkaXRpbmcvbG9nZ2lu ZwpwdXJwb3Nlcy4gIFRoaXMgY2hhbmdlIHdpbGwgbWFrZSBubyBkaWZmZXJlbmNlIGluIHRoZSB0 eXBpY2FsIHNjZW5hcmlvCndoZXJlIHRoZSBjdXJyZW50IHJvbGUgZG9lc24ndCBjaGFuZ2UgYmVm b3JlIGNvbW1pdC4KCkFyZ3VhYmx5IHRoaXMgaXMgYSBidWcgZml4LCBidXQgaXQgc2VlbXMgdG9v IGJpZyBhIHNlbWFudGljIGNoYW5nZQp0byBjb25zaWRlciBmb3IgYmFjay1wYXRjaGluZy4KCkF1 dGhvcjogTGF1cmVueiBBbGJlIDxsYXVyZW56LmFsYmVAY3liZXJ0ZWMuYXQ+ClJldmlld2VkLWJ5 OiBKb3NlcGggS29zaGFrb3cgPGtvc2h5NDRAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogUGF2ZWwg U3RlaHVsZSA8cGF2ZWwuc3RlaHVsZUBnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9z dGdyLmVzL20vNzdlZTc4NGNmMjQ4ZTg0MmY3NDU4ODQxOGY1NWMyOTMxZTQ3YmQ3OC5jYW1lbEBj eWJlcnRlYy5hdAoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczov L2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzAxNDYzZTFjY2NkMzNmYjExYjMzYTRk ZDZkYmViY2FkM2M1MzQxMDIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMv c2dtbC90cmlnZ2VyLnNnbWwgICAgICAgICAgICAgIHwgIDQgKysKc3JjL2JhY2tlbmQvY29tbWFu ZHMvdHJpZ2dlci5jICAgICAgICAgfCAyMCArKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvdHJpZ2dlcnMub3V0IHwgNjcgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysr KwpzcmMvdGVzdC9yZWdyZXNzL3NxbC90cmlnZ2Vycy5zcWwgICAgICB8IDYzICsrKysrKysrKysr KysrKysrKysrKysrKysrKysrKysrCjQgZmlsZXMgY2hhbmdlZCwgMTU0IGluc2VydGlvbnMoKykK Cg== --===============5825366081711030227==--