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 1xGWOq-00000002R4E-0xOn for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 06:54:12 +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 1xGWOo-0000000CONc-05Ph for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 06:54:10 +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 1xGWOn-0000000CONU-2v2I for pgsql-general@lists.postgresql.org; Tue, 13 Oct 2026 06:54:09 +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 1xGWOl-00000001pPS-1E0Q for pgsql-general@postgresql.org; Tue, 13 Oct 2026 06:54:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bayern.de; i=@bayern.de; s=cc-yang; t=1791874447; x=1807426447; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-type:content-transfer-encoding: mime-version; bh=J6y8Viq8Xvmt+7wHjB8aawvLifdWDJyYJ4aV3HKdF/U=; b=GVD48s4zmm4Ql2h58YCKg004m8FeLRnIyj0GlDrFYxfTgKmRn4aNarCS ug603FOZ+cTur7xg0VV+8XWDKghRQsbbKDcvsiBNlXuC3FnoZaexcWTFf F5Fv0QxiVyGpGgDRSw9lFEW512JpoOH+R/L4yaGY0HZr4OhquN5Mf+lUy NgGG1GVDGHHzQblbrjLSwON/B0Ut128R0R6Z63ZUEREMIKZJcJMmLLqKO 3cn4GiVAQaRqrxWpG3z1UbFIDfk+6EMNhiMrOhg8pe+pVH0tc4SFrcR2G H8LEs7XYHNjFxOHJ0um56qDdbetCR1qf91BL9fyfOETPCYJSqZiUVhU3k w==; X-CSE-ConnectionGUID: PHvt5pMnR2eoV8+NN0zpiw== X-CSE-MsgGUID: 8z19sEYGT+uMaJ5OD/VfrQ== Received: from unknown (HELO rin130.bayern.de) ([10.197.20.130]) by rex140.bayern.de with ESMTP/TLS/TLS_AES_256_GCM_SHA384; 13 Oct 2026 08:54:06 +0200 X-CSE-ConnectionGUID: k02P2ZuwQpyY/pom4fYMXQ== X-CSE-MsgGUID: xv5s/uXHTICawemLciOIBA== X-Talos-CUID: 9a23:y4umt2+UYn+nxekYS9yVv01MQPh/QGDC9W/BEgigDmM1RoyweWbFrQ== X-Talos-MUID: 9a23:NAD54QXH8X87GEPq/C/y2SolKfdI34WFAV8AlLENuu6lHwUlbg== X-BYBN-routing: post Received: from zmx-ej2-p25850.max.bayern.de ([10.173.241.200]) by rin130.bayern.de with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 13 Oct 2026 08:54:06 +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:54:06 +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:54:06 +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///iagCAACUUAA== Date: Tue, 13 Oct 2026 06:54:06 +0000 Message-ID: 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> In-Reply-To: <0FC732AF-86D8-42CB-986A-78D166FE9DA2@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 PiAuLi4gYmVjYXVzZSBQb3N0Z3JlU1FMIGlzIG1vcmUgc3RhdGljYWxseSB0eXBlZCAuLi4NCj4g WW91IG1pZ2h0IG5vdCB0aGluayBvZiB0aGF0IGFzIGEgZmVhdHVyZSwgYnV0IGl0J3MgdGhlIHdh eSBQb3N0Z3JlU1FMIHdvcmtzLg0KSSBkaXNhZ3JlZS4NCg0KSXQgaXMgbm90IGEgc3RhdGljYWxs eS10eXBpbmcgcHJvYmxlbS4gTXkgdXNlIGNhc2Ugd291bGQgZWFzaWx5IGJlIGZlYXNpYmxlIGlm IC4uLiANCg0KKiAuLi4gdGhlIFBvc3RncmVTUUwgQ09QWSAuLi4gRlJPTSBQUk9HUkFNIHN0YXRl bWVudCBjb3VsZCBiZSB1c2VkIGxpa2UgYSBxdWVyeSwgd2l0aG91dCBoYXZpbmcgdG8gdXNlIGEg dGVtcCB0YWJsZS4gRHVlIHRvIHR5cGluZywgb25lIHdvdWxkIGhhdmUgdG8gdXNlIGEgRlJPTSBj bGF1c2Ugd2l0aCBjb2x1bW4gbmFtZXMgYW5kIHR5cGVzIGRlZmluZWQsIGp1c3QgbGlrZSB0YWJs ZWZ1bmM6IGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvY3VycmVudC90YWJsZWZ1bmMu aHRtbA0KKiAuLi4gb3IgdGhlcmUgd291bGQgYmUgc29tZSBjaGFuY2UgdG8gY3JlYXRlIGEgdGVt cCB0YWJsZSBpbnNpZGUgYSBwbHBnc3FsIGZ1bmN0aW9uIC4uLiB3aGljaCBpbiB0aGUgZW5kIGlz IHVzZWQgaW4gbXkgdXNlIGNhc2UgaW5zaWRlIGEgbWF0ZXJpYWxpemVkIHZpZXcgLi4uIHdoaWNo IGlzIGZvcmJpZGRlbiBhbmQgd2hpY2ggY2FuIHN0aWxsIGJlIHNlZW4gaW4gdGhlIHN1YmplY3Qg b2YgdGhpcyBtYWlsIGFzIHRoZSBmaXJzdCBxdWVzdGlvbiBJIGhhZC4NCg0KDQpSZWdhcmRzLA0K RnJhbnotSm9zZWYgRsOkcmJlcg0KDQoNCi0tLS0tVXJzcHLDvG5nbGljaGUgTmFjaHJpY2h0LS0t LS0NClZvbjogQ2hyaXN0b3BoZSBQZXR0dXMgPHhvZkB0aGVidWlsZC5jb20+IA0KR2VzZW5kZXQ6 IERpZW5zdGFnLCAxMy4gT2t0b2JlciAyMDI2IDA4OjM0DQpBbjogRsOkcmJlciwgRnJhbnotSm9z ZWYgKFN0TVVLKSA8RnJhbnotSm9zZWYuRmFlcmJlckBzdG11ay5iYXllcm4uZGU+DQpDYzogQWRy aWFuIEtsYXZlciA8YWRyaWFuLmtsYXZlckBha2xhdmVyLmNvbT47IHBnc3FsLWdlbmVyYWxAcG9z dGdyZXNxbC5vcmcNCkJldHJlZmY6IFJlOiBXaHkgaXMgbWF0ZXJpYWxpemVkIHZpZXcgY3JlYXRp b24gYSAic2VjdXJpdHktcmVzdHJpY3RlZCBvcGVyYXRpb24iPw0KDQoNCg0KPiBPbiBPY3QgMTIs IDIwMjYsIGF0IDIzOjIzLCBGw6RyYmVyLCBGcmFuei1Kb3NlZiAoU3RNVUspIDxGcmFuei1Kb3Nl Zi5GYWVyYmVyQHN0bXVrLmJheWVybi5kZT4gd3JvdGU6DQo+IA0KPiBZZXMsIFRoYW5rIHlvdS4g SSBtZW50aW9uZWQgdGhhdCBoZXJlLCB3aXRoIGl0cyBkaXNhZHZhbnRhZ2U6IGh0dHBzOi8vd3d3 LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQvZjY5YjQ3ZGJiZTM3NGJhYzgwODg4ODdjMjExOTNm MjYlNDBzdG11ay5iYXllcm4uZGUgOg0KDQpJJ20gbm90IHN1cmUgd2h5IHNjcmlwdGluZyBDUkVB VEUgRk9SRUlHTiBUQUJMRSBpcyB0aGF0IGNvbXBsZXgsIGJ1dCB5b3Uga25vdyB5b3VyIGFwcGxp Y2F0aW9uIGJlc3QuICBQb3N0Z3JlU1FMIGNhbm5vdCBlYXNpbHkgZG8gd2hhdCBEdWNrREIgZG9l cyBhbmQganVzdCBoYXZlIGEgLmNzdiB0aHJvd24gYXQgaXQgYXMgYSB0YWJsZSwgYmVjYXVzZSBQ b3N0Z3JlU1FMIGlzIG1vcmUgc3RhdGljYWxseSB0eXBlZCB0aGFuIER1Y2tEQiwgYW5kIHdvdWxk IG5lZWQgYSB3YXkgdG8gYmUgdG9sZCB3aGF0IHR5cGVzIHRoZSBjb2x1bW5zIGFyZS4gIFlvdSBt aWdodCBub3QgdGhpbmsgb2YgdGhhdCBhcyBhIGZlYXR1cmUsIGJ1dCBpdCdzIHRoZSB3YXkgUG9z dGdyZVNRTCB3b3Jrcy4NCg0KUG9zdGdyZVNRTCBpcyBub3QgdGhlIHJpZ2h0IHRvb2wgZm9yIGV2 ZXJ5IHNpbmdsZSBqb2IsIGFuZCB0aGlzIG1heSBiZSBhIGNhc2Ugd2hlcmUgYSBkaWZmZXJlbnQg ZGF0YSBlbmdpbmUgd2lsbCBzdWl0IHlvdSBiZXR0ZXIuDQo=