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 1xE0kd-00000000rri-2qoe for pgsql-general@arkaria.postgresql.org; Tue, 06 Oct 2026 08:42:20 +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 1xE0kc-0000000GH7L-15aT for pgsql-general@arkaria.postgresql.org; Tue, 06 Oct 2026 08:42:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xE0kb-0000000GH7C-3Z3F for pgsql-general@lists.postgresql.org; Tue, 06 Oct 2026 08:42:17 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xE0kZ-00000000gNu-2HnZ for pgsql-general@lists.postgresql.org; Tue, 06 Oct 2026 08:42:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1791276134; x=1791880934; i=karsten.hilbert@gmx.net; bh=F2qXlcD6VCRQGuv0J/Pog5eHOQ68N0eue+QMwzxtXA0=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:References: MIME-Version:Content-Type:Content-Transfer-Encoding:In-Reply-To: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=QD5FYBDlnA195biVamaHP6qNhoYe1pQXUXTlh15n7ZjK4I487oW8i7/bNxCBlY72 qbe9yNNoW1x9UbZ+lNBxFS4lWYOU0dL9zaLH0bZMSrZkn2wIrWfdbBnZtPeOYYtI2 Wc2Ocn4fjblwbnA7Ca5rNDQvZDJBzMVedu1YAao7ockJxwH/hQCe33rBXBF03CLy9 1m5BeDzch31rn8XItyt3JsTd8ihKd8X6LAWSCV8GzDsqrEVrWTmJkq+V9Hpxr9YOC l49Lp+noQGpUnVDr+6sgZ/Ldsud9cA85c/5P31IohObMlt691keWE1nh+kYfhnIVR /SvhJZApMCw/nmIMhQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1Ma24y-1x8WY61Gc8-00PjxE for ; Tue, 06 Oct 2026 10:42:14 +0200 Received: from ncq by hermes with local (Exim 4.98.2) (envelope-from ) id 1xE0kX-000000005yI-2TjE for pgsql-general@lists.postgresql.org; Tue, 06 Oct 2026 10:42:13 +0200 Date: Tue, 6 Oct 2026 10:42:13 +0200 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: Re: Why is materialized view creation a "security-restricted operation"? Message-ID: References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de> <61488cb9-5b84-449a-9886-e0d3b9671aa6@aklaver.com> <886a7a1fb54a4abdbb89897a6854edd7@stmuk.bayern.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: <886a7a1fb54a4abdbb89897a6854edd7@stmuk.bayern.de> Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:qaBnOSe+vNTHfrjLaVzEUGVbcceMU1KwJKiHsjobezsXf1LDdH4 4pkMnJHJyhaDBXw90ZcTrQlVLZSyxN2cT2aGsg/1R8ZD5kU/mMNMW7Xiz2klfZPWNBnBZe5 qGaZA874NoNXjjQGxAmX7121qx6KOFCq7SoZefpk40nKG2PM1YovQfKbUa7lUidt4tXDkS6 xOJXQ0YTwh1OADyYTgxOw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:b+yY3bO5ziw=;VykS6sgCFNCnj6zYbsHmxfXutth /yilRRSHzKH5VLhr572qSLlf5B7iL9EJNmRg8ThqBMm4omK8Gm2I6k5rJovI+VKAKHEtIRJGx Bwhb5Ci6ZBS8CllAOh2RlbEDmgLgmSdzYpSH2deNXqycKPjj2iGzwuVJnTcZXbxv7RW48AMy2 TjDSgKovycJ46l+M959f0oYwV4eU5rjlHK0HvGz6y90BMzfZZ6yXfX3apLOtykmXlwEwQxRbD FnURoyTIMnp9kda1cs4LOG1MUJ8WUCbwOnVs/HC/15ufSdo1RKBbRFX0kOBMHru7UvZ24UB6c rnLyz9reCM7+a80HTOJJ/m+Kxzqndkv62uRmVsd8JDXDCQG29s7VA1KdRZ+5jQWcue8UihkSY EPUK6Q5b6dZJjGys6Ot9URRl/5xhkOwrhUeCFj7RWhdhak1SwoZQf49oaA+w3/BDB/sqr6abV M/vNqOCXjT/mPU0tM7eZpUnTBwmkZmGUy0DOQ32A3Wo6RUpwy16QuoKCoyVwx1S+oQsfwM25i 1VkToZ3d1duBx3Pm0M/fZQYJ6Mw/BNW6h69b8EWg3jqV02zBlI+7duOJd2Onc20BbpkN6SIKD 4eMdv4L8xJy1T8+iB47l+PaOF4iMua5JAIRfiP97h3svtidXAaFavC+y/Rx8LMaX/IZHKYHSw 8Z9xf/b9HPMMSMq7Bj8WxEWGQmIwOVxAS7ioOUK03pY6jjBA1V7PJZc9+RbDz7MV3/ARMnbTV mfhQFmO25eS9lKsG1QbH6oCkSPTi+UWeLGzI7yyDRQWYaKIJHEm+SbPTSW3BGxQbY08kijEpm 3zyEjWaJDIWMts1hPoGumdLdtK10Lc0ZiiYcQdheyLUXiLOipz5rm4kPD5wGBobqp1uoLaVGV JDVJ6wI/ewY1i4MxLKQfCB1bQtyKGyt4h1GAYGu8Wamfo00Y6kznZ9AviF313ClnZMWW0OmTq N/4liuw6WdzmilrDFn9e103lbISDE4qbmnWZH31+waHIS3iqHqkzeiQSS+yvQOd2fVu8ybIli KczoIpOhLKt9F9IowXl1kr/tVdVXBK1hLje6MLzk0nCeStMR+F2J202QgISwVfGEPFu6C/+BP sN3E9FnkD/TgAvcNam+rTnQu109hVuQa5cTedPDt7+Ud5IvrahJ/yrP4GasOpmGYZyNyK72rH DQ0OzeAMdhPOC7mwXNxsCrAG/vL2p6Y3bb97Etrc6E8ToqIzGvuKTSGgD/zyrSusal7mMEiyd gBvLNmp2913175Z/bkf/Jq687yuRbtwUrh2oWArWCyXYnUDi3MzBhzqJsLwljkyQRGdpHP7Ep dJEC9/zWWVODazEIuM76/mlCL41xjRbEqdYMZXGCyz3PybGYkWiIoYvckXEoxQQ1/cHOw0wlz vro6VUwFz3K4N58sHSPvoDlq2UtMrIXFJTH9DRU+bDJJWGX33knd13emWVmm+BTtTmTdy47Gr ouXHbzKZDF+1VfZw7FeXZQlrKnVKs/YxOP/Len0Z5eyCA8iDuO7CT6kzEycQBi1ubK8FB76g2 HuDoaKk79AgoHZfz/+a3uqP9Gt3wq84DKFoL4Ec3ggncMAHi8CoQfgn5Teus1bva7VlZ284y6 mI5lWRcaacSWbqdxTo5rm1wdCZa7uGnp+1uR3Y5uF8crk3aGX9/EFrKDuuV8BOSvzshH+qZOd e6VP07Z80aQMlnRIVLEJe5ntkwFuHSOSZAlH9ESvGLIbR2mnULyGN8JdNxwG3fCJ+KlRIt/pi cOYsWUrpsknX6G5gw+C7s68qQpxp8JRr4Bw3g1lW0p0BDzAUllQCKKfwtYViNh024d/tpR4RI 6CLx+56SOXViAXR1PC7SP7y15v3nanydorovg6CxJ2013+IfrPi7iycIyY50XIkQ/7w8vgHS6 BunZwEfz03SgZYipUVp0xPV1ELkShDpxpxgY08jeFc6nyEVpNF67vNaysPChPHt7t/rlA2KZt 3a93p7zCYlI4ZZcKKPoLTsxQ8illPJluD5d1UVAkjKohd7B3R00YgKfh8Oi4lAtJhq8F6rRL7 LFoBHOr9jIywax2g2osCwhPYEB21KmCqVCQQpxKXM/SF9oeVrtpF3nBFcEwHjTdiTdjSCPKVx Fvdu//ztbG1qjJCGgS/TskJm0b/hhSaEHw427GhNSE1l9xuk7Z5xuBY8JYTX42EXgMZslmq9Y bS1j9c4gX9sqfNIqEMY7CV7rqf32Hsf62VMz/FDoyN8T8Q0UKOCRj03VVHPkNlxYn9cHwCzR+ n0q9ThpQy3xnJYqz89KVSgWOypjup90kIUB8LZ0/WzmWhWqcMqeBP8c/pA6iOn954A5YZlU5u KLvtk89qC5pOzjSnA6nQ0/fxcg1CenGmfNxIRWlCxsaTNGimU6BlprIQkzrmLD1AmDe9s7Nrv Hr1YPFsVhhKqKLYvxId0p+B7dH3vRt61FyCVYjzy07Ze80Weswbln0Ui0ZTt1tHUsQm5KtMuB BthHhjtTb8TNCUwTh70eZeyCQaBSpyAxsDN6avSaPQywtqXXc8HpwH6xD4HJxQ4EsHAv++lrB AA7viLo5t0BTXoFiaE+84b/eD4mglBnayU8w3ZPfTpEHXqL6jKr6176PnRIyzitsqBOZKaxdb 5N8hzxqwIPTMlxGYEnp9mpVUaKSQ7+n8nm0s1JnhO/Ciz85lwnkjiX+2Y9qQQKci34shFb4UT 0CrLuev53Z9Z/642d/FSngrPXYQQP572OysNiphot+5vC/nlTzqOB0+Qdr63ee404N8TFSf/u 23TcCsK1n8qNzhPvi8IajyLGkf9/tupjSqYgm0cBc7QIB4XhGO6FC0cOYtTxaH0YB0efistzC kz4vZiNx6HqP7QodxOC1d/VphR8fVqdp7PZKRbfac9VBcj9k+KbHwukzobUl0eW+Cug/fBtZ9 C6xcvTqnScepZV+R4OLP9q/vWgYlvv9Ps3MyPtGE55ut40XxecldweoKjH2AQxORjjndGK8Dz xzvMeyw7WbCp3/uzSvQRG5EEJgNea4kKozUHh+D+34FeoXy0HpThU9+LlbriOmVSur5dZ+GqR MUBP9aF9cS7VdZHAZIon7+PC7KQYgRGUHs1r/g/rYKMb3EorO7Uvywzgb54y+LvZmKZY6bpIr SyXwZMBeBuIBUOO35iJ9gfGq6jaehyxDhPBxwxta9U/aTTsM3/mhecaV1DNsXpLoBbI5d/T8D KQGrY4aUJEFW+gEE/GJ89/Qctm0rRUolgbPRe7YkegqqWE2wM8S+bWS6JHeQD9C/GRa2mQrT8 jMWAG4EO5qciAAGU8p7ltunoHmzLcUfcn/PGWaIJz4psbJsEtpyL7JMXIlkG6r0g7SnAp8WY7 WKYMPS4oggFD5IpmOi2lLmuWQDc11P+Btkco+rUc5qSFzdEIINXkq+S7za0SVxKB6744LhZSU RltDoecTnWw3pwkrnZKKM8ZkAnZTD71Tn4gak9ZsWMqLu0CPHC6RH2YfMWpq3/SgbUdb09YWP +mZIh6OVqhrCu4mYtipm+woMPngyQyb1mQMrTjl4Sxz1UV+ykVY1NG0RFlzi3Zc05JpUED0YN qkRHukvdG2T9aKrpqbOaG6tUQ02zxgcvfqlwUUipTP+jmLElO4BqzXxU+c+6WqUF1yLBq14Zv fYQpoytATx2fZKJpeQSjwVCHacZ4f9ksoPyuIXTnEtP+HN1THqoS0SUKGNUg3RKsejNrBguln 9l2ZThUNL3Wube71GFVOJvT7PEuL+E6OrVURKEnExn2l5MOU+5QkN2zfwu/wyii0B+fb5QPxx y7vCnEMHG0+yDZOuCLDsI4i0K2tGE6oUlji0ZaaFr4W3Q0PcBTy/bnILaFFkkzgChVQ6VFrVM 2WXnMVkxFKnGAOYwS3hiRiAf6lFi+HhM68VZWDBwxKTULokwDF//QD72xOIKg0cm4AIVtWNOF kagDRfaBKM/6I2z8/i6+aRjkIrpeEh0PYdBCJlMwBHkMQyLrkR/oXdbbZj1pBz50h0jPK1EQW 7bT+gnRbJKtdQEAxsTK99JK+iAe48eXOz7JJ+dbV6aVt3nh54VuDOHcCtNhLfRdxY3+wonTZX 7Nbb7Gdf9jGtdc0RG3yXoDsIKQcJTMQCzfeXgbip8+bhzBQ3DSD5TqdEJ+ISPWsckc7VETDv3 JsneovwS/MhWnazBFJdHMpgxTE2TN1scrBDtoyqHWPbMlS0rs73zJZJf5XETu5oPgOd6RQ3/a zxyKPkOHBd+xqTnYrS7rqNU+Oq9HakyYoppoYtcTLRa78sdky4aUNPWP2Fjf272QhGpGa1jZ2 aE5uAK6FHY4kSsB9AsKe9bYZhcNzCUgoe72MwuPW7kEPf3rUGLRHfFgcxKFiX4o/hLXZJTHKd j12xMFqqMTUxlCuoBcjOqc4uc7ylHZmRexP6Jovae5frj9hLJgLgldjH27S6JPzPbvIPPIkof JV+VPbWfYh98Irmpvx7Pgh4esUZkieYSEVHitTvYZPe3EAXaLzziXDK3MgniL97t9uT11VELF PQFeqkIPTgm12EWWjjHyJksaBD49DNNnlRRBR/3z8+A8zYuFX5/0uq+LmcZzVqSVbjwHL4+m9 Fs2rjO/GAkJRtZwVXmEA3vGVQAyNTwZcfm014mSD8UmWl8AGm/UpII0gsugf2EiQ0DV1ZPxqi jzIm/kMvI4RdO50yBim6FQRSaQGY2EFCs5mSRv6v1F6YaQzeLdlWWi+K/PVay9jIljXWO+xs+ 9b2KAnmEzgOOIjtZsASNynOmKzcHaxi8Qf340lTKHvKWWkkHN1enIJGLgfNy4sdombk4n4NQz wVi4+TNapfkaadk09zYaw+a+CdQ6kwgW12nYCDJYSGxKro6tn4j/5E8lnewXGr+dXpKZK3qrK NihXu1CL64/hyzinO701us2SNaiJA7S5BhG3Aw2HF5hyfNMyETcrqrsSqYPrnpYodYgC4A3PF l6b82ru2KAN02qAD7isw++3Q6nxdrMnxbfncGiH1fd4HnZVk8S3XCE60fWNjF/RaA0czY9ZXe u2E8QNzZFg3dTAsKVdjmtEHm3jWrjgyH9DpwKB4Rf9ENVll5MJaGN47o8T58bHfZrS9Rci/rM Rm+8ipviF5K3uJrIE73leeFBXULSACrD4dJU6GrGkSLeBRDBzdXsEe5DuMHb6U62ho8RwEi+J ysdqs3TRut37Grm0nYG/ySgvCe0Eg/1ww5jJPnX2mynp857lzp6iSraRqriy7ghPcv4FuOLTl jiv1UnV6GdnsOLGI4veXuXzzYrDFV23XWZHLPwAAYQGWHyGseAY5QI8NDF2Qmcrzha5BfiR2C ZtyWilddS1/3kYfcAZX6HEHFShAfv7W9gQvD9vcV8KaoFzYPh31Y0TpstNgXRvJBJRbp9XIzV QQSsXy+La/KVpXm3GNW98gAUM4xdgyeL6qGpl0TofthSL6+0CdsLm/Yl93Qg9Szsnx6IEQlk6 P5dbHqFXILr4gheu6fkLHbD5ZBsm5cD0/m5NNbDK61VHO3Hh9pq7O+3lbBNy00CsT6HXum9zE RkXu/dQeRfXlLHCHRsMq8pL3GwRQQ/ud6g5ic/Zv/Dh9qF3yuxKn1TB9IuUc1DYF6hMGPh9Z/ VC4cemwUky7JpML86jnD+zL0tburMW4QPsr09N5qXQY7jzUqBssIgHoA/EiyN2Tep8Vfmuvra yGYSc+X9KFkJrnbMaFyVA8v3agKbK+EuxokAFTUAfH4MS6UXwbFKWFVR+qPJBI1/+EBNRBS5+ GRU4rymIC7rNPA9DfP+XTNG5z+t/8Yuctt73/iWRzxMK3BZvMXtjlqzuvu7F+gqqTRUDAxwik DZMKh7ECw5Y7CIWi3bWtUcd3FeeFHusgPU18mDvM7e/Z/KXyIGhaiFPS5vl4xvZIeIOvo2hcL OQBDq0Fag7u5SNduHCWoH+BXaPQtrTUOavvIoWeqCT3PkrYu9HbQWTC5k/XFDkO6szlou90oI km55vynbH5TgK+bvdquQZrOXKE2JAmMSHZ+fT+EHsUyL4wAmhQX5dgtORyOfY2mxmkX7d7TP5 5Jf/eUU78OvH0AE4cuccjFxJvnp3syrNCJgl4uvOEztSOMXkgPIj/eT7dvZtVcl1gojdEUqSt M3dv6QO76bfwuVPAskEXJoMIV9siStVZC74IBLSoUcltpCDx87DdhdhmqO+r5KFwwX4NESBEv /mJ7aedJkddAviPdAZu6Jog9RDDmKLmoGrc/JZ7USpL6VD/CjplQCjBmdFdRClMf/YcO6AX0M hxf+nXXRLACHQuFQjpqA1fMckoeHQepEHEwjs0+mirCrGKaB76ETrW6TTvS/uLOmo+NmhlLGA 59xRt5/3FlNVDC7UUYeJi/hvXMQv0vy4ikTSu8JVHXzg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Tue, Oct 06, 2026 at 08:20:14AM +0000 schrieb F=E4rber@pop.gmx.net: > Are you sure the extension pgtt would work in my case? Did you try ? Karsten =2D-=20 GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B