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 1xGJQ0-00000002Do8-3Jb3 for pgsql-general@arkaria.postgresql.org; Mon, 12 Oct 2026 17:02:33 +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 1xGJPz-00000009Tsb-1hVW for pgsql-general@arkaria.postgresql.org; Mon, 12 Oct 2026 17:02:31 +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 1xGJPz-00000009TsT-07DK for pgsql-general@lists.postgresql.org; Mon, 12 Oct 2026 17:02:31 +0000 Received: from rex-mailout.bayern.de ([193.34.207.154]) by magus.postgresql.org with utf8esmtp (Exim 4.98.2) (envelope-from ) id 1xGJPw-00000001jNM-2fwQ for pgsql-general@postgresql.org; Mon, 12 Oct 2026 17:02:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1791824548; x=1807376548; h=from:to:subject:date:message-id:references:in-reply-to: content-type:content-transfer-encoding:mime-version; bh=9RU3aDmx66oTWsBj5tcN5SLaPq511W9KL6TZtiplSHU=; b=WeBU2NOQaRFhHJHIPGFDy+GH4kBRsW921l6VeMkJGr64ubwshw8p15gO ybZZwM+O8lwRVXidxwHtNXL9/GKQt/484Sa/zu5wlyLMxtjmKftKHoDu4 yfokTXClL4lEIlDnMjLs0U+U7Fq/yWxFOGwAOFz67fnfX4ftGJZjgrf1m lHTzYaEtzjHvUN1W4Xv/a6oTAquKv+pYW/I3Z8VIyPhzey9bmXTB1rNHn TFgM15ixxc1sIu5XNYcKmi4evF2BvDhjp6L3oG6TBh5SvnRy1sp/qk3Rr D90yikpkjcuRHyblyYtVqrJ0TnVmRGMOVrqomyMMXXyDot995gK8v/c9U Q==; X-CSE-ConnectionGUID: Hy7qP9hCTH6Wut6N2KlxkQ== X-CSE-MsgGUID: s96kVpX3Raiy10Nd89h8LA== Received: from unknown (HELO rin132.bayern.de) ([10.197.20.132]) by rex137.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 12 Oct 2026 16:40:51 +0200 X-CSE-ConnectionGUID: S+stCjClTuyrysYKNquAIg== X-CSE-MsgGUID: gopuuzz+QSa5nkdufPDR4Q== X-Talos-CUID: =?us-ascii?q?9a23=3AZyYJiWrNYQ30FIZ7zegcNuPmUftmaWH2zlzUH1K?= =?us-ascii?q?pE3dyeZ6zUEK52awxxg=3D=3D?= X-Talos-MUID: =?us-ascii?q?9a23=3AIWSDnA8qdCzSBAxtwzcP/BCQf8hv+7mzGlJOqK4?= =?us-ascii?q?P5s+HOTF+Axun0A3iFw=3D=3D?= X-BYBN-routing: post Received: from zmx-ej2-p25850.max.bayern.de ([10.173.241.200]) by rin132.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 12 Oct 2026 16:40:51 +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; Mon, 12 Oct 2026 16:40:51 +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; Mon, 12 Oct 2026 16:40:51 +0200 From: =?utf-8?B?RsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKQ==?= To: Adrian Klaver , "pgsql-general@postgresql.org" 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: AQHdUbjGKIaZcMDRsEqMMqUV4cU0L7bpO88AgAAK2QCAAKNYAIAATOOAgAX7wVCAAL5OAIAJGsiw Date: Mon, 12 Oct 2026 14:40:51 +0000 Message-ID: References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de> <61488cb9-5b84-449a-9886-e0d3b9671aa6@aklaver.com> <886a7a1fb54a4abdbb89897a6854edd7@stmuk.bayern.de> <0f484041-00b6-454b-9def-e14a955d7c69@aklaver.com> In-Reply-To: <0f484041-00b6-454b-9def-e14a955d7c69@aklaver.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 VGhhbmtzIGZvciB0cnlpbmcgdGhhdCBvdXQuDQpXZWxsLCBmYWlsZWQsIGFzIEkgZXhwZWN0ZWQu DQoNCg0KUmVnYXJkcywNCkZyYW56LUpvc2VmIEbDpHJiZXINCg0KLS0tLS1VcnNwcsO8bmdsaWNo ZSBOYWNocmljaHQtLS0tLQ0KVm9uOiBBZHJpYW4gS2xhdmVyIDxhZHJpYW4ua2xhdmVyQGFrbGF2 ZXIuY29tPiANCkdlc2VuZGV0OiBEaWVuc3RhZywgNi4gT2t0b2JlciAyMDI2IDIzOjM4DQpBbjog RsOkcmJlciwgRnJhbnotSm9zZWYgKFN0TVVLKSA8RnJhbnotSm9zZWYuRmFlcmJlckBzdG11ay5i YXllcm4uZGU+OyBwZ3NxbC1nZW5lcmFsQHBvc3RncmVzcWwub3JnDQpCZXRyZWZmOiBSZTogQVc6 IFdoeSBpcyBtYXRlcmlhbGl6ZWQgdmlldyBjcmVhdGlvbiBhICJzZWN1cml0eS1yZXN0cmljdGVk IG9wZXJhdGlvbiI/DQoNCg0KDQpPbiAxMC82LzI2IDE6MjAgQU0sIEbDpHJiZXIsIEZyYW56LUpv c2VmIChTdE1VSykgd3JvdGU6DQo+IEFyZSB5b3Ugc3VyZSB0aGUgZXh0ZW5zaW9uIHBndHQgd291 bGQgd29yayBpbiBteSBjYXNlPw0KPiANCj4gaHR0cHM6Ly9naXRodWIuY29tL2Rhcm9sZC9wZ3R0 I2hvdy10aGUtZXh0ZW5zaW9uLXJlYWxseS13b3JrcyBzYXlzOg0KPiANCj4gInRoZSBmaXJzdCBh Y2Nlc3MgdG8gdGhlIHRhYmxlIHVzaW5nIGEgU0VMRUNULCBVUERBVEUgb3IgREVMRVRFIHN0YXRl bWVudCB3aWxsIHByb2R1Y2UgdGhlIGNyZWF0aW9uIG9mIGEgdGVtcG9yYXJ5IHRhYmxlIg0KPiAN Cj4gV2VsbCwgbXkgb3JpZ2luYWwgcG9pbnQgd2FzOiBDcmVhdGlvbiBvZiBhIHRlbXBvcmFyeSB0 YWJsZSBpcyBwcm9oaWJpdGVkIGR1ZSB0byAic2VjdXJpdHktcmVzdHJpY3RlZCBvcGVyYXRpb24i Lg0KDQpJIHRyaWVkIHlvdXIgTUFURVJJQUxJWkVEIFZJRVcgd2l0aCBwZ3R0IGFuZCByYW4gaW50 byB0aGUgdGVtcG9yYXJ5IHRhYmxlIGlzc3VlLiBJIHRyaWVkIGFsc28gYWdhaW5zdCB0aGUgJ3Rl bXBsYXRlJyB0YWJsZSBiZWhpbmQgdGhlIHRlbXBvcmFyeSB0YWJsZXMgYW5kIGdvdCBhIGxpdHRs ZSBmdXJ0aGVyIGJ1dCB0aGUgYmVoYXZpb3Igd2FzIHVuc3RhYmxlLiANCkkgc3VzcGVjdCBhIGJ1 ZyB0aGF0IGFsbG93ZWQgbWUgdG8gZ2V0IHRoYXQgZmFyLg0KDQoNClF1ZXN0aW9uczoNCg0KMSkg V2h5IHRoZSBNQVRFUklBTElaRUQgVklFVz8NCg0KMikgQ2FuIHlvdSBwcm92aWRlIGFuIG92ZXJ2 aWV3IGluIHBzZXVkbyBjb2RlLCBpbmNsdWRpbmcgdGhlIHBhcnQgaW4gdGhlIGZ1bmN0aW9uLCBv ZiB0aGUgcHJvY2VzcyB5b3UgYXJlIHRyeWluZyBjcmVhdGU/DQoNCj4gDQo+IA0KPiBSZWdhcmRz LA0KPiBGcmFuei1Kb3NlZiBGw6RyYmVyDQo+IA0KPiANCj4gLS0tLS1VcnNwcsO8bmdsaWNoZSBO YWNocmljaHQtLS0tLQ0KPiBWb246IEFkcmlhbiBLbGF2ZXIgPGFkcmlhbi5rbGF2ZXJAYWtsYXZl ci5jb20+DQo+IEdlc2VuZGV0OiBGcmVpdGFnLCAyLiBPa3RvYmVyIDIwMjYgMTY6NTUNCj4gQW46 IFJvbiBKb2huc29uIDxyb25sam9obnNvbmpyQGdtYWlsLmNvbT47IHBnc3FsLWdlbmVyYWwgDQo+ IDxwZ3NxbC1nZW5lcmFsQHBvc3RncmVzcWwub3JnPg0KPiBCZXRyZWZmOiBSZTogV2h5IGlzIG1h dGVyaWFsaXplZCB2aWV3IGNyZWF0aW9uIGEgInNlY3VyaXR5LXJlc3RyaWN0ZWQgb3BlcmF0aW9u Ij8NCj4gDQo+IE9uIDEwLzIvMjYgMzoxOSBBTSwgUm9uIEpvaG5zb24gd3JvdGU6DQo+PiBPbiBU aHUsIE9jdCAxLCAyMDI2IGF0IDg6MzXigK9QTSBEYXZpZCBHLiBKb2huc3RvbiANCj4+IDxkYXZp ZC5nLmpvaG5zdG9uQGdtYWlsLmNvbSA8bWFpbHRvOmRhdmlkLmcuam9obnN0b25AZ21haWwuY29t Pj4gd3JvdGU6DQo+Pg0KPj4gICAgICBPbiBUaHUsIE9jdCAxLCAyMDI2IGF0IDQ6NTbigK9QTSBS b24gSm9obnNvbiA8cm9ubGpvaG5zb25qckBnbWFpbC5jb20NCj4+ICAgICAgPG1haWx0bzpyb25s am9obnNvbmpyQGdtYWlsLmNvbT4+IHdyb3RlOg0KPj4NCj4+ICAgICAgICAgIEEgR0xPQkFMIFRF TVAgdGFibGUgKHdoZXJlIHRoZSBEQkEgcnVucyB0aGUgQ1JFQVRFIEdMT0JBTCBURU1QDQo+PiAg ICAgICAgICBUQUJMRSBvbmNlIChzbyB0aGF0IENSRUFURSBURU1QIFRBQkxFIHNvbWVfdGFibGXC oCBldmVyeXdoZXJlDQo+PiAgICAgICAgICB0aGF0IG15X2Z1bmMoKSBpcyBjYWxsZWQpIHdvdWxk IGFsc28gc29sdmUgT1AncyBwcm9ibGVtLg0KPj4NCj4+DQo+PiAgICAgIFBlciB0aGUgY3JlYXRl IHRhYmxlIGRvY3M6DQo+Pg0KPj4gICAgICAiT3B0aW9uYWxseSwgR0xPQkFMIG9yIExPQ0FMIGNh biBiZSB3cml0dGVuIGJlZm9yZSBURU1QT1JBUlkgb3INCj4+ICAgICAgVEVNUC4gVGhpcyBwcmVz ZW50bHkgbWFrZXMgbm8gZGlmZmVyZW5jZSBpbiBQb3N0Z3JlU1FMIGFuZCBpcw0KPj4gICAgICBk ZXByZWNhdGVkOyBzZWUgQ29tcGF0aWJpbGl0eSBiZWxvdy4iDQo+Pg0KPj4gQW5kIEknbSBwcmF5 aW5nIGZvciAic2luY2UgZnV0dXJlIHZlcnNpb25zIG9mIFBvc3RncmVTUUxtaWdodCBhZG9wdCBh IA0KPj4gbW9yZSBzdGFuZGFyZC1jb21wbGlhbnQgaW50ZXJwcmV0YXRpb24gb2YgdGhlaXIgbWVh bmluZyIgaW4gdGhlIA0KPj4gQ29tcGF0aWJpbGl0ecKgc2VjdGlvbiB5b3UgcmVmZXJlbmNlZC4N Cj4gDQo+IEFzIGFuIGV4dGVuc2lvbiB0aGVyZSBpczoNCj4gDQo+IGh0dHBzOi8vZ2l0aHViLmNv bS9kYXJvbGQvcGd0dA0KPiANCj4+DQo+PiAtLQ0KPj4gRGVhdGggdG8gPFJlZGFjdGVkPiwgYW5k IGJ1dHRlciBzYXVjZS4NCj4+IERvbid0IGJvaWwgbWUsIEknbSBzdGlsbCBhbGl2ZS4NCj4+IDxS ZWRhY3RlZD4gbG9ic3RlciENCj4gDQo+IA0KDQo=