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 1xGdJv-00000002Wrk-01Rb for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 14:17:36 +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 1xGdJt-0000000ESl5-3ANd for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 14:17:33 +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 1xGdJt-0000000ESkw-15Zo for pgsql-general@lists.postgresql.org; Tue, 13 Oct 2026 14:17:33 +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 1xGdJp-00000001oXy-1b1X for pgsql-general@postgresql.org; Tue, 13 Oct 2026 14:17:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1791901049; x=1807453049; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-type:content-transfer-encoding: mime-version; bh=MqVCiImeBZNKLJuRE7GNrI4hhryVLA4At3qUCMwZ41o=; b=kKhPGdfqWmKTd25ZO+K/rMd8N/tcCYhri/C8aTxb2HV4j6Pejt4Sw1MN hKG80tRgvb1zvBFjpl/S95h3JJ2KnFVDXMoknb4xoJfsxtRskriQtRbg9 fCqmVCbQzLo/M+EdEBHaFcNHqhqNIbA+dNIffTYUTlOKmGnE8KeF9gg/9 is5HTcxxT4J2uQlTK64xzbuFesTgkz961Ze4BLVNlfFRZVfNUQxnGufEh zBmcRTPElhMsz4tS+04CP543i1IQUZgnyEZ2LBrluGpY3LiUP2BTAwqT9 e9Ltqd4j20rsLYmM/BmoZViAwor7NlcmwXKKEbRc4tOErnSrTxsKkju9q A==; X-CSE-ConnectionGUID: UVcAdLoFS1yvGTOTG/Sp3w== X-CSE-MsgGUID: o8OObGo2R4yT10CRzaLOpA== Received: from unknown (HELO rin139.bayern.de) ([10.197.20.139]) by rex137.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 13 Oct 2026 16:17:26 +0200 X-CSE-ConnectionGUID: kjYjPSrcQbK6tkPvWEDygA== X-CSE-MsgGUID: W0sVJFANQtO4c2CwVHpyqg== X-Talos-CUID: =?us-ascii?q?9a23=3AMg6S8WkLND5QJ4JxSITHvNFoJKPXOX7f/XXoGFW?= =?us-ascii?q?zMGxKFqGWcUGv1Y91nOM7zg=3D=3D?= X-Talos-MUID: =?us-ascii?q?9a23=3A9Bu0Xg9z9pvT08CBApB+OyKQf/gw+JqMJmkrqIk?= =?us-ascii?q?h58LeHjNOGy+MlTviFw=3D=3D?= X-BYBN-routing: post Received: from zmx-ed1-p24372.max.bayern.de ([10.173.241.233]) by rin139.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 13 Oct 2026 16:17:25 +0200 Received: from ZMX-EJ2-P25850.max.bayern.de (10.173.241.200) by ZMX-ED1-P24372.max.bayern.de (10.173.241.233) 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 16:17:25 +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 16:17:25 +0200 From: =?utf-8?B?RsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKQ==?= To: Laurenz Albe , Adrian Klaver , "pgsql-general@postgresql.org" CC: "Haupt, Matthias (StMUK)" Subject: AW: AW: Why is materialized view creation a "security-restricted operation"? Thread-Topic: AW: Why is materialized view creation a "security-restricted operation"? Thread-Index: AQHdUeFL0Utg7jYUl0GDhsYiKoFwtrb5rX5QgAGS4oCAACfpcIAABUEAgAAkV6A= Date: Tue, 13 Oct 2026 14:17:25 +0000 Message-ID: <3b50a3393fd84d56b40cfddd67c98dbc@stmuk.bayern.de> References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de> <2e9d29c1513afb47d652387ea5299076ef24adce.camel@cybertec.at> <4d7467aa0ee958343fca8c6bd6720952b5bc08b1.camel@cybertec.at> <5628a96712e14b9fac594b34b0eb9161@stmuk.bayern.de> 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 PldlbGwsIHlvdSB3YW50IHRvIHVzZSBhIG1hdGVyaWFsaXplZCB2aWV3IGZvciBzb21ldGhpbmcg dGhhdCBpdCBjYW5ub3QgYmUgdXNlZCBmb3IsIGZvciBzZWN1cml0eSByZWFzb25zLiAgV2UgdHJp ZWQgdG8gZXhwbGFpbiB0aGF0IGluIHRoaXMgdGhyZWFkLg0KWWVzLCB5b3UgY2FuIHNlZSBpdCB0 aGlzIHdheTogT25lIHdheSB3b3VsZCBiZTogVXNpbmcgVGVtcCBUYWJsZXMuIFRoaXMgd2F5IGlz IGJsb2NrZWQgZHVlIHRvIHNlY3VyaXR5IHJlYXNvbnMuIERpc2N1c3Npb24gZmluaXNoZWQuDQoN CkFub3RoZXIgcG9pbnQgb2YgdmlldyBpczoNCjApIFRoZSBzZWN1cml0eSBwcm9ibGVtIGlzIG5v dCBpbmhlcmVudCBmb3Igd2hhdCBJIHdhcyB0cnlpbmcgdG8gYXJjaGlldmU7IGJ1dCBkdWUgdG8g bGFjayBvZiBleHByZXNzaXZlbmVzcyBvbmUgaXMgZm9yY2VkIGludG8gdGhpcyBkZWFkIGVuZC4N CjEpIEVpdGhlcjogUG9zdGdyZXMnIENPUFkgc3RtdCBsYWNrcyB0aGUgYWJpbGl0eSB0byBvbWl0 IHRoZSBwaHlzaWNhbCB0YWJsZSwgc29tZXRoaW5nIGxpa2UgU0VMRUNUICogRlJPTSBDT1BZIEZS T00gLi4uDQoyKSBvcjogUG9zdGdyZXMgbGFja3MgdGFibGUgdmFyaWFibGVzLg0KDQoNCj4gSnVz dCBiZWNhdXNlIHRoZSBmZWF0dXJlcyB5b3UgYXJlIHN0YWNraW5nIGRvbid0IHdvcmsgdGhlIHdh eSB5b3UnZCBsaWtlIHRoZW0gdG8sIGl0J3Mgbm90IGEgc2hvcnRjb21pbmcgb2Ygb3J0aG9nb25h bGl0eSBvciBtb2R1bGFyaXR5Lg0KV2VsbCB0aGlzIGlzIG15IHZlcnkgZGVmaW5pdGlvbiBvZiBv cnRob2dvbmFsaXR5IC8gbW9kdWxhcml0eSwgVGhpcyBpcyB3aGF0IEknbSBvdXQgZm9yOiBMYW5n dWFnZSBmZWF0dXJlcyBzaG91bGQgYmUgZ2VuZXJhbGx5IGNvbWJpbmFibGUsIHdpdGggdmVyeSBm ZXcgbGltaXRzLg0KDQoNCj4gWW91IGNvdWxkIHdyaXRlIGEgcHJvY2VkdXJlIHRoYXQgdHJ1bmNh dGVzIHRoZSB0YWJsZSBhbmQgcG9wdWxhdGVzIGl0IHdpdGggYSBxdWVyeSwgdXNpbmcgYSB0ZW1w b3JhcnkgdGFibGUgaWYgeW91IHdhbnQuICBDYWxsaW5nIHRoYXQgcHJvY2VkdXJlIGlzIGp1c3Qg YXMgY29udmVuaWVudCBhcyBjYWxsaW5nIFJFRlJFU0ggTUFURVJJQUxJWkVEIFZJRVcuDQpZZXMs IHRoYXQncyB3aGF0IEkgbWVhbnQgaW4gbXkgbGFzdCBwb3N0Lg0KQnV0IHRoaXMgbGVhZHMgdG86 IEkgbmVlZCB0byBhZGp1c3QgYWxsIGNhbGxpbmdzIHBvaW50cywgbm90aWZ5IHVzZXJzIG9mIHRo ZSBwcmV2aW91c2x5LU1BVFZJRVcgdG8gYWRqdXN0LCBhbmQgc28gb24uDQoNCj4gQXJlIHlvdSBz ZWFyY2hpbmcgZm9yIGEgdXNhYmxlIHNvbHV0aW9uIGZvciBhIHByb2JsZW0/ICBUaGVuIHRoYXQg c2hvdWxkIGRvLg0KSSBhbSBzZWFyY2hpbmcgZm9yIGJvdGgNCiogQSBzb2x1dGlvbiB0aGF0IGRv ZXMgbm90IGZlZWwgbGlrZSBhIHdvcmthcm91bmQuIChXZWxsIEkgV0lMTCBiZSBhYmxlIHRvIGxp dmUgd2l0aCB0aGUgZnVuY3Rpb24gc29sdXRpb24uIFNvbWVob3cuKQ0KKiBTb21lIGNvbW1vbiBn cm91bmQgdGhhdCB0aGVyZSBpcyBzb21lIGxhY2sgb2YgbW9kdWxhcml0eSAvIG9ydGhvZ29uYWxp dHkgLyBleHByZXNzaXZlbmVzcyBpbiBQb3N0Z3Jlcy4gQWRkcmVzc2luZyB0aGUgcHJvYmxlbSBp cyB0aGUgZmlyc3Qgc3RlcC4NCg0KDQpUaGFuayBZb3UuDQoNCg0KUmVnYXJkcywNCkZyYW56LUpv c2VmIEbDpHJiZXINCg0KLS0tLS1VcnNwcsO8bmdsaWNoZSBOYWNocmljaHQtLS0tLQ0KVm9uOiBM YXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD4gDQpHZXNlbmRldDogRGllbnN0 YWcsIDEzLiBPa3RvYmVyIDIwMjYgMTU6NDgNCkFuOiBGw6RyYmVyLCBGcmFuei1Kb3NlZiAoU3RN VUspIDxGcmFuei1Kb3NlZi5GYWVyYmVyQHN0bXVrLmJheWVybi5kZT47IEFkcmlhbiBLbGF2ZXIg PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+OyBwZ3NxbC1nZW5lcmFsQHBvc3RncmVzcWwub3Jn DQpDYzogSGF1cHQsIE1hdHRoaWFzIChTdE1VSykgPE1hdHRoaWFzLkhhdXB0QHN0bXVrLmJheWVy bi5kZT4NCkJldHJlZmY6IFJlOiBBVzogV2h5IGlzIG1hdGVyaWFsaXplZCB2aWV3IGNyZWF0aW9u IGEgInNlY3VyaXR5LXJlc3RyaWN0ZWQgb3BlcmF0aW9uIj8NCg0KT24gVHVlLCAyMDI2LTEwLTEz IGF0IDExOjM2ICswMDAwLCBGw6RyYmVyLCBGcmFuei1Kb3NlZiAoU3RNVUspIHdyb3RlOg0KPiA+ ID4gW3JhbnQgYWJvdXQgUG9zdGdyZVNRTCBzZWN1cml0eSByZXN0cmljdGlvbnNdDQo+DQo+IE5v IG5vIG5vLCBub3QgYWJvdXQgc2VjdXJpdHkgcmVzdHJpY3Rpb25zLiBUaGUgcmFudCBpcyBhYm91 dCBsYWNraW5nIG9ydGhvZ29uYWxpdHkuDQo+IEFib3V0IG9mdGVuIE5PVCBiZWluZyBhYmxlIHRv IGNvbWJpbmUgbGFuZ3VhZ2UgZmVhdHVyZXMuIERvZXNuJ3QgDQo+IGFueWJvZHkgc2hhcmUgdGhh dCB2aWV3PyBXZSBDT1VMRCBkbyBiZXR0ZXIsIEkgdGhpbmsuDQoNCldlbGwsIHlvdSB3YW50IHRv IHVzZSBhIG1hdGVyaWFsaXplZCB2aWV3IGZvciBzb21ldGhpbmcgdGhhdCBpdCBjYW5ub3QgYmUg dXNlZCBmb3IsIGZvciBzZWN1cml0eSByZWFzb25zLiAgV2UgdHJpZWQgdG8gZXhwbGFpbiB0aGF0 IGluIHRoaXMgdGhyZWFkLg0KDQo+ID4gSWYgdGhlIHNlY3VyaXR5IHJlc3RyaWN0aW9ucyBvZiBt YXRlcmlhbGl6ZWQgdmlld3MgcHJldmVudCB5b3UgZnJvbSANCj4gPiB1c2luZyB0aGVtLCB3aHkg ZG9uJ3QgeW91IHVzZSBhIG5vcm1hbCB0YWJsZSBpbnN0ZWFkLCBUUlVOQ0FURSBpdCBhbmQgSU5T RVJUIGludG8gaXQ/DQo+DQo+IFRoZSBNQVQgVklFVyBpcyB1c2VkIGZyb20gIm91dHNpZGUiLiBG cm9tIG90aGVyIHZpZXdzLCBvciBmcm9tIGEgY2xpZW50IHRoYXQgY29ubmVjdHMgdG8gdGhlIGRh dGFiYXNlLg0KPiANCj4gKiBJIGNhbiByZXBsYWNlIGl0IHdpdGggYSB2aWV3OyBJIGRpZG4ndCBk byB0aGF0IGZvciBwZXJmb3JtYW5jZSByZWFzb25zLg0KPiAqIEkgY2FuIHJlcGxhY2UgaXQgd2l0 aCBhIHBlcnNpc3RlbnQgdGFibGUsIGEgc3RvcmVkIHByb2NlZHVyZSwgYW5kIGN1c3RvbSBjYWNo aW5nDQo+ICAgbG9naWMuIFRoYXQnbGwgd29yay4gQnV0IHRoaXMgaXMgd2hhdCBhIE1BVCBWSUVX IGlzIGZvciwgSSB0aG91Z2h0LiANCg0KWW91IGNvdWxkIHdyaXRlIGEgcHJvY2VkdXJlIHRoYXQg dHJ1bmNhdGVzIHRoZSB0YWJsZSBhbmQgcG9wdWxhdGVzIGl0IHdpdGggYSBxdWVyeSwgdXNpbmcg YSB0ZW1wb3JhcnkgdGFibGUgaWYgeW91IHdhbnQuICBDYWxsaW5nIHRoYXQgcHJvY2VkdXJlIGlz IGp1c3QgYXMgY29udmVuaWVudCBhcyBjYWxsaW5nIFJFRlJFU0ggTUFURVJJQUxJWkVEIFZJRVcu DQoNCkFyZSB5b3Ugc2VhcmNoaW5nIGZvciBhIHVzYWJsZSBzb2x1dGlvbiBmb3IgYSBwcm9ibGVt PyAgVGhlbiB0aGF0IHNob3VsZCBkby4NCg0KWW91cnMsDQpMYXVyZW56IEFsYmUNCg==