Postgres Pro
Downloads
Home   >   mailing lists

Help with COPY Error: invalid UTF-8 byte .... - Mailing list pgsql-general

From Alex
Subject Help with COPY Error: invalid UTF-8 byte ....
Date
Msg-id 438B1069.8070905@meerkatsoft.com
Whole thread Raw
Responses Re: Help with COPY Error: invalid UTF-8 byte ....  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
Hi,
I am having a problem with a copy command, saying ERROR: invalid UTF-8
byte sequence detected...

The problem actually is that the entire copy job terminates instead of
just ignoring the record in question.

Is there a way to have faulty records ignored only without terminating
the entire copy job?

Alex

pgsql-general by date:

Previous
From: "Peter Filipov"
Date:
Subject: strange behaviour in plpgsql:null arguments
Next
From: Tom Lane
Date:
Subject: Re: Errors with temporary tables