COPY FROM IGNORE_ERRORS - ignores rows with errors while copying

Edit

Title

Topic

SQL Commands

Created

2022-08-16 13:27:10

Last modified

2024-01-16 21:38:30 (3 months ago)

Latest email

2024-01-19 14:26:25 (3 months 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

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

Wiki

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