Bug #48919 for DBD-PgPP: probably bug

Fri Aug 21 16:27:47 2009 Marco.Angeli [...] ascot.tn.it - Ticket created

Subject:	probably bug
Date:	Fri, 21 Aug 2009 22:27:42 +0200
To:	bug-DBD-PgPP [...] rt.cpan.org
From:	Marco.Angeli [...] ascot.tn.it

Download segnalazione bug PgPP.rar
application/octet-stream 357.1k

Message body not shown because it is not plain text.

I send a report of bug (IMHO). I'm waiting about information. thank's. Bye. --------------------------------------------- Angeli Marco Ascot s.r.l. Via Segantini 5 - 38100 TRENTO tel 0461277000 fax 0461987080 --------------------------------------------- AVVISO DI RISERVATEZZA Il testo e gli eventuali documenti trasmessi contengono informazioni riservate al destinatario indicato. La seguente e-mail è confidenziale e la sua riservatezza è tutelata legalmente dalle normative vigenti. La lettura, copia od altro uso non autorizzato o qualsiasi altra azione derivante dalla conoscenza di queste informazioni sono rigorosamente vietate. Se si ritiene di non essere il destinatario di questa mail, o se si è ricevuto questa mail per errore, si prega di darnei mmediata comunicazione al mittente e di provvedere immediatamente alla sua distruzione. PRIVACY NOTICE The information contained in this transmittal, including any attachments hereto, are confidential and privileged, and intended solely for the specified addressee(s). This e-mail has a confidential nature which is protected by the Italian law. Moreover, the recipient(s) may not disclose, forward, or copy this e-mail or attachments, or any portion thereof, or permit the use of this information, by anyone not entitled to it, or in a way that may be damaging to the sender. If you are not the intended addressee, or if you receive this message by error, please notify the sender and delete this information from your computer.

Sat Aug 29 09:37:21 2009 cpan [...] aaroncrane.co.uk - Correspondence added

Hi, Marco. First, thanks very much for taking the trouble to report this. However, it's quite hard for me to use this bug report. In particular, I don't have the database schema that your test program requires. For future reference, it would have been much easier for me if I'd had a simple test case with no external dependencies. Also, burying the details of the problem you've seen in an OpenOffice document inside a tarball makes it hard to even see what happened. Putting the same text into the bug report itself would have helped me. In this case, the output that you quote in the OpenOffice document says exactly what the problem is: "Cannot quote values containing \0 bytes". That is, your data file contains \0 bytes, and the current version of PgPP refuses to quote values that contain them. That refusal is based on my reading of the PostgreSQL manual as saying that \0 bytes are forbidden in strings. That reading turns out to be slightly incorrect; they're forbidden in string literals, but not (entirely) in strings themselves. I've pushed out a 0.07 release that changes the behaviour here. However, I should point out that your code almost certainly has a bug in it: strings containing \0 don't really work well in PostgreSQL. If you need to store binary data, use bytea instead.

Sat Aug 29 09:37:22 2009 The RT System itself - Status changed from 'new' to 'open'

Sat Aug 29 09:37:23 2009 cpan [...] aaroncrane.co.uk - Status changed from 'open' to 'resolved'