| 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 |
| 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 |
| 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 |