Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row

jian he <jian.universality@gmail.com>

From: jian he <jian.universality@gmail.com>

To: Jim Jones <jim.jones@uni-muenster.de>

Cc: "David G. Johnston" <david.g.johnston@gmail.com>, Yugo NAGATA <nagata@sraoss.co.jp>, torikoshia <torikoshia@oss.nttdata.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2024-08-26T00:00:00Z

Lists: pgsql-hackers

Attachments

v3-0001-on_error-set_to_null.patch (text/x-patch) patch v3-0001

hi all.
patch updated.
simplified the code a lot.

idea is same:
COPY t_on_error_null FROM STDIN WITH (on_error set_to_null);

If the STDIN number of columns is the same as the target table, then
InputFunctionCallSafe
call failure will make that column values be null.


If the STDIN number of columns is not the same as the target table, then error
ERROR:  missing data for column \"%s\"
ERROR:  extra data after last expected column
which is status quo.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

file_fdw: Add regression test for file_fdw with ON_ERROR='set_null'
- d8879d34b9dd 19 (unreleased) landed
Add COPY (on_error set_null) option
- 2a525cc97e19 19 (unreleased) landed
Add REJECT_LIMIT option to the COPY command.
- 4ac2a9beceb1 18.0 cited
Add log_verbosity = 'silent' support to COPY command.
- e7834a1a251d 18.0 cited
Add new COPY option LOG_VERBOSITY.
- f5a227895e17 17.0 cited