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-03-06 14:03:56 (2 weeks, 1 day ago)

Latest email

2023-03-17 12:23:14 (4 days, 15 hours ago)

Status

2023-03: Waiting on Author

2023-01: Moved to next CF

2022-11: Moved to next CF

2022-09: Moved to next CF

Target version

Authors

Damir Belyalov (xhevx)

Reviewers

Atsushi Torikoshi (atsushitorikoshi)Become reviewer

Committer

Links

Wiki Git

Emails

VLDB Features: First at 2007-12-11 11:11:48 by Simon Riggs <simon at 2ndquadrant.com>
Latest at 2023-03-17 12:23:14 by torikoshia <torikoshia at oss.nttdata.com>
Latest 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>
    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-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