dbTalk Databases Forums  

[BUGS] COPY allows parameters which corrupt output

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] COPY allows parameters which corrupt output in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kris Jurka
 
Posts: n/a

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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.