Re: COPY and custom datestyles. Or some other technique?

Something like this?

ALTER TABLE foo
    ALTER COLUMN update_ts TIMESTAMP WITHOUT TIME ZONE
        USING to_timestamp(update_ts, 'YYYYMMDDHH24miSSMS');

That would definitely minimize the possibility of errors.