I came across an issue that looks like a bug in COPY. There are many similar posts, e.g. http://stackoverflow.com/questions/13485030/strange-postgresql-value-too-long-for-type-character-varying500, without a good unswer.
Simplified steps to reproduce the issue:
1. CREATE TABLE TEST (description varchar(10));
2. Insert value 'Galaxy\040Tab' using command COPY TEST(description) FROM stdin WITH DELIMITER '|' CSV.
The following error is returned: value too long for type character varying(10)
Of course real life scenarios are more complex and different characters were used (\042 and \005).
Is this a bug, or an incorrect use of COPY/CSV?
Thank you
Konstantin
