Based on a couple of other posts, I think I'm out of luck, but I'm hoping something might have changed recently. I'm loading a very high volume of data with COPY using libpq - about 100+ million rows per day. The problem is that the COPY sometimes aborts with invalid UTF-8 byte sequence detected I'd prefer not to add to the overhead by pre-validating every string, since PostgreSQL validates it already. Is there a way to get the server to replace invalid characters with something like blank instead of generating a fatal error? Wes
