On 6 February 2012 07:37, Lockas <w_ward_w@xxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
