pgsql: file_fdw: Add regression test for file_fdw with ON_ERROR='set_nu

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: file_fdw: Add regression test for file_fdw with ON_ERROR='set_nu
Date: 2026-03-16 03:14:21
Message-ID: E1w1yPM-000NGY-2l@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

file_fdw: Add regression test for file_fdw with ON_ERROR='set_null'

Commit 2a525cc97e1 introduced the ON_ERROR = 'set_null' option for COPY,
allowing it to be used with foreign tables backed by file_fdw. However,
unlike ON_ERROR = 'ignore', no regression test was added to verify
this behavior for file_fdw.

This commit adds a regression test to ensure that foreign tables using
file_fdw work correctly with ON_ERROR = 'set_null', improving test coverage.

Author: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Reviewed-by: Yi Ding <dingyi_yale(at)163(dot)com>
Discussion: https://postgr.es/m/CAHGQGwGmPc6aHpA5=WxKreiDePiOEitfOFsW2dSo5m81xWXgRA@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d8879d34b9dd651080a4994b58fd7eb0e5049252

Modified Files
--------------
contrib/file_fdw/expected/file_fdw.out | 12 +++++++++++-
contrib/file_fdw/sql/file_fdw.sql | 4 +++-
2 files changed, 14 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2026-03-16 04:46:58 pgsql: Remove obsolete speculative insert cleanup in ReorderBuffer.
Previous Message Michael Paquier 2026-03-16 00:22:38 pgsql: Optimize hash index bulk-deletion with streaming read