Hi! I think this is a demanding and long-waited feature. The thread is pretty long, but mostly it was disputes about how to save the errors. The present patch includes basic infrastructure and ability to ignore errors, thus it's pretty simple.
On Sat, Jan 13, 2024 at 4:20 PM jian he <jian.universal...@gmail.com> wrote: > On Fri, Jan 12, 2024 at 10:59 AM torikoshia <torikos...@oss.nttdata.com> > wrote: > > > > > > Thanks for reviewing! > > > > Updated the patch merging your suggestions except below points: > > > > > + cstate->num_errors = 0; > > > > Since cstate is already initialized in below lines, this may be > > redundant. > > > > | /* Allocate workspace and zero all fields */ > > | cstate = (CopyFromStateData *) palloc0(sizeof(CopyFromStateData)); > > > > > > > + Assert(!cstate->escontext->details_wanted); > > > > I'm not sure this is necessary, considering we're going to add other > > options like 'table' and 'log', which need details_wanted soon. > > > > > > -- > > Regards, > > make save_error_to option cannot be used with COPY TO. > add redundant test, save_error_to with COPY TO test. I've incorporated these changes. Also, I've changed CopyFormatOptions.save_error_to to enum and made some edits in comments and the commit message. I'm going to push this if there are no objections. ------ Regards, Alexander Korotkov
0001-Add-new-COPY-option-SAVE_ERROR_TO-v3.patch
Description: Binary data