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 1xGenf-00000002Xfd-3qXt for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 15:52:24 +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 1xGene-0000000F4CV-3OuJ for pgsql-general@arkaria.postgresql.org; Tue, 13 Oct 2026 15:52:22 +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 1xGend-0000000F4CN-43uL for pgsql-general@lists.postgresql.org; Tue, 13 Oct 2026 15:52:22 +0000 Received: from fout-b5-smtp.messagingengine.com ([202.12.124.148]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xGena-00000001tmF-3Ign for pgsql-general@postgresql.org; Tue, 13 Oct 2026 15:52:21 +0000 Received: from phl-compute-09.internal (phl-compute-09.internal [10.202.2.49]) by mailfout.stl.internal (Postfix) with ESMTP id D942A1D000BD for ; Tue, 13 Oct 2026 11:52:16 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-09.internal (MEProxy); Tue, 13 Oct 2026 11:52:16 -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=1791906736; x=1791993136; bh=qzNGXchK1zIwGi6YiapjuSmKfbmTdqnN948AM3EGFBc=; b= y5cFxR7WWPAS2F96E2rxYHVM6TVWdufpqyqhaz7hMwNiPalfjajsUTk3QNPxcILT ZgeSSKXhoo3nNqcPaHxxXj8pTclcSTuP/JMuqwC3SR8bEPMLrOxbcfP2xmWXkusu +wF2a1jYORQ7o/sZtVB5/oE1B6q6QQ+tys8qVWwd7ao0tzpSbySiuFJ8klcPW0OW EX7An5oD3xSdM07M/IH0T+qUeiG4YAmYBGA5C6fQMblQYaYPJi+L5JSpE+O2F4IK 7nIGpAt29OoqKC7YMVX6nmMv946aG9ex4PLTiuA+KBlihtjKs4ym3H/wrIUDjvOz 0NX53deprKp1GLUyfdCBRQ== 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=1791906736; x=1791993136; bh=q zNGXchK1zIwGi6YiapjuSmKfbmTdqnN948AM3EGFBc=; b=mAp5VpAMyahjmnvHh LSTJNJqxXmEsTQOas0ZDIk3dmr56URcGLe8RTBbALCH3kh+tKpIN6QrtBjKj0lc6 CEhxFT9W1Nq/0CCurzjW6AubJpt/dLJdtENfixFVOkXIyvIB0iV6D4tDfIMx/hTi tLrhU/SmrrALx0b9hmtcUoB+FqEfmCPRpICnI+kuZrQ1mjqRHVrnPqmuQmEGrkN6 AIkNAZBW7twH90KxWx4gk73YHLk/xv1cekqnSSKBFq1EtsghGG9iewAFx0yzftlw K1T4Tad0GKbdEivdnNHMSWRePuu5O+NumDDaMK1IbeIFoP30n8CCHPaE0zSYPZ9g K+ywA== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-10-04; sw=lmtpprox; action=sign d=aklaver.com a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1791906736; d=aklaver.com; mf=PGFkcmlhbi5rbGF2ZXJAYWtsYXZlci5jb20+; rt=PHBnc3FsLWdlbmVyYWxAcG9zdGdyZXNxbC5vcmc+; s=fm1:rsa-sha256:W49wZPB4Bg7Z/8ncTFMTwR799ZqLv0O7/HBCWpW3IO98dfu VrGG/NcKOIPLaQeEG6b0nmd5OryyUAnwIL+c08u3+Co+AYcEX3VhgTwVYF5/W5Cl E6He38hxFsMHRvwdCUSjMXxV+shbM8EEovc98kkhiRcO1OFc3q4dxFPqtfgUR0eT NaQTeqkyP7VWaXe2uKzYzM7iUzxc/JYUX/21Fux85xrs1zPOACOJZUilEm4tFL8x dHmbhbX/CWTL/y7BNpTQsYbuU8U3W14cgg+a3xojC/WVywbwxkujmqiKlQ6UUkRj 5hh8oOdDE2AEzNXEmJbb+2K4DBy9l+cXbbf5chg==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-10-04; 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:RPTXsAF+tqOD4fS3Q++LE0aWHrXGwzU40YX467Nmdlc=:wM86FY7CvfErCz8QDPqjVweOZ/+eh/WOC3fJ84z+G/I=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTF9MLficAkzcSmS2vL8+7dBV+ooYy7f6T8iHeMGBzziACffUVZmJyXkH8nkn2D3NN mCY3AawgWoy/Bh/3R4RB9/JLovM6QYBfj4RCNDYMzLYiZreyX1rSjctLr0TTRxnTCbKb6E iNhAd5CsvSwIZduit8HMLDLpuiMSNFbJvlvwi3BGdZqD6vcFumk+kYbazisaGPXqYK3ry6 SRfcbw3OX5iLcpoh1HCVEsQJ/JLz+dJuLu9+8WRVsKOzRWw7yfS7ndRS4g9nXXJG4oIiAV uGZu6iCK20MHcYs9rCYZ+Rnk5IJogziZo3STQBt1DmmLYjgeYXuVLcd07Q10Pmlu0txmEL /HjBTjP7FHoTdyjtiA0lNAtdLkK6lHDStc5BLUj8rK/nG5seNjBEWWD+NEe3qeO2YA/Fwq xfyryWToyeMYp70Apm/lhv2efOM7HCDnSGKYsnnQFTPLlXR9fGo2z3adZDmg6Ymq66nLO1 6mNf/pKSiSUjxNUfbl+qh1lGcFtrdObQyrnBsDQjEaMfFl5bFPiTcEG8NwjYGE/QlqiGjk +qdBNoGfjlICn3xH29VbzmhNVYvlsYGCr35aNwhV3RUyknVbHa7G19M8GoAMRbNS+6kCyv qexgEIZsjPsw1q2nGdUlumoMKOzfmk8+3sirdT3m3HacUFe39ahh67skKfgQ X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 13 Oct 2026 11:52:15 -0400 (EDT) Message-ID: Date: Tue, 13 Oct 2026 08:52:14 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: AW: AW: Why is materialized view creation a "security-restricted operation"? To: =?UTF-8?Q?F=C3=A4rber=2C_Franz-Josef_=28StMUK=29?= , "pgsql-general@postgresql.org" References: <77826d7580a9488ca28eb4bcfe94aa37@stmuk.bayern.de> <2e9d29c1513afb47d652387ea5299076ef24adce.camel@cybertec.at> <9f30126c-9e72-4ced-83e2-3f8e5da183d3@aklaver.com> <569054683acf4de7a3f2de80391b4e71@stmuk.bayern.de> Content-Language: en-US From: Adrian Klaver In-Reply-To: <569054683acf4de7a3f2de80391b4e71@stmuk.bayern.de> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/12/26 11:12 PM, Färber, Franz-Josef (StMUK) wrote: > Thanks for the suggestion. > But what exactly is the suggestion? That you also read the links included, where it shows that DuckDb is available from a multitude of languages and can connect to a Postgres database to share information. Think it of as in-memory database to do the scratch work that you then pass into Postgres. It is definitely a round about way of tackling the problem. > > At least I understand DuckDB can directly read without having to craete a temp table: > * SELECT * FROM 'test.csv.gz'; > * SELECT * FROM read_csv('test.csv', header = false); > > ... which is what Postgres is missing. > > > Regards, > Franz-Josef Färber > -- Adrian Klaver adrian.klaver@aklaver.com