Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: cf/4817~1
Choose a base ref
...
head repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: cf/4817
Choose a head ref
  • 2 commits
  • 9 files changed
  • 2 contributors

Commits on Oct 13, 2025

  1. COPY FROM (on_error table) 

    the syntax is {on_error table, table error_saving_tbl}.  we first check table
error_saving_tbl's existence and data definition.  if it does not meet our
criteria, then we quickly error out.

we also did preliminary check the lock of error saving table so the insert to
error saving table won't stuck.

once there is a error happened, we save the error metedata and insert it to the
error_saving_table. and continue to the next row.
error_saving_table might not store every invalid column value information from
the input row, but since it already keeps the raw_field_value, we can use that
for further inspection.

discussion: https://postgr.es/m/CACJufxH_OJpVra%3D0c4ow8fbxHj7heMcVaTNEPa5vAurSeNA-6Q%40mail.gmail.com
context:    https://www.postgresql.org/message-id/752672.1699474336%40sss.pgh.pa.us
commitfest: https://commitfest.postgresql.org/51/4817
    @jianhe-fun
    jianhe-fun authored and Commitfest Bot committed Oct 13, 2025
    Configuration menu
    Copy the full SHA
    3697bb5 View commit details
    Browse the repository at this point in the history

  2. [CF 4817] v6 - on_error table, saving error info to a table 

    This branch was automatically generated by a robot using patches from an
email thread registered at:

https://commitfest.postgresql.org/patch/4817

The branch will be overwritten each time a new patch version is posted to
the thread, and also periodically to check for bitrot caused by changes
on the master branch.

Patch(es): https://www.postgresql.org/message-id/CACJufxEo-rsH5v__S3guUhDdXjakC7m7N5wj=mOB5rPiySBoQg@mail.gmail.com
Author(s): jian he
    Commitfest Bot committed Oct 13, 2025
    Configuration menu
    Copy the full SHA
    3b83f14 View commit details
    Browse the repository at this point in the history
Loading