file_fdw: Add on_error and log_verbosity options to file_fdw.
authorFujii Masao <fujii@postgresql.org>
Thu, 3 Oct 2024 06:57:32 +0000 (15:57 +0900)
committerFujii Masao <fujii@postgresql.org>
Thu, 3 Oct 2024 06:57:32 +0000 (15:57 +0900)
commita1c4c8a9e1e3a53996dafa1f4ee6d4f7de2c58b2
treec434f3b85d9091c7512e3b891525d6f9744b653f
parente7834a1a251d4a28245377f383ff20a657ba8262
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
contrib/file_fdw/expected/file_fdw.out
contrib/file_fdw/file_fdw.c
contrib/file_fdw/sql/file_fdw.sql
doc/src/sgml/file-fdw.sgml