pg.ddx.io  pgsql-testers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (2+ messages)

Message-ID: <6A041CDC7BD1408E90CB8C679A9C444E@Gateway>
Permalink:  ../6A041CDC7BD1408E90CB8C679A9C444E@Gateway/
Also on:    postgresql.org/message-id/6A041CDC7BD1408E90CB8C679A9C444E@Gateway

 · 

reply

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