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.94.2) (envelope-from ) id 1u0eMC-005A39-G5 for pgsql-committers@arkaria.postgresql.org; Fri, 04 Apr 2025 10:33:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u0eMB-00GKdB-5X for pgsql-committers@arkaria.postgresql.org; Fri, 04 Apr 2025 10:33:03 +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.94.2) (envelope-from ) id 1u0eMA-00GKYx-TW for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 10:33:02 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u0eM8-002trY-3B for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 10:33:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=tMBYqlPktI5fKKtNpBvMOHgGSvozT59zkX+nK5pR5to=; b=Tm5+Ei9hI78d815VGt8925l9DT j7Zs5fWzNjLCCUgHlrmzb6of7w0lxILZQ9xCIPRXYIe0hz6ipJHhhSjfBAk6xwzXqnwFjfI6FLPPP VwD6Vd5Zn5vuhuv6uV9KtCYwhgM8+FOnxeeE7noYZEOkzAh11fgvUiu4xqjzm19UGIrbf3Y1FkYzy 6ILrCXtvd+uyUr4oCNs6bOAMQjlRxF1rrk0Q1gW1xpODwfGtrLeMKOBfLD8qEN18OtbwWiX5y9nfT aE70PwkdM0Sh80oKJuIZjfeWL0/xcxyw0Lq9e44fc28B6jJjRHhD5aPWVZgg/RBywBEjWKgucNcME 0q63n0IQ==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u0eM8-00007I-Dx for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 10:33:00 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u0eM8-002cAo-0X for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 10:33:00 +0000 Content-Type: multipart/mixed; boundary="===============6404626153043141974==" MIME-Version: 1.0 From: Fujii Masao To: pgsql-committers@lists.postgresql.org Subject: pgsql: Allow "COPY table TO" command to copy rows from materialized vie X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 04 Apr 2025 10:33:00 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6404626153043141974== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWxsb3cgIkNPUFkgdGFibGUgVE8iIGNvbW1hbmQgdG8gY29weSByb3dzIGZyb20gbWF0ZXJpYWxp emVkIHZpZXdzLgoKUHJldmlvdXNseSwgIkNPUFkgdGFibGUgVE8iIGNvbW1hbmQgd29ya2VkIG9u bHkgd2l0aCBwbGFpbiB0YWJsZXMgYW5kCmRpZCBub3Qgc3VwcG9ydCBtYXRlcmlhbGl6ZWQgdmll d3MsIGV2ZW4gd2hlbiB0aGV5IHdlcmUgcG9wdWxhdGVkIGFuZApoYWQgcGh5c2ljYWwgc3RvcmFn ZS4gVG8gY29weSByb3dzIGZyb20gbWF0ZXJpYWxpemVkIHZpZXdzLAoiQ09QWSAocXVlcnkpIFRP IiBjb21tYW5kIGhhZCB0byBiZSB1c2VkLCBpbnN0ZWFkLgoKVGhpcyBjb21taXQgZXh0ZW5kcyAi Q09QWSB0YWJsZSBUTyIgdG8gc3VwcG9ydCBwb3B1bGF0ZWQgbWF0ZXJpYWxpemVkCnZpZXdzIGRp cmVjdGx5LCBpbXByb3ZpbmcgdXNhYmlsaXR5IGFuZCBwZXJmb3JtYW5jZSwgYXMgIkNPUFkgdGFi bGUgVE8iCmlzIGdlbmVyYWxseSBmYXN0ZXIgdGhhbiAiQ09QWSAocXVlcnkpIFRPIi4gTm90ZSB0 aGF0IGNvcHlpbmcgZnJvbQp1bnBvcHVsYXRlZCBtYXRlcmlhbGl6ZWQgdmlld3Mgd2lsbCBzdGls bCByZXN1bHQgaW4gYW4gZXJyb3IuCgpBdXRob3I6IGppYW4gaGUgPGppYW4udW5pdmVyc2FsaXR5 QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEtpcmlsbCBSZXNoa2UgPHJlc2hrZWtpcmlsbEBnbWFp bC5jb20+ClJldmlld2VkLWJ5OiBEYXZpZCBHLiBKb2huc3RvbiA8ZGF2aWQuZy5qb2huc3RvbkBn bWFpbC5jb20+ClJldmlld2VkLWJ5OiBWaWduZXNoIEMgPHZpZ25lc2gyMUBnbWFpbC5jb20+ClJl dmlld2VkLWJ5OiBGdWppaSBNYXNhbyA8bWFzYW8uZnVqaWlAZ21haWwuY29tPgpEaXNjdXNzaW9u OiBodHRwczovL3Bvc3Rnci5lcy9tL0NBQ0p1ZnhIVnhueVJZeTY3aGlQZVBOQ1B3VkJNemhUUTZG YUw5X1RlNU9uOXVkRz15Z0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRl dGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzUz NDg3NGZhYzBiMzQ1MzVjOWE1YWI5MjU3ZDY1NzRmNzg0MjM1NzgKCk1vZGlmaWVkIEZpbGVzCi0t LS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9yZWYvY29weS5zZ21sICAgICAgICAgfCAyMCArKysr KysrKysrLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy9jb3B5dG8uYyAgICAgIHwgMTMg KysrKysrKystLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NvcHkub3V0IHwgMTIgKysr KysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NvcHkuc3FsICAgICAgfCAgOSArKysrKysr KysKNCBmaWxlcyBjaGFuZ2VkLCAzOSBpbnNlcnRpb25zKCspLCAxNSBkZWxldGlvbnMoLSkKCg== --===============6404626153043141974==--