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 1xDSlM-00000000WLe-3oiJ for pgsql-general@arkaria.postgresql.org; Sun, 04 Oct 2026 20:24:49 +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 1xDSlL-00000005kuG-3evr for pgsql-general@arkaria.postgresql.org; Sun, 04 Oct 2026 20:24:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xDSlK-00000005ku7-2QtL for pgsql-general@lists.postgresql.org; Sun, 04 Oct 2026 20:24:47 +0000 Received: from fout-b2-smtp.messagingengine.com ([202.12.124.145]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xDSlI-00000000MAg-1rHy for pgsql-general@lists.postgresql.org; Sun, 04 Oct 2026 20:24:45 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfout.stl.internal (Postfix) with ESMTP id 157CB1D00182 for ; Sun, 4 Oct 2026 16:24:43 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-04.internal (MEProxy); Sun, 04 Oct 2026 16:24:43 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1791145482; x=1791231882; bh=AKH0x/hBYQIwYjqY8riIa2VLdqk0mxupo12mOGwDKYU=; b= vauLaW379I3q7C9G73ER4ixrEYnE4xpO6FVTFkHQeuBWlva5U/naJjMRzIOHifvQ XTolqFjiwuvmrTEaHYKKQrv7Wtn1j21y7G+Za0km01G5VfHGsWDnlu834T2t15PB 8Ql9NlgagJ7dr8ttOnnEVHyp9O/VxydXIsTPMTkyrGphIv+N7rGBciU+Cg4mEKz2 TVt8fyoAyZWf0R0yHz/qn09dyxh1UFuHkXJbUXefzGsyDrlIRa3v8XY+/lx3R2Wq /Lv/EGI3WQDNZQUV8dAzu3h1LGM6qvgqILMBbHEVjnLoXuE5AnjHO/Vl7rp16VkK ec8ApqqOGZne6aduJZ9Ubg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1791145482; x=1791231882; bh=A KH0x/hBYQIwYjqY8riIa2VLdqk0mxupo12mOGwDKYU=; b=Vig4RpBief5j/Q0Ys aQpRLa0BKaesrZRcWIhM7QSK76bKFASPZrb34ySLKwVtexLSWlKuXT3Ik8h2BFjJ qGyroUTdnpMaEqItH76l1ixiRfDic0ZT8YVODw5iujIrUWgwVsMsaWLJF3/tKYKD IrZBl0fnKiT0PTtXrOpTG32dxJsr5TI0t2xBuOrotdNpOTnmgSYb2O2vu+hXpwM+ MKtTQ9b6lzu/7P7moiVxx8zN3/S70naHwqZYjjzvo5aCVXnFU56kC9AZP+tD7pol dp7hu79MMpXqadzl68aaSy3Z8ckZSYPx6OysyNdAn6PfRPFW9jJ8Vt8mfyiYS47q IK+Sg== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-09-30; sw=lmtpprox; action=sign d=aklaver.com a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1791145482; d=aklaver.com; mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+; rt=PHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm1:rsa-sha256:bIaoyA/gEtyWzUsRj6QH/77EHwlmbpWc7jFrdzp+ruKAfT7 uuTD4rqQ40Y4fU7gXBQ0czg8uuTw1rJgdImAk1QvgJyVN7lj3kI0vXbIiVW9ntmS fUe0vm1J5Sc1MwusaosQR/J5WzSGqHIwLRYNchHkWxxpCvOhcW+nsEWnlaq1JcC1 L1D+VOoqwuCGmTY7NnaHDWzS6tu8tXYAFMZoan75NSrF+rcr6YH6AIvuO4b4ezq0 Z/1iQGArLmUiBt15yde/G+qtl+xCN4O2SiiXGk0u0pa2wJrSEl1FWuexbX6cOvQB WdipZbInpTeNZRMyTM2Nh2bJJ5Vniku1kbAOjRA==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-09-30; sw=lmtpprox; action=mi-m=1; hc=13; hn=content-language,content-transfer-encoding,content-type,date, feedback-id,from,in-reply-to,message-id,mime-version,references, subject,to,user-agent; Message-Instance: m=1; h=sha256:iXt4bkIaodJ7eqkYHKGL5SkAGcl0+i0LXHtWZ0LCvU8=:utDzsIGLhWMsGiwSp/JBX1eMDLyKu54voJV6KyvT+Lg=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTEXgkGqAhse7tF9HwdLJAPRZZX7y/yOzy8xs/2n6cVN2P1rPR0ojo11Te3fKeaNTv apjLYOl4BjlE2mgQLuRHEmPNXUJWnhqmO9pmJ3UNomVYqZB+nzt0Lpd+6GE912j52Egq9n kpIdLj4wc+KvCLjOiWoLwRCu9DRHQls9QBgimTvEzJObPIM/1LHzkOl6AyNe7IbINIWfjP lewgn8kXxuVtXnT6JhsADi0f8kk++uQyhwBGt+aBjoWsWhTuO0KJwWyko5vQT5DxzYZvIQ vIo0uhe2g8qkUYk9T3YeIiqFO+EhRMHBUh//LSCZ9HHbn4ujO7mQYuE7yeSE2FnBM15+ow DWVz3lCuOCkyfItGzwVPNDTBhVCftKw3RGs+Zk+hlYTCG7fYxYKwXBwQT8fWfiqoMC/N5U gf4LiiEAkXvp/V1geZF4Vf6uPkZwnbtnoQcyO8veqWPOTECRDJhkxmpBnVxzizWc6PwQ5t /LrGAg8LP4CQZ5mhtN+k94S4oNAinXDMdGjA9UVrjDFw4sqjpnXoKO23dqMAUF4Zvu85Sq jVcBPx1qgN9LreoBvYbvOkay4mD4LcqTxllCKdJnYYp2oNb9fG9IpPt3QmTIGI4t+l5cuV Y8Fee3QsyiypUW7pmzCz15AwQi/llKCZK+CCReDAkWppVnfea6D7OXD6Kqaw X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 4 Oct 2026 16:24:41 -0400 (EDT) Message-ID: Date: Sun, 4 Oct 2026 13:24:41 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Why is materialized view creation a "security-restricted operation"? To: Thiemo Kellner , pgsql-general@lists.postgresql.org References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de> <9da33cfb-661f-4088-9fad-04f6eb8fd21b@gelassene-pferde.biz> Content-Language: en-US From: Adrian Klaver In-Reply-To: <9da33cfb-661f-4088-9fad-04f6eb8fd21b@gelassene-pferde.biz> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/4/26 12:27 PM, Thiemo Kellner wrote: > Hi > > Giving my two dimes. I apologise if some else has given it already. And > it is quite an operations point of view and mostly based on Oracle. To > the best of my knowledge, it applies to Postgres even more. > > The data of DB temp tables are not visible outside of the session that > has put it in. In the case of trying to find the problem of code of > functions storing intermediary results, they are just not visible for > the investigator such that one has to do all the steps manually to > detect the point where things go wrong. In my opinion a real pita. I am not quite following the above. Do you mean: 1) Not having access to the function code ? 2) Having access to function code, but not the source of data? > > Cheers > > Thiemo -- Adrian Klaver adrian.klaver@aklaver.com