COPY allows parameters which corrupt output

From: Kris Jurka <books(at)ejurka(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: COPY allows parameters which corrupt output
Date: 2004-01-12 18:32:16
Message-ID: Pine.LNX.4.33.0401121326400.10270-200000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches


COPY allows DELIMITER and NULL to be specified which don't allow the data
to be copied back in properly. Using any delimiter that could be part of
a backslash escape sequence (\n \0 \t) will break if any of the data has a
character matching the delimiter because it will be escaped and then be
read as a special character.

It also allows DELIMITER and NULL to overlap. No character in the NULL
specification should be the DELIMITER.

Kris Jurka

Attachment Content-Type Size
copytest.sql text/plain 209 bytes

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-01-12 19:14:53 Re: Assertion failure in current cvs
Previous Message Kris Jurka 2004-01-12 17:55:26 Assertion failure in current cvs

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-01-13 01:31:18 ecpg test
Previous Message Claudio Natoli 2004-01-12 07:46:27 Re: win32 patch: processCancelRequest/reaper (+ various minor cha