Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id EC9141337BD9 for ; Thu, 14 Oct 2010 06:50:06 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 26525-05 for ; Thu, 14 Oct 2010 09:49:58 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail1.hosting.digiweb.ie (mail1.hosting.digiweb.ie [89.234.64.49]) by mail.postgresql.org (Postfix) with SMTP id 7028B13380B2 for ; Thu, 14 Oct 2010 06:15:51 -0300 (ADT) Received: (qmail 15585 invoked by uid 399); 14 Oct 2010 09:13:52 -0000 Received: from unknown (HELO ?127.0.0.1?) (ray@teladesign.ie@86.43.79.16) by mail1.hosting.digiweb.ie with SMTP; 14 Oct 2010 09:13:52 -0000 X-Originating-IP: 86.43.79.16 Message-ID: <4CB6CA42.2020305@iol.ie> Date: Thu, 14 Oct 2010 10:15:46 +0100 From: Raymond O'Donnell Reply-To: rod@iol.ie User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.2.4) Gecko/20100608 Lightning/1.0b2 Thunderbird/3.1 MIME-Version: 1.0 To: ljb CC: pgsql-general@postgresql.org Subject: Re: Gripe: bytea_output default => data corruption References: <4CB563B6.8020803@iol.ie> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 101013-1, 13/10/2010), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201010/497 X-Sequence-Number: 168409 On 13/10/2010 22:03, ljb wrote: > rod@iol.ie wrote: >> ... >> In fairness, it *is* flagged in the release note - it's the first item >> under "data types" in the list of incompatibilities. > > Quote: > "bytea output now appears in hex format by default (Peter Eisentraut) > The server parameter bytea_output can be used to select the > traditional output format if needed for compatibility." > > This is inadequate, because it fails to warn that pre-9.0 clients will > decode the data incorrectly without reporting an error. I thought myself that the word "incompatibility" was fairly self-explanatory... :-) Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie