From: Mark Watson <mark.watson@jurisconcept.ca>
To: pgsql-testers@postgresql.org
Subject: Re: bytea_output
Date: Fri, 6 Aug 2010 09:46:57 -0400
Message-ID: <6A041CDC7BD1408E90CB8C679A9C444E@Gateway> (raw)
In-Reply-To: <CBF9F95B81C54E11A1E7550580943B46@Gateway>
References: <CBF9F95B81C54E11A1E7550580943B46@Gateway>
>Hello testers,
>I have installed 9.0 beta 4 using the one click installer for windows 32
bit and running under Vista and used the default install directories. I
noticed that bytea output was in hex using my client application and also
using pgAdmin 1.12.0 beta 4, so I changed the config file to bytea_output =
'escape' (removing the # comment symbol of course). I stopped and restarted
the service, and the output is still in hex.
>
>Mark Watson
Additional info : After dropping and restoring the database, while
bytea_output is configured as 'escape', the data is presented correctly.
When restoring an 8.4.4 database, it appears that pg_restore does not
correctly convert bytea from escape to hex if the config file containg
bytea_output = 'hex'
-Mark
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.851 / Virus Database: 271.1.1/3051 - Release Date: 08/05/10
02:35:00
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-testers@postgresql.org
Cc: mark.watson@jurisconcept.ca
Subject: Re: bytea_output
In-Reply-To: <6A041CDC7BD1408E90CB8C679A9C444E@Gateway>
References: <CBF9F95B81C54E11A1E7550580943B46@Gateway> <6A041CDC7BD1408E90CB8C679A9C444E@Gateway>
* 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