[BUGS] COPY allows parameters which corrupt output -
01-12-2004
, 12:32 PM
This message is in MIME format. The first part should be readable text,
while the remaining parts are likely unreadable without MIME-aware tools.
Send mail to mime (AT) docserver (DOT) cac.washington.edu for more info.
--1866420246-172325938-1073932336=:10270
Content-Type: TEXT/PLAIN; charset=US-ASCII
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
--1866420246-172325938-1073932336=:10270
Content-Type: TEXT/PLAIN; charset=US-ASCII; name="copytest.sql"
Content-Transfer-Encoding: BASE64
Content-ID: <Pine.LNX.4.33.0401121332160.10270 (AT) leary (DOT) csoft.net>
Content-Description:
Content-Disposition: attachment; filename="copytest.sql"
RFJPUCBUQUJMRSBjb3B5dGVzdDsNCg0KQ1JFQVRFIFRBQkxFIG NvcHl0ZXN0
IChhIHRleHQsIGIgdGV4dCk7DQoNCklOU0VSVCBJTlRPIGNvcH l0ZXN0IFZB
TFVFUyAoJ3QsbixnJywnYScpOw0KSU5TRVJUIElOVE8gY29weX Rlc3QgVkFM
VUVTIChOVUxMLE5VTEwpOw0KDQpDT1BZIGNvcHl0ZXN0IFRPIF NURE9VVCBX
SVRIIERFTElNSVRFUiAnbicgTlVMTCAnbic7DQo=
--1866420246-172325938-1073932336=:10270
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
--1866420246-172325938-1073932336=:10270-- |