Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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: copytest.sql
Description: text/plain (209 bytes)

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-01-12 19:14:53
Subject: Re: Assertion failure in current cvs
Previous:From: Kris JurkaDate: 2004-01-12 17:55:26
Subject: Assertion failure in current cvs

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group