On 6 February 2012 07:37, Lockas <w_ward_w@hotmail.com> wrote:
> I've tried a lot of sizes
> but I still have messages in my log saying:
>
> * ---
> ERROR: value too long for type character varying(200)
> --- *
>
> Why is this? There are no other varchar(200) columns in my DB at all,
> no other table. Only this column used to be 25 characters and using
> the alter type command I changed it to 200. It looks alright, the column
> also
> accepts the value, but the error is logged.
>
> I'm confused. How to stop the error?
Perhaps your CSV file doesn't put each record on a new line or
contains an escape at the end of a line that makes the next line part
of it?
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.