From: Bruce Momjian <bruce@momjian.us>
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
Cc: ljb <ljb9832@pobox.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Gripe: bytea_output default => data corruption
Date: Thu, 21 Oct 2010 17:29:11 -0400 (EDT)
Message-ID: <201010212129.o9LLTBl21612@momjian.us> (raw)
In-Reply-To: <AANLkTi=SH6s3FcsCf0quZm09-XgncTnQPR18-Z6GVqsU@mail.gmail.com>
Rajesh Kumar Mallah wrote:
> Dear Griper!,
>
> fortunately someone showed a easy 'fix'
>
> ALTER DATABASE foo SET bytea_output='escape' ;
Yes, we mentioned that setting in the release notes too:
E.2.3.5. Data Types
*
Allow bytea values to be written in hex notation (Peter
Eisentraut)
The server parameter bytea_output controls whether hex or
traditional format is used for bytea output. Libpq's PQescapeByteaConn()
function automatically uses the hex format when connected to PostgreSQL
9.0 or newer servers.
The new hex format will be directly compatible with more
applications that use binary data, allowing them to store and retrieve
it without extra conversion. It is also significantly faster to read and
write than the traditional format.
While the "Incompatibilities" section mentions only the first paragraph,
this remention lower down has even more details. Not sure what else you
wanted us to do.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, mallah.rajesh@gmail.com, ljb9832@pobox.com, pgsql-general@postgresql.org
Subject: Re: Gripe: bytea_output default => data corruption
In-Reply-To: <201010212129.o9LLTBl21612@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox