Re: Fixing backslash dot for COPY FROM...CSV - Mailing list pgsql-hackers

From Daniel Verite
Subject Re: Fixing backslash dot for COPY FROM...CSV
Date
Msg-id 4ffb7317-7e92-4cbd-a542-1e478af6ad5d@manitou-mail.org
Whole thread Raw
In response to Re: Fixing backslash dot for COPY FROM...CSV  (Sutou Kouhei <kou@clear-code.com>)
Responses Re: Fixing backslash dot for COPY FROM...CSV
List pgsql-hackers
    Sutou Kouhei wrote:

> BTW, here is a diff after pgindent:

PFA a v5 with the cosmetic changes applied.

> I also confirmed that the updated server and non-updated
> psql compatibility problem (the end-of-data "\." is
> inserted). It seems that it's difficult to solve without
> introducing incompatibility.

To clarify the compatibility issue, the attached bash script
compares pre-patch and post-patch client/server combinations with
different cases, submitted with different copy variants.

case A: quoted backslash-dot sequence in CSV
case B: unquoted backslash-dot sequence in CSV
case C: CSV without backslash-dot
case D: text with backslash-dot at the end
case E: text without backslash-dot at the end

The different ways to submit the data:
copy from file
\copy from file
\copy from pstdin
copy from stdin with embedded data after the command

Also attaching the tables of results with the patch as it stands.
"Failed" is when psql reports an error and "Data mismatch"
is when it succeeds but with copied data differing from what was
expected.

Does your test has an equivalent in these results or is it a different
case?



Best regards,
--
Daniel Vérité
https://postgresql.verite.pro/
Twitter: @DanielVerite
=======================

Attachment

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: pg_upgrade failing for 200+ million Large Objects
Next
From: Alexander Korotkov
Date:
Subject: Re: Assertion failure with summarize_wal enabled during pg_createsubscriber