pgsql: Add progress reporting of skipped tuples during COPY FROM. - Mailing list pgsql-committers

From Masahiko Sawada
Subject pgsql: Add progress reporting of skipped tuples during COPY FROM.
Date
Msg-id E1rSp2r-002yR2-VR@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add progress reporting of skipped tuples during COPY FROM.

9e2d870119 enabled the COPY command to skip malformed data, however
there was no visibility into how many tuples were actually skipped
during the COPY FROM.

This commit adds a new "tuples_skipped" column to
pg_stat_progress_copy view to report the number of tuples that were
skipped because they contain malformed data.

Bump catalog version.

Author: Atsushi Torikoshi
Reviewed-by: Masahiko Sawada
Discussion: https://postgr.es/m/d12fd8c99adcae2744212cb23feff6ed%40oss.nttdata.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/729439607ad210dbb446e31754e8627d7e3f7dda

Modified Files
--------------
doc/src/sgml/monitoring.sgml         | 12 ++++++++++++
src/backend/catalog/system_views.sql |  3 ++-
src/backend/commands/copyfrom.c      |  5 +++++
src/include/catalog/catversion.h     |  2 +-
src/include/commands/progress.h      |  1 +
src/test/regress/expected/rules.out  |  3 ++-
6 files changed, 23 insertions(+), 3 deletions(-)


pgsql-committers by date:

Previous
From: Thomas Munro
Date:
Subject: pgsql: Track LLVM 18 changes.
Next
From: Thomas Munro
Date:
Subject: pgsql: jit: Require at least LLVM 10.