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 1npAd1-0003cf-Ui for pgsql-committers@arkaria.postgresql.org; Thu, 12 May 2022 15:21:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1npAcp-0006N4-Ic for pgsql-committers@arkaria.postgresql.org; Thu, 12 May 2022 15:21:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1no5SM-0004gq-Me for pgsql-committers@lists.postgresql.org; Mon, 09 May 2022 15:37:54 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1no5SG-0001WT-Bd for pgsql-committers@lists.postgresql.org; Mon, 09 May 2022 15:37:53 +0000 Received: from gemulon.postgresql.org ([72.32.157.198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1no5SF-000155-As for pgsql-committers@lists.postgresql.org; Mon, 09 May 2022 15:37:47 +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 1no5SD-000lVU-5g for pgsql-committers@lists.postgresql.org; Mon, 09 May 2022 15:37:46 +0000 Content-Type: multipart/mixed; boundary="===============3422919105245471426==" MIME-Version: 1.0 From: Noah Misch To: pgsql-committers@lists.postgresql.org Subject: pgsql: In REFRESH MATERIALIZED VIEW, set user ID before running user co X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 09 May 2022 15:37:46 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3422919105245471426== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW4gUkVGUkVTSCBNQVRFUklBTElaRUQgVklFVywgc2V0IHVzZXIgSUQgYmVmb3JlIHJ1bm5pbmcg dXNlciBjb2RlLgoKSXQgaW50ZW5kZWQgdG8sIGJ1dCBkaWQgbm90LCBhY2hpZXZlIHRoaXMuICBB ZG9wdCB0aGUgbmV3IHN0YW5kYXJkIG9mCnNldHRpbmcgdXNlciBJRCBqdXN0IGFmdGVyIGxvY2tp bmcgdGhlIHJlbGF0aW9uLiAgQmFjay1wYXRjaCB0byB2MTAgKGFsbApzdXBwb3J0ZWQgdmVyc2lv bnMpLgoKUmV2aWV3ZWQgYnkgU2ltb24gUmlnZ3MuICBSZXBvcnRlZCBieSBBbHZhcm8gSGVycmVy YS4KClNlY3VyaXR5OiBDVkUtMjAyMi0xNTUyCgpCcmFuY2gKLS0tLS0tClJFTF8xMV9TVEFCTEUK CkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZm LzM0ZmYxNTY2MGI0Zjc1MmUzOTQxZDY2MWMzODk2ZmQ5NmIxNTcxZjkKCk1vZGlmaWVkIEZpbGVz Ci0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL21hdHZpZXcuYyAgICAgICAgICAg fCAzMCArKysrKysrKysrKy0tLS0tLS0tLS0tLS0tLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC9wcml2aWxlZ2VzLm91dCB8IDE2ICsrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVz cy9zcWwvcHJpdmlsZWdlcy5zcWwgICAgICB8IDE3ICsrKysrKysrKysrKysrKysrCjMgZmlsZXMg Y2hhbmdlZCwgNDQgaW5zZXJ0aW9ucygrKSwgMTkgZGVsZXRpb25zKC0pCgo= --===============3422919105245471426==--