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 1xH2vZ-00000002nJK-2OMN for pgsql-general@arkaria.postgresql.org; Wed, 14 Oct 2026 17:38:10 +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 1xH2vY-00000004ViV-2TQO for pgsql-general@arkaria.postgresql.org; Wed, 14 Oct 2026 17:38:08 +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 1xH2vY-00000004ViL-0pxk for pgsql-general@lists.postgresql.org; Wed, 14 Oct 2026 17:38:08 +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 1xH2vV-000000026OJ-1e0R for pgsql-general@postgresql.org; Wed, 14 Oct 2026 17:38:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1791999485; x=1807551485; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-type:content-transfer-encoding: mime-version; bh=psuYEEDoBSBPgQa01ywf+bD5Zijt0ea/+csYvUKwnBQ=; b=UTXUtSLJqTWaznLzZUJ0DB4G7wpDssn4+rmxD2XNDnXd3ASvJI747GPh rKSfE3fiNlYOZeb5YYyzpA+Q2YyQQso7PMCf5gFL4piEj/2WVEEtPqVe1 R2tKSqXGOAicr4Nvb3OEefLQXjlIOWeQbAtkniH6juBTuUr7BUWbjrffM CnxCT69K1tWwO09xfCuZmF76mHm9Cf5pXeAf5B0rh0A0jzekueK1eL9Cm jRnWMEHqsUGaqwfpoXdvfBIBw4IA3e5oXh+vCS2UuU0hEhSb5tj1y1TYJ WnG/ZAMnCGokTKYBTg0w0OAnDZlq0oUSNeJmUD9uh9gcxESK7h1P81XOc A==; X-CSE-ConnectionGUID: 5keROyFbTz6gJcGoQmVTcw== X-CSE-MsgGUID: XSlk9ICzSE+f8Q8DERn3xg== Received: from unknown (HELO rin131.bayern.de) ([10.197.20.131]) by rex143.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 14 Oct 2026 19:38:04 +0200 X-CSE-ConnectionGUID: JfcXZGNjQZuEtgmu3wcuTQ== X-CSE-MsgGUID: HX+7c0t8SqehNUIRKJJuLQ== X-Talos-CUID: =?us-ascii?q?9a23=3AfAerQ2lSn/Oji0Vh+YXpBJ/csXzXOV/Tx0fiDGm?= =?us-ascii?q?6MFR0ZaGaTELL56h5r/M7zg=3D=3D?= X-Talos-MUID: 9a23:C3horwpgEZWX8n30UmgezxFSd5hju7j+M1kAkbM7mvOnFw5tHw7I2Q== X-BYBN-routing: post Received: from zmx-ej2-p25850.max.bayern.de ([10.173.241.200]) by rin131.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 14 Oct 2026 19:38:03 +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; Wed, 14 Oct 2026 19:38:03 +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; Wed, 14 Oct 2026 19:38:03 +0200 From: =?utf-8?B?RsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKQ==?= To: Rob Sargent CC: "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: AQHdWyiwjHrx25nTOkCAwjCsNthhirb9Ttaw Date: Wed, 14 Oct 2026 17:38:03 +0000 Message-ID: <42c29de0b9ed4fa89159a3ed8831ff54@stmuk.bayern.de> References: <3b50a3393fd84d56b40cfddd67c98dbc@stmuk.bayern.de> <9B7D623E-1DEF-46DC-92B3-FF9452624F5C@gmail.com> In-Reply-To: <9B7D623E-1DEF-46DC-92B3-FF9452624F5C@gmail.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 WWVzLCBJIHdvdWxkIGhhdmUgdG8gcHJlZGVmaW5lIHRoZSBjb2x1bW5zLg0KSW4gbXkgY2FzZSBp dCdzIGp1c3Qgb25lIGNvbHVtbiwgb25lIHJvdywgd2hpY2ggaSB3YW50ZWQgdG8gbG9hZCBmcm9t IGFuIGV4dGVybmFsIGZpbGUuDQoNCg0KUmVnYXJkcywNCkZyYW56LUpvc2VmIEbDpHJiZXINCg0K LS0tLS1VcnNwcsO8bmdsaWNoZSBOYWNocmljaHQtLS0tLQ0KVm9uOiBSb2IgU2FyZ2VudCA8cm9i anNhcmdlbnRAZ21haWwuY29tPiANCkdlc2VuZGV0OiBEaWVuc3RhZywgMTMuIE9rdG9iZXIgMjAy NiAxNzozNw0KQW46IEbDpHJiZXIsIEZyYW56LUpvc2VmIChTdE1VSykgPEZyYW56LUpvc2VmLkZh ZXJiZXJAc3RtdWsuYmF5ZXJuLmRlPg0KQ2M6IExhdXJlbnogQWxiZSA8bGF1cmVuei5hbGJlQGN5 YmVydGVjLmF0PjsgQWRyaWFuIEtsYXZlciA8YWRyaWFuLmtsYXZlckBha2xhdmVyLmNvbT47IHBn c3FsLWdlbmVyYWxAcG9zdGdyZXNxbC5vcmc7IEhhdXB0LCBNYXR0aGlhcyAoU3RNVUspIDxNYXR0 aGlhcy5IYXVwdEBzdG11ay5iYXllcm4uZGU+DQpCZXRyZWZmOiBSZTogV2h5IGlzIG1hdGVyaWFs aXplZCB2aWV3IGNyZWF0aW9uIGEgInNlY3VyaXR5LXJlc3RyaWN0ZWQgb3BlcmF0aW9uIj8NCg0K DQoNCj4gT24gT2N0IDEzLCAyMDI2LCBhdCAwODoxNywgRsOkcmJlciwgRnJhbnotSm9zZWYgKFN0 TVVLKSA8RnJhbnotSm9zZWYuRmFlcmJlckBzdG11ay5iYXllcm4uZGU+IHdyb3RlOg0KPiANCj4g 77u/DQo+PiANCj4+IFdlbGwsIHlvdSB3YW50IHRvIHVzZSBhIG1hdGVyaWFsaXplZCB2aWV3IGZv ciBzb21ldGhpbmcgdGhhdCBpdCBjYW5ub3QgYmUgdXNlZCBmb3IsIGZvciBzZWN1cml0eSByZWFz b25zLiAgV2UgdHJpZWQgdG8gZXhwbGFpbiB0aGF0IGluIHRoaXMgdGhyZWFkLg0KPiBZZXMsIHlv dSBjYW4gc2VlIGl0IHRoaXMgd2F5OiBPbmUgd2F5IHdvdWxkIGJlOiBVc2luZyBUZW1wIFRhYmxl cy4gVGhpcyB3YXkgaXMgYmxvY2tlZCBkdWUgdG8gc2VjdXJpdHkgcmVhc29ucy4gRGlzY3Vzc2lv biBmaW5pc2hlZC4NCj4gDQo+IEFub3RoZXIgcG9pbnQgb2YgdmlldyBpczoNCj4gMCkgVGhlIHNl Y3VyaXR5IHByb2JsZW0gaXMgbm90IGluaGVyZW50IGZvciB3aGF0IEkgd2FzIHRyeWluZyB0byBh cmNoaWV2ZTsgYnV0IGR1ZSB0byBsYWNrIG9mIGV4cHJlc3NpdmVuZXNzIG9uZSBpcyBmb3JjZWQg aW50byB0aGlzIGRlYWQgZW5kLg0KPiAxKSBFaXRoZXI6IFBvc3RncmVzJyBDT1BZIHN0bXQgbGFj a3MgdGhlIGFiaWxpdHkgdG8gb21pdCB0aGUgcGh5c2ljYWwgdGFibGUsIHNvbWV0aGluZyBsaWtl IFNFTEVDVCAqIEZST00gQ09QWSBGUk9NIC4uLg0KPiAyKSBvcjogUG9zdGdyZXMgbGFja3MgdGFi bGUgdmFyaWFibGVzLg0KPiANCg0KSSBhbSBub3QgY2xlYXIgb24geW91ciB3b3JrZmxvdyBzbyB0 aGVzZSBxdWVzdGlvbnMgY29tZSB0byBtaW5kOg0KV2hhdCBkbyB5b3UgZG8gd2l0aCB0aGUgdW5k ZWZpbmVkIOKAnCrigJ0gKGlmIGl0IHdlcmUgYWxsb3dlZCk/ICANCldvdWxkIHlvdSBub3QgaGF2 ZSB0byBwcmVkZWZpbmUgdGhlIGNvbHVtbnMgb2YgdGhlIHRhYmxlIHZhcmlhYmxlPw0K