Re: [BUGS] BUG #2114: (patch) COPY FROM ... end of copy - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: [BUGS] BUG #2114: (patch) COPY FROM ... end of copy
Date
Msg-id 43B154DC.8090100@dunslane.net
Whole thread Raw
In response to Re: [BUGS] BUG #2114: (patch) COPY FROM ... end of copy marker corrupt  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [BUGS] BUG #2114: (patch) COPY FROM ... end of copy marker
List pgsql-patches

Bruce Momjian wrote:

> The big problem is that \. is also a valid
>CSV data value (though not a valid non-CSV data value).  So, the
>solution we came up with was to require \. to appear alone on a line in
>CSV mode for it to be treated as end-of-copy.
>

According to the docs, that's the way to specify EOD in both text and
CSV mode:

  End of data can be represented by a single line containing just
backslash-period.

Your analysis regarding line_buf.len seems correct.

We probably should have a regression test with \. in a CSV field.

cheers

andrew


pgsql-patches by date:

Previous
From: "Pavel Stehule"
Date:
Subject: list of scalars for fors and fore stms II
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] BUG #2114: (patch) COPY FROM ... end of copy marker