COPY FROM IGNORE_ERRORS - ignores rows with errors while copying

Edit

Title

Topic

SQL Commands

Created

2022-08-16 13:27:10

Last modified

2023-11-15 20:29:12 (2 weeks ago)

Latest email

2023-11-24 03:52:25 (5 days, 20 hours ago)

Status

2023-11: Ready for Committer

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

Links

Wiki

Emails

VLDB Features: First at 2007-12-11 11:11:48 by Simon Riggs <simon at 2ndquadrant.com>
Latest at 2023-11-24 03:52:25 by Andrei Lepikhov <a.lepikhov at postgrespro.ru>
Latest 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>
    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
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