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.98.2) (envelope-from ) id 1xE0PR-00000000rfO-1eUu for pgsql-general@arkaria.postgresql.org; Tue, 06 Oct 2026 08:20:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xE0PO-0000000G7rw-2n6u for pgsql-general@arkaria.postgresql.org; Tue, 06 Oct 2026 08:20:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xE0PO-0000000G7rn-1BnH for pgsql-general@lists.postgresql.org; Tue, 06 Oct 2026 08:20:22 +0000 Received: from rex-mailout.bayern.de ([193.34.207.154]) by magus.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xE0PL-00000000gE5-2QsB for pgsql-general@postgresql.org; Tue, 06 Oct 2026 08:20:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1791274819; x=1806826819; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-type:content-transfer-encoding: mime-version; bh=5KYMB7R70PHwTQbyHqcZYj5CbAq1j6PjAj+lDwhNsf0=; b=f348VBXuBCmR2s8pORcK2gcLUuYiJ0DldHyDkEzKYFkbw4C1zt4do2f/ DXKFvMn8ZNa7OJtW8ae5cICo2Z9qddhYVLESP9aivnAeQEOJqcauOI2kV l6hjME5/V6vWVW4VwSCmLfuI4z9InrVuvQKJJ3y3zC+sxoeiOq8F5yf0N o+0kV9OFnzc9Ob26DiZrfzeS+yUgRHnTHGvwPYPo8gnsVnt2uqZK8wNPV ktRNxst2V4zPjDcX7n8/u/W0AbZegFePCpHJ7D7WgLkv//rcmR4coesqE gYdTNWes57VqWQC5ai6KDpk6sSS1raUcE67LCo+MDEKaqNACHtCxC1HDU w==; X-CSE-ConnectionGUID: 90i9Y3f2Qm6Nh5YUFDHugQ== X-CSE-MsgGUID: Pw2DMF3LRvShKHu6IhSPvg== Received: from unknown (HELO rin130.bayern.de) ([10.197.20.130]) by rex144.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 06 Oct 2026 10:20:16 +0200 X-CSE-ConnectionGUID: xA3fR3+xQvaw5KSrXTi1RQ== X-CSE-MsgGUID: /d5mMHVZS2mTaFAfcS/ktA== X-Talos-CUID: =?us-ascii?q?9a23=3ACmUpJmhTFbhnwXTharROLfpuJTJuYlSGwk2LYF+?= =?us-ascii?q?BF292FZ6uU2+s+fpeqp87?= X-Talos-MUID: 9a23:Hn3vkgimlAcj/29BKXBCKsMpc8s15oGONnI2y5A6suetOydLfDSBpWHi X-BYBN-routing: post Received: from zmx-ej4-p25852.max.bayern.de ([10.173.241.201]) by rin130.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 06 Oct 2026 10:20:15 +0200 Received: from ZMX-EJ2-P25850.max.bayern.de (10.173.241.200) by ZMX-EJ4-P25852.max.bayern.de (10.173.241.201) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.2562.49; Tue, 6 Oct 2026 10:20:15 +0200 Received: from ZMX-EJ2-P25850.max.bayern.de ([10.173.241.200]) by ZMX-EJ2-P25850.max.bayern.de ([10.173.241.200]) with mapi id 15.02.2562.049; Tue, 6 Oct 2026 10:20:15 +0200 From: =?utf-8?B?RsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKQ==?= To: "pgsql-general@postgresql.org" CC: Adrian Klaver Subject: AW: Why is materialized view creation a "security-restricted operation"? Thread-Topic: Why is materialized view creation a "security-restricted operation"? Thread-Index: AQHdUbjGKIaZcMDRsEqMMqUV4cU0L7bpO88AgAAK2QCAAKNYAIAATOOAgAX7wVA= Date: Tue, 6 Oct 2026 08:20:14 +0000 Message-ID: <886a7a1fb54a4abdbb89897a6854edd7@stmuk.bayern.de> References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de> <61488cb9-5b84-449a-9886-e0d3b9671aa6@aklaver.com> In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.171.65.1] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk QXJlIHlvdSBzdXJlIHRoZSBleHRlbnNpb24gcGd0dCB3b3VsZCB3b3JrIGluIG15IGNhc2U/DQoN Cmh0dHBzOi8vZ2l0aHViLmNvbS9kYXJvbGQvcGd0dCNob3ctdGhlLWV4dGVuc2lvbi1yZWFsbHkt d29ya3Mgc2F5czoNCg0KInRoZSBmaXJzdCBhY2Nlc3MgdG8gdGhlIHRhYmxlIHVzaW5nIGEgU0VM RUNULCBVUERBVEUgb3IgREVMRVRFIHN0YXRlbWVudCB3aWxsIHByb2R1Y2UgdGhlIGNyZWF0aW9u IG9mIGEgdGVtcG9yYXJ5IHRhYmxlIg0KDQpXZWxsLCBteSBvcmlnaW5hbCBwb2ludCB3YXM6IENy ZWF0aW9uIG9mIGEgdGVtcG9yYXJ5IHRhYmxlIGlzIHByb2hpYml0ZWQgZHVlIHRvICJzZWN1cml0 eS1yZXN0cmljdGVkIG9wZXJhdGlvbiIuDQoNCg0KUmVnYXJkcywNCkZyYW56LUpvc2VmIEbDpHJi ZXINCg0KDQotLS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodC0tLS0tDQpWb246IEFkcmlhbiBL bGF2ZXIgPGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+IA0KR2VzZW5kZXQ6IEZyZWl0YWcsIDIu IE9rdG9iZXIgMjAyNiAxNjo1NQ0KQW46IFJvbiBKb2huc29uIDxyb25sam9obnNvbmpyQGdtYWls LmNvbT47IHBnc3FsLWdlbmVyYWwgPHBnc3FsLWdlbmVyYWxAcG9zdGdyZXNxbC5vcmc+DQpCZXRy ZWZmOiBSZTogV2h5IGlzIG1hdGVyaWFsaXplZCB2aWV3IGNyZWF0aW9uIGEgInNlY3VyaXR5LXJl c3RyaWN0ZWQgb3BlcmF0aW9uIj8NCg0KT24gMTAvMi8yNiAzOjE5IEFNLCBSb24gSm9obnNvbiB3 cm90ZToNCj4gT24gVGh1LCBPY3QgMSwgMjAyNiBhdCA4OjM14oCvUE0gRGF2aWQgRy4gSm9obnN0 b24gDQo+IDxkYXZpZC5nLmpvaG5zdG9uQGdtYWlsLmNvbSA8bWFpbHRvOmRhdmlkLmcuam9obnN0 b25AZ21haWwuY29tPj4gd3JvdGU6DQo+IA0KPiAgICAgT24gVGh1LCBPY3QgMSwgMjAyNiBhdCA0 OjU24oCvUE0gUm9uIEpvaG5zb24gPHJvbmxqb2huc29uanJAZ21haWwuY29tDQo+ICAgICA8bWFp bHRvOnJvbmxqb2huc29uanJAZ21haWwuY29tPj4gd3JvdGU6DQo+IA0KPiAgICAgICAgIEEgR0xP QkFMIFRFTVAgdGFibGUgKHdoZXJlIHRoZSBEQkEgcnVucyB0aGUgQ1JFQVRFIEdMT0JBTCBURU1Q DQo+ICAgICAgICAgVEFCTEUgb25jZSAoc28gdGhhdCBDUkVBVEUgVEVNUCBUQUJMRSBzb21lX3Rh YmxlwqAgZXZlcnl3aGVyZQ0KPiAgICAgICAgIHRoYXQgbXlfZnVuYygpIGlzIGNhbGxlZCkgd291 bGQgYWxzbyBzb2x2ZSBPUCdzIHByb2JsZW0uDQo+IA0KPiANCj4gICAgIFBlciB0aGUgY3JlYXRl IHRhYmxlIGRvY3M6DQo+IA0KPiAgICAgIk9wdGlvbmFsbHksIEdMT0JBTCBvciBMT0NBTCBjYW4g YmUgd3JpdHRlbiBiZWZvcmUgVEVNUE9SQVJZIG9yDQo+ICAgICBURU1QLiBUaGlzIHByZXNlbnRs eSBtYWtlcyBubyBkaWZmZXJlbmNlIGluIFBvc3RncmVTUUwgYW5kIGlzDQo+ICAgICBkZXByZWNh dGVkOyBzZWUgQ29tcGF0aWJpbGl0eSBiZWxvdy4iDQo+IA0KPiBBbmQgSSdtIHByYXlpbmcgZm9y ICJzaW5jZSBmdXR1cmUgdmVyc2lvbnMgb2YgUG9zdGdyZVNRTG1pZ2h0IGFkb3B0IGEgDQo+IG1v cmUgc3RhbmRhcmQtY29tcGxpYW50IGludGVycHJldGF0aW9uIG9mIHRoZWlyIG1lYW5pbmciIGlu IHRoZSANCj4gQ29tcGF0aWJpbGl0ecKgc2VjdGlvbiB5b3UgcmVmZXJlbmNlZC4NCg0KQXMgYW4g ZXh0ZW5zaW9uIHRoZXJlIGlzOg0KDQpodHRwczovL2dpdGh1Yi5jb20vZGFyb2xkL3BndHQNCg0K PiANCj4gLS0NCj4gRGVhdGggdG8gPFJlZGFjdGVkPiwgYW5kIGJ1dHRlciBzYXVjZS4NCj4gRG9u J3QgYm9pbCBtZSwgSSdtIHN0aWxsIGFsaXZlLg0KPiA8UmVkYWN0ZWQ+IGxvYnN0ZXIhDQoNCg0K LS0gDQpBZHJpYW4gS2xhdmVyDQphZHJpYW4ua2xhdmVyQGFrbGF2ZXIuY29tDQoNCg0K