Bad rows
By default one bad row aborts the whole COPY. ON_ERROR ignore skips rows that fail input conversion and loads the rest. Skipped rows are counted in a notice.
task
readings_bad.csv has 8 bad rows. Load the good ones into rd and skip the rest.