BUG #3956: COPY FROM doesn't parse file correctly

Lists: pgsql-bugs
From: "Maxim Ivanov" <ivanov(dot)maxim(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3956: COPY FROM doesn't parse file correctly
Date: 2008-02-12 17:36:05
Message-ID: 200802121736.m1CHa5BJ014335@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3956
Logged by: Maxim Ivanov
Email address: ivanov(dot)maxim(at)gmail(dot)com
PostgreSQL version: 8.2.6
Operating system: Fedora i386
Description: COPY FROM doesn't parse file correctly
Details:

COPY FROM couldn't parse file correctly. "\" symbol escapes delimeter. So
string(spaces are tabulation symbols)
11111 AAAAAA BBBBB\ CCCCCC
would be recognized as three field string instead of 4 field.


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Maxim Ivanov" <ivanov(dot)maxim(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3956: COPY FROM doesn't parse file correctly
Date: 2008-02-12 19:59:48
Message-ID: 1466.1202846388@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

"Maxim Ivanov" <ivanov(dot)maxim(at)gmail(dot)com> writes:
> COPY FROM couldn't parse file correctly. "\" symbol escapes delimeter. So
> string(spaces are tabulation symbols)
> 11111 AAAAAA BBBBB\ CCCCCC
> would be recognized as three field string instead of 4 field.

Sounds perfectly correct to me. What were you expecting?

regards, tom lane