Message-ID: <c9e9b8e2-a343-4d3b-8d3d-29848953bdeb@oss.nttdata.com>
Date: Fri, 4 Apr 2025 22:39:06 +0900
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: in BeginCopyTo make materialized view using COPY TO instead of
 COPY (query).
Content-Language: en-US
From: Fujii Masao <masao.fujii@oss.nttdata.com>
To: jian he <jian.universality@gmail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>,
 "David G. Johnston" <david.g.johnston@gmail.com>,
 Kirill Reshke <reshkekirill@gmail.com>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>,
 Tom Lane <tgl@sss.pgh.pa.us>, Michael Paquier <michael@paquier.xyz>
References: <CACJufxHVxnyRYy67hiPePNCPwVBMzhTQ6FaL9_Te5On9udG=yg@mail.gmail.com>
 <CALdSSPgsgC_CGDjTyzu=1FAbuavTRsGFDnnm7ufGuWcd29QUHQ@mail.gmail.com>
 <CACJufxE35HxSMqG6su0txZwOLpbnBsDBav5eigxt6L8Nk8bJwQ@mail.gmail.com>
 <CALdSSPi3Gb=fi0ZCoJhAp3HQYKJmiCShcX4xMcUBSL0s5byBXQ@mail.gmail.com>
 <CAKFQuwbs61rxxCUVhECLSq4Xrz9s54dD2TzhX58d7+6WcC8dpA@mail.gmail.com>
 <e38cbf42-0f8e-4c3b-8c77-70c83116fdb2@dunslane.net>
 <CAKFQuwbD775kSHFfyF3shu+XMTX=3SEH+_JYLOWvrPo3y5dK-w@mail.gmail.com>
 <442e62f7-ef64-4df1-8453-d682fe9bdaa3@dunslane.net>
 <CAKFQuwaMFiNGhk-F+TG4uVjiAfFwar6t+7fUc0mKDz55DGODcw@mail.gmail.com>
 <425ebe4b-06c5-4212-af68-fd0e5537c250@dunslane.net>
 <f6abc172-f300-4e90-bcc6-c189d29d2f9f@oss.nttdata.com>
 <CACJufxF3noNs9O6O3fL783h2-Sy1wfJb=0H+WMFmOLuhkfJw8w@mail.gmail.com>
 <4f9481ea-5dbc-43b2-a8a1-ec4cbecce6e7@oss.nttdata.com>
 <CACJufxEA-_hUmg=eMrEpd-BK56qXyu9a1izsRHH_8Amw3MXP2Q@mail.gmail.com>
 <a95a1fb6-e58a-4b78-9e46-d7fcae66033a@oss.nttdata.com>
In-Reply-To: <a95a1fb6-e58a-4b78-9e46-d7fcae66033a@oss.nttdata.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/c9e9b8e2-a343-4d3b-8d3d-29848953bdeb%40oss.nttdata.com>
Precedence: bulk


On 2025/04/03 20:46, Fujii Masao wrote:
> Thanks for updating the patch! I made some minor cosmetic changes
> and updated the commit log. The revised patch is attached.
> 
> Unless there are any objections, I'll proceed with committing it.

I've pushed the patch. Thanks!

As a follow-up, it might be worth enhancing psql to also
complete materialized view names after "COPY".

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION