COPY FROM IGNORE_ERRORS - ignores rows with errors while copying

Edit
ID 3817
Title COPY FROM IGNORE_ERRORS - ignores rows with errors while copying
Topic SQL Commands
Created 2022-08-16 13:27:10
Last modified 2024-01-16 21:38:30 (10 months, 3 weeks ago)
Latest email 2024-01-19 14:26:25 (10 months, 3 weeks ago)
Status
2024-01: Committed
2023-11: Moved to next CF
2023-09: Moved to next CF
2023-07: Moved to next CF
2023-03: Moved to next CF
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-09: Moved to next CF
Target version 17
Authors Atsushi Torikoshi (atsushitorikoshi), Damir Belyalov (xhevx)
Reviewers Daniel Gustafsson (d_gustafsson), Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina)Become reviewer
Committer Alexander Korotkov (smagen)
Links CFbot results (CirrusCI) CFbot GitHub Wiki
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3817
git checkout commitfest/cf/3817
Emails
VLDB Features
First at 2007-12-11 11:11:48 by Simon Riggs <simon at 2ndquadrant.com>
Latest at 2024-01-19 14:26:25 by torikoshia <torikoshia at oss.nttdata.com>
Latest attachment (copy_on_error.diff) at 2024-01-18 14:59:44 from jian he <jian.universality at gmail.com>
    Attachment (copy_on_error.diff) at 2024-01-18 14:59:44 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-Add-new-COPY-option-SAVE_ERROR_TO-v6.patch) at 2024-01-16 15:08:45 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Add-new-COPY-option-SAVE_ERROR_TO-v5.patch) at 2024-01-15 15:17:33 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Add-new-COPY-option-SAVE_ERROR_TO-v4.patch) at 2024-01-14 23:21:07 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Add-new-COPY-option-SAVE_ERROR_TO-v3.patch) at 2024-01-14 01:30:32 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v2-0001-minor-refactor.no-cfbot) at 2024-01-13 14:19:35 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-new-COPY-option-SAVE_ERROR_TO.patch) at 2024-01-12 02:58:44 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v1-0001-minor-refactor.no-cfbot) at 2024-01-11 03:13:35 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-new-COPY-option-SAVE_ERROR_TO.patch) at 2024-01-09 14:36:37 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v15-0001-Make-COPY-FROM-more-error-tolerant.patch) at 2024-01-06 00:50:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Make-COPY-FROM-more-error-tolerant.patch) at 2024-01-05 08:37:32 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Make-COPY-FROM-more-error-tolerant.patch) at 2023-12-28 03:57:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Make-COPY-FROM-more-error-tolerant.patch) at 2023-12-20 04:07:38 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Make-COPY-FROM-more-error-tolerant.patch) at 2023-12-12 13:04:29 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (copy_test1.csv) at 2023-12-11 14:05:33 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: No)
    Attachment (v10-0001-Make-COPY-FROM-more-error-tolerant.patch) at 2023-12-10 10:32:12 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Make-COPY-FROM-more-error-tolerant.patch) at 2023-12-06 10:47:10 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-a-new-COPY-option-SAVE_ERROR.patch) at 2023-12-04 02:23:30 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Add-new-COPY-option-IGNORE_DATATYPE_ERRORS.patch) at 2023-09-20 16:15:15 from Damir <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Add-new-COPY-option-IGNORE_DATATYPE_ERRORS.patch) at 2023-09-15 10:02:31 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Add-new-COPY-option-IGNORE_DATATYPE_ERRORS.patch) at 2023-08-21 12:04:31 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v5-0001-Add-new-COPY-option-IGNORE_DATATYPE_ERRORS.patch) at 2023-03-27 13:51:32 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v4-0001-Add-COPY-option-IGNORE_DATATYPE_ERRORS.patch) at 2023-03-22 13:34:20 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v3-0001-Add-COPY-option-IGNORE_DATATYPE_ERRORS.patch) at 2023-03-07 08:35:32 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-COPY-option-IGNORE_DATATYPE_ERRORS.patch) at 2023-02-28 14:28:06 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-COPY-option-IGNORE_DATATYPE_ERRORS.patch) at 2023-02-27 05:58:29 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (0011-COPY_IGNORE_ERRORS.patch) at 2023-02-03 10:27:24 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (0010-COPY_IGNORE_ERRORS.patch) at 2022-11-02 08:46:03 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (0008-COPY_IGNORE_ERRORS.patch) at 2022-10-17 10:17:38 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (0007-COPY_IGNORE_ERRORS.patch) at 2022-09-29 13:18:51 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (0005-COPY_IGNORE_ERRORS.patch) at 2022-09-21 12:11:46 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (0004-COPY_IGNORE_ERRORS.patch) at 2022-08-24 16:57:13 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (0003-COPY_IGNORE_ERRORS.patch) at 2022-08-15 13:23:26 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (0002-COPY-IGNORE_ERRORS.patch) at 2022-07-19 12:40:36 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (0001-COPY-IGNORE_ERRORS-option.patch) at 2021-12-18 08:55:24 from Damir Belyalov <dam.bel07 at gmail.com> (Patch: Yes)
    Attachment (ftcopy-04.tgz) at 2014-12-26 10:49:05 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: No)
    Attachment (0001-poc-copy-from-.-exceptions-to.patch) at 2014-12-25 21:23:19 from Alex Shulgin <ash at commandprompt.com> (Patch: No)
History
When Who What
2024-01-16 21:38:30 Alexander Korotkov (smagen) Closed in commitfest 2024-01 with status: Committed
2024-01-16 21:38:30 Alexander Korotkov (smagen) Changed committer to smagen
2023-12-04 10:10:34 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-11-15 20:29:12 Damir Belyalov (xhevx) New status: Ready for Committer
2023-11-09 04:58:42 John Naylor (john.naylor) New status: Waiting on Author
2023-10-19 19:16:38 Alena Rybakina (a.rybakina) Added a.rybakina as reviewer
2023-10-01 19:40:34 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-09-15 08:12:51 Damir Belyalov (xhevx) Changed targetversion to 17
2023-09-15 02:23:45 Andrei Lepikhov (lepikhov) Added lepikhov as reviewer
2023-08-01 18:01:51 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-07-21 07:48:36 Damir Belyalov (xhevx) New status: Ready for Committer
2023-07-17 01:45:48 Atsushi Torikoshi (atsushitorikoshi) Removed atsushitorikoshi from reviewers
2023-07-07 08:15:23 Damir Belyalov (xhevx) Changed authors to Atsushi Torikoshi (atsushitorikoshi), Damir Belyalov (xhevx)
2023-07-07 08:15:23 Damir Belyalov (xhevx) Changed targetversion to 16
2023-07-07 08:15:23 Damir Belyalov (xhevx) Changed gitlink to
2023-05-15 11:08:01 Daniel Gustafsson (d_gustafsson) Added d_gustafsson as reviewer
2023-04-09 02:37:06 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-03-27 13:56:02 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2023-03-25 12:25:23 Atsushi Torikoshi (atsushitorikoshi) New status: Waiting on Author
2023-03-22 13:34:58 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2023-03-06 14:03:56 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2023-01-31 16:23:14 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2022-12-13 23:53:15 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-10-12 06:55:00 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-09-29 13:22:01 Damir Belyalov (xhevx) New status: Needs review
2022-09-26 14:28:17 Atsushi Torikoshi (atsushitorikoshi) New status: Waiting on Author
2022-09-21 12:14:12 Damir Belyalov (xhevx) New status: Needs review
2022-09-01 02:44:47 atsushi torikoshi (atorik) New status: Waiting on Author
2022-08-24 17:48:33 Damir Belyalov (xhevx) New status: Needs review
2022-08-22 14:13:25 Atsushi Torikoshi (atsushitorikoshi) New status: Waiting on Author
2022-08-22 14:13:11 Atsushi Torikoshi (atsushitorikoshi) Added atsushitorikoshi as reviewer
2022-08-16 13:32:32 Damir Belyalov (xhevx) Changed reviewers to
2022-08-16 13:32:32 Damir Belyalov (xhevx) Changed authors to Damir Belyalov (xhevx)
2022-08-16 13:32:32 Damir Belyalov (xhevx) Changed targetversion to 15
2022-08-16 13:32:32 Damir Belyalov (xhevx) Changed gitlink to https://github.com/xhevfx/postgres/tree/copy_ignore_errors1
2022-08-16 13:32:32 Damir Belyalov (xhevx) Changed wikilink to https://wiki.postgresql.org/wiki/Todo#COPY
2022-08-16 13:29:46 Atsushi Torikoshi (atsushitorikoshi) Added atsushitorikoshi as reviewer
2022-08-16 13:27:11 Damir Belyalov (xhevx) Attached mail thread 1197371508.4255.1327.camel@ebony.site
2022-08-16 13:27:10 Damir Belyalov (xhevx) Created patch record
Edit