Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id BD32B133862A for ; Thu, 14 Oct 2010 06:07:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 47729-05-5 for ; Thu, 14 Oct 2010 09:07:24 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 7925B1337CDE for ; Wed, 13 Oct 2010 18:29:07 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.4/8.14.4) with ESMTP id o9DLT6vI099053 for ; Wed, 13 Oct 2010 18:29:06 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.4/8.14.4/Submit) id o9DL3iDt072476 for pgsql-general@postgresql.org; Wed, 13 Oct 2010 18:03:44 -0300 (ADT) (envelope-from news) From: ljb X-Newsgroups: pgsql.general Subject: Re: Gripe: bytea_output default => data corruption Date: Wed, 13 Oct 2010 21:03:43 +0000 (UTC) Organization: Hub.Org Networking Services Lines: 12 Message-ID: References: <4CB563B6.8020803@iol.ie> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: slrn/0.9.9p1 (Linux) To: pgsql-general@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-5 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201010/485 X-Sequence-Number: 168397 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.