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 1xGWVP-00000002R7l-3CgW for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 07:00:59 +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 1xGWVO-0000000CT9l-2bzM for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 07:00:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xGWVO-0000000CT9c-1Dz7 for pgsql-general@lists.postgresql.org; Tue, 13 Oct 2026 07:00:58 +0000 Received: from rex-mailout.bayern.de ([193.34.207.154]) by makus.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xGWVM-00000001l1G-0fAl for pgsql-general@postgresql.org; Tue, 13 Oct 2026 07:00:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1791874856; x=1807426856; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-type:content-transfer-encoding: mime-version; bh=exml7I5wPs+rOaFfhVGIJxg8upr5Az4nG48mX1CmxSk=; b=S/WTENY+K8E67wh3WEkAp5ZPQ+LWz0lUooupiTriQPNnQsT7jt+rbTYF 98qVSTqKU4daCtxPbc8MbFvizIOC81nA+CumP/slt8t/RO9JcwS16Tdlz nyv2SYtWJjzadX/bsYoYOgt+jIQ6VicbiLRP/zcbx43VdEfkV4vPvAw0O iiU9RUXDikdM/8b0ieZ1cb2I6X4MzjBQehRg3BkKwEM2MtckRbwvwfVOG eQ9IjVJdvOCCFo6VrmTTNB9vjT9c6+NxgvRuO/UBV6BCsXYfHzlf9v1FT ndcYdOsK6EthcNppiw+2Qo2SHP6cr8wwEYJXxr2YESrRIk7nHuYjVUVV3 Q==; X-CSE-ConnectionGUID: ElgnCj7ZTaq4Tp+Kr5iCww== X-CSE-MsgGUID: krH13Xk7ROa3Spb3/HKBSg== Received: from unknown (HELO rin140.bayern.de) ([10.197.20.140]) by rex145.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 13 Oct 2026 09:00:52 +0200 X-CSE-ConnectionGUID: +qL3OmQ1T1i4KywtRkTjWA== X-CSE-MsgGUID: dp107MjCTUSTIQm3NadZuA== X-Talos-CUID: =?us-ascii?q?9a23=3AjYIqumsmCZYlRi65RkYDfQ5m6Itma1mG63LpenP?= =?us-ascii?q?hCDpKWaKJc1ys+pxNxp8=3D?= X-Talos-MUID: =?us-ascii?q?9a23=3A1LOadw//F/faV6n0o+UDQGuQf8twuvzxLUImrag?= =?us-ascii?q?9h+i9MHdWMjuvkR3iFw=3D=3D?= X-BYBN-routing: post Received: from zmx-ej4-p25852.max.bayern.de ([10.173.241.201]) by rin140.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 13 Oct 2026 09:00:51 +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, 13 Oct 2026 09:00:50 +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, 13 Oct 2026 09:00:50 +0200 From: =?utf-8?B?RsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKQ==?= To: Christophe Pettus CC: Adrian Klaver , "pgsql-general@postgresql.org" Subject: AW: Why is materialized view creation a "security-restricted operation"? Thread-Topic: Why is materialized view creation a "security-restricted operation"? Thread-Index: AQHdWtrWBmjWtJLbHkKpYGxBvBpwc7b7AA7Q///iagCAACUUAP//4N+AgAAh3TA= Date: Tue, 13 Oct 2026 07:00:50 +0000 Message-ID: <22203074e8c64768bc28133ac928bd9c@stmuk.bayern.de> References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de> <2e9d29c1513afb47d652387ea5299076ef24adce.camel@cybertec.at> <9f30126c-9e72-4ced-83e2-3f8e5da183d3@aklaver.com> <569054683acf4de7a3f2de80391b4e71@stmuk.bayern.de> <81F7B946-997E-496E-BABC-514F9F0E9FFB@thebuild.com> <9b969e375e504257b41fda27f140c165@stmuk.bayern.de> <0FC732AF-86D8-42CB-986A-78D166FE9DA2@thebuild.com> <0656242B-2228-420A-9652-33E21D404BF2@thebuild.com> In-Reply-To: <0656242B-2228-420A-9652-33E21D404BF2@thebuild.com> 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 PiBJdCBkb2Vzbid0IHNlZW0gbXVjaCBtb3JlIHdvcmsgdG8gY3JlYXRlIGEgZm9yZWlnbiB0YWJs ZSB0aGFuIHRvIGNyZWF0ZSBhIHRlbXAgdGFibGUgaW4gYSBQTC9wZ1NRTCBmdW5jdGlvbi4gDQpC ZWNhdXNlIGNvbnRyYXJ5IHRvIGEgZnVuY3Rpb24gYSBmb3JlaWduIHRhYmxlIGlzIG5vdCBwYXJh bWV0cml6YWJsZSwgSSBjbGFpbWVkIEkgd291bGQgaGF2ZSB0byBjcmVhdGUgbXVsdGlwbGUgZm9y ZWlnbiB0YWJsZXMgLSBjb21wYXJlZCB0byBqdXN0IG9uZSBmdW5jdGlvbi4NCg0KQ29uY2Vybmlu ZyB0aGUgRFJZIChkb24ndCByZXBlYXQgeW91cnNlbGYpIHByaW5jaXBsZSwgSSB0aG91Z2h0IGEg ZnVuY3Rpb24gd291bGQgYmUgdGhlIGJldHRlciBjaG9pY2UuDQoNCg0KQXMgSSBzb21ld2hlcmUg c2FpZCwgSSBtaXNzIG1vZHVsYXJpdHkgLyBvcnRob2dvbmFsaXR5IGluIFNRTCAvIFBvc3RncmVz LiBXZSBhbHJlYWR5IG1lbnRpb25lZCBtdWx0aXBsZSBwbGFjZXMgaW4gdGhpcyB0aHJlYWQuIFRo aXMgaXMgdGhlIHJlY3VycmluZyB0aGVtZSBoZXJlLg0KDQoNClJlZ2FyZHMsDQpGcmFuei1Kb3Nl ZiBGw6RyYmVyDQoNCi0tLS0tVXJzcHLDvG5nbGljaGUgTmFjaHJpY2h0LS0tLS0NClZvbjogQ2hy aXN0b3BoZSBQZXR0dXMgPHhvZkB0aGVidWlsZC5jb20+IA0KR2VzZW5kZXQ6IERpZW5zdGFnLCAx My4gT2t0b2JlciAyMDI2IDA4OjU1DQpBbjogRsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKSA8 RnJhbnotSm9zZWYuRmFlcmJlckBzdG11ay5iYXllcm4uZGU+DQpDYzogQWRyaWFuIEtsYXZlciA8 YWRyaWFuLmtsYXZlckBha2xhdmVyLmNvbT47IHBnc3FsLWdlbmVyYWxAcG9zdGdyZXNxbC5vcmcN CkJldHJlZmY6IFJlOiBXaHkgaXMgbWF0ZXJpYWxpemVkIHZpZXcgY3JlYXRpb24gYSAic2VjdXJp dHktcmVzdHJpY3RlZCBvcGVyYXRpb24iPw0KDQoNCg0KPiBPbiBPY3QgMTIsIDIwMjYsIGF0IDIz OjU0LCBGw6RyYmVyLCBGcmFuei1Kb3NlZiAoU3RNVUspIDxGcmFuei1Kb3NlZi5GYWVyYmVyQHN0 bXVrLmJheWVybi5kZT4gd3JvdGU6DQo+ICogLi4uIHRoZSBQb3N0Z3JlU1FMIENPUFkgLi4uIEZS T00gUFJPR1JBTSBzdGF0ZW1lbnQgY291bGQgYmUgdXNlZCBsaWtlIGEgcXVlcnksIHdpdGhvdXQg aGF2aW5nIHRvIHVzZSBhIHRlbXAgdGFibGUuIER1ZSB0byB0eXBpbmcsIG9uZSB3b3VsZCBoYXZl IHRvIHVzZSBhIEZST00gY2xhdXNlIHdpdGggY29sdW1uIG5hbWVzIGFuZCB0eXBlcyBkZWZpbmVk LCBqdXN0IGxpa2UgdGFibGVmdW5jOiBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1 cnJlbnQvdGFibGVmdW5jLmh0bWwNCj4gKiAuLi4gb3IgdGhlcmUgd291bGQgYmUgc29tZSBjaGFu Y2UgdG8gY3JlYXRlIGEgdGVtcCB0YWJsZSBpbnNpZGUgYSBwbHBnc3FsIGZ1bmN0aW9uIC4uLiB3 aGljaCBpbiB0aGUgZW5kIGlzIHVzZWQgaW4gbXkgdXNlIGNhc2UgaW5zaWRlIGEgbWF0ZXJpYWxp emVkIHZpZXcgLi4uIHdoaWNoIGlzIGZvcmJpZGRlbiBhbmQgd2hpY2ggY2FuIHN0aWxsIGJlIHNl ZW4gaW4gdGhlIHN1YmplY3Qgb2YgdGhpcyBtYWlsIGFzIHRoZSBmaXJzdCBxdWVzdGlvbiBJIGhh ZC4NCg0KSXQgZG9lc24ndCBzZWVtIG11Y2ggbW9yZSB3b3JrIHRvIGNyZWF0ZSBhIGZvcmVpZ24g dGFibGUgdGhhbiB0byBjcmVhdGUgYSB0ZW1wIHRhYmxlIGluIGEgUEwvcGdTUUwgZnVuY3Rpb24u DQo=