Re: Add new COPY option REJECT_LIMIT
torikoshia <torikoshia@oss.nttdata.com>
From: torikoshia <torikoshia@oss.nttdata.com>
To: Fujii Masao <masao.fujii@oss.nttdata.com>
Cc: jian.universality@gmail.com, zhjwpku@gmail.com,
pgsql-hackers@lists.postgresql.org
Date: 2024-10-08T12:58:51Z
Lists: pgsql-hackers
On 2024-10-08 18:39, Fujii Masao wrote: > On 2024/10/07 21:51, torikoshia wrote: >>> While reviewing, I also noticed that the check for >>> "opts_out->binary && opts_out->on_error != COPY_ON_ERROR_STOP" >>> is similarly placed before setting the defaults, which might not >>> be correct. This check should probably be moved as well. >>> Additionally, the comment mentioning "must do these two" should be >>> updated to "must do these three." These changes should be handled >>> in a separate patch. >> >> Agreed and attached 0002 patch. > > Thanks for updating the 0001 patch and creating the 0002 patch! I've > pushed both. Thanks a lot! > > >> Also considering when REJECT_LIMIT is specified to 1, attached patch >> uses errmsg_plural() instead of errmsg. > > I don't think errmsg_plural() is needed here since, when 1 is > specified, > "rows" should follow "more than REJECT_LIMIT (1)". No? You are right. -- Regards, -- Atsushi Torikoshi NTT DATA Group Corporation
Commits
-
Move check for binary mode and on_error option to the appropriate location.
- a39297ec026c 18.0 landed
-
Add REJECT_LIMIT option to the COPY command.
- 4ac2a9beceb1 18.0 landed