Re: [GENERAL] bug in COPY implementation (all versions of Postgres)?

2013-04-06 Thread Jasen Betts
On 2013-04-05, Konstantin Izmailov pgf...@gmail.com wrote: 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) CSV is essentially a binary format. there is no

[GENERAL] bug in COPY implementation (all versions of Postgres)?

2013-04-04 Thread Konstantin Izmailov
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

Re: [GENERAL] bug in COPY implementation (all versions of Postgres)?

2013-04-04 Thread Ian Lawrence Barwick
2013/4/5 Konstantin Izmailov pgf...@gmail.com: 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