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 1xGVv6-00000002QVy-3nj8 for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 06:23:28 +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 1xGVv5-0000000CJDG-2gmN for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 06:23:27 +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 1xGVv5-0000000CJD5-1FQL for pgsql-general@lists.postgresql.org; Tue, 13 Oct 2026 06:23:27 +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 1xGVv2-00000001pCM-2Ik5 for pgsql-general@postgresql.org; Tue, 13 Oct 2026 06:23:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1791872604; x=1807424604; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-type:content-transfer-encoding: mime-version; bh=IjOzp+2cwV9A4GWvnvNBPpCb9jtr/n/o9v1Rd9PB65I=; b=EHiV3GPANuS7Uo+HRJo8JppW0CEpQLnnDPvuiw+xjnjOyqJ+wGc70WS0 gGNncasrsAgz8DaB2+vz/3bRyWuxqFtyLgTRdDml6J6SqvxANYLspk1g5 hYiQ05kAn7PXOu1lFVVywmhLjo4oGw90Zir+X+8q9qMxWrlMmdVVRzvVG OA4C8wwnQSYRNEI/115B/J8o4ItNnJwwLCQPZfSzpPfXjjZiTppZJBdz2 FaZqE3lhSYDcTrqInqUX2E4B8XHVK6P9wiB4TrozC18qN1ZNtsBcX8L31 A/pgqoS2WIwVmcTNgwe/nxWWsE0goc5qdcD70HfSzsyPmFRq+Cobe2hXu A==; X-CSE-ConnectionGUID: ktWE8oWwRw6tRgi/JNIaMQ== X-CSE-MsgGUID: LZfnL/+qR4aLTJlibfSRTQ== Received: from unknown (HELO rin138.bayern.de) ([10.197.20.138]) by rex143.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 13 Oct 2026 08:23:23 +0200 X-CSE-ConnectionGUID: KiMz2g7SRzOVJfBQtT0zrQ== X-CSE-MsgGUID: Lcp88VYRRzeBrKt1wFzU3w== X-Talos-CUID: =?us-ascii?q?9a23=3AbwiL92t4wHetNXGkSgILPyl56IsGc1jPlniPGHW?= =?us-ascii?q?qLlhLRpesVWPI6rldxp8=3D?= X-Talos-MUID: 9a23:dRHBjQtONAIkOXdvvs2noDp6ZJdW0p6UGk0ni7Ya4taqJxErJGLI X-BYBN-routing: post Received: from zmx-ej2-p25850.max.bayern.de ([10.173.241.200]) by rin138.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 13 Oct 2026 08:23:23 +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 Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.2562.49; Tue, 13 Oct 2026 08:23:22 +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 08:23:22 +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 Date: Tue, 13 Oct 2026 06:23:22 +0000 Message-ID: <9b969e375e504257b41fda27f140c165@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> In-Reply-To: <81F7B946-997E-496E-BABC-514F9F0E9FFB@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 WWVzLCBUaGFuayB5b3UuIEkgbWVudGlvbmVkIHRoYXQgaGVyZSwgd2l0aCBpdHMgZGlzYWR2YW50 YWdlOiBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL2Y2OWI0N2RiYmUzNzRi YWM4MDg4ODg3YzIxMTkzZjI2JTQwc3RtdWsuYmF5ZXJuLmRlIDoNCg0KPiBXaGF0IEkgQ09VTEQg ZG8gaXMgcmVwbGFjZSBDT1BZIHggLi4uIEZST00gUFJPR1JBTSB3aXRoIGEgZmlsZV9mZHcgRk9S RUlHTiBUQUJMRSwgYnV0IHRoaXMgd2F5IGl0IGlzbid0IHBhcmFtZXRyaXphYmxlLiBJIHdvdWxk IGhhdmUgdG8gY3JlYXRlIGFzIG1hbnkgZm9yZWlnbiB0YWJsZXMgYXMgSSBoYXZlIHBhc3N3b3Jk cyAvIGVudmlyb25tZW50IHZhcmlhYmxlcywgSSB0aGluay4NCg0KDQpSZWdhcmRzLA0KRnJhbnot Sm9zZWYgRsOkcmJlcg0KDQotLS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodC0tLS0tDQpWb246 IENocmlzdG9waGUgUGV0dHVzIDx4b2ZAdGhlYnVpbGQuY29tPiANCkdlc2VuZGV0OiBEaWVuc3Rh ZywgMTMuIE9rdG9iZXIgMjAyNiAwODoxOQ0KQW46IEbDpHJiZXIsIEZyYW56LUpvc2VmIChTdE1V SykgPEZyYW56LUpvc2VmLkZhZXJiZXJAc3RtdWsuYmF5ZXJuLmRlPg0KQ2M6IEFkcmlhbiBLbGF2 ZXIgPGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+OyBwZ3NxbC1nZW5lcmFsQHBvc3RncmVzcWwu b3JnDQpCZXRyZWZmOiBSZTogV2h5IGlzIG1hdGVyaWFsaXplZCB2aWV3IGNyZWF0aW9uIGEgInNl Y3VyaXR5LXJlc3RyaWN0ZWQgb3BlcmF0aW9uIj8NCg0KSGksDQoNCj4gT24gT2N0IDEyLCAyMDI2 LCBhdCAyMzoxMiwgRsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKSA8RnJhbnotSm9zZWYuRmFl cmJlckBzdG11ay5iYXllcm4uZGU+IHdyb3RlOg0KPiANCj4gVGhhbmtzIGZvciB0aGUgc3VnZ2Vz dGlvbi4NCj4gQnV0IHdoYXQgZXhhY3RseSBpcyB0aGUgc3VnZ2VzdGlvbj8NCj4gDQo+IEF0IGxl YXN0IEkgdW5kZXJzdGFuZCBEdWNrREIgY2FuIGRpcmVjdGx5IHJlYWQgd2l0aG91dCBoYXZpbmcg dG8gY3JhZXRlIGEgdGVtcCB0YWJsZToNCj4gKiBTRUxFQ1QgKiBGUk9NICd0ZXN0LmNzdi5neic7 DQo+ICogU0VMRUNUICogRlJPTSByZWFkX2NzdigndGVzdC5jc3YnLCBoZWFkZXIgPSBmYWxzZSk7 DQo+IA0KPiAuLi4gd2hpY2ggaXMgd2hhdCBQb3N0Z3JlcyBpcyBtaXNzaW5nLg0KDQpQb3N0Z3Jl U1FMIGltcGxlbWVudHMgdGhpcyB1c2luZyBmb3JlaWduIGRhdGEgd3JhcHBlcnMuDQo=