file_fdw: Add on_error and log_verbosity options to file_fdw.

Fujii Masao <fujii@postgresql.org>

Commit: a1c4c8a9e1e3a53996dafa1f4ee6d4f7de2c58b2
Author: Fujii Masao <fujii@postgresql.org>
Date: 2024-10-03T06:57:32Z
Releases: 18.0
file_fdw: Add on_error and log_verbosity options to file_fdw.

In v17, the on_error and log_verbosity options were introduced for
the COPY command. This commit extends support for these options
to file_fdw.

Setting on_error = 'ignore' for a file_fdw foreign table allows users
to query it without errors, even when the input file contains
malformed rows, by skipping the problematic rows.

Both on_error and log_verbosity options apply to SELECT and ANALYZE
operations on file_fdw foreign tables.

Author: Atsushi Torikoshi
Reviewed-by: Masahiko Sawada, Fujii Masao
Discussion: https://postgr.es/m/ab59dad10490ea3734cf022b16c24cfd@oss.nttdata.com

Files

Documentation touched

Discussion