Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 50A84632C3F for ; Fri, 6 Aug 2010 10:46:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 27254-07 for ; Fri, 6 Aug 2010 13:46:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outboundmta02.oricom.ca (outboundmta02.oricom.ca [64.18.160.77]) by mail.postgresql.org (Postfix) with ESMTP id 83B4463284C for ; Fri, 6 Aug 2010 10:46:12 -0300 (ADT) X-ASG-Debug-ID: 1281102369-4b22cfed0001-ovxuox Received: from Gateway (static-dslcom3-026.express.oricom.ca [64.18.178.26]) by outboundmta02.oricom.ca with ESMTP id DLLZup59mvlGsief for ; Fri, 06 Aug 2010 09:46:09 -0400 (EDT) X-Barracuda-Envelope-From: mark.watson@jurisconcept.ca X-Barracuda-Apparent-Source-IP: 64.18.178.26 From: "Mark Watson" To: References: In-Reply-To: Subject: Re: bytea_output Date: Fri, 6 Aug 2010 09:46:57 -0400 X-ASG-Orig-Subj: RE: [TESTERS] bytea_output Message-ID: <6A041CDC7BD1408E90CB8C679A9C444E@Gateway> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003D_01CB354C.4FA59770" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18197 Thread-Index: Acs1ZlmGq9KeUIMfR3C1Bex5ML/GCgAAqjww X-Barracuda-Connect: static-dslcom3-026.express.oricom.ca[64.18.178.26] X-Barracuda-Start-Time: 1281102369 X-Barracuda-URL: http://64.18.160.77:8000/cgi-mod/mark.cgi X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=5.0 tests=HTML_MESSAGE X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.2.37202 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- 0.00 HTML_MESSAGE BODY: HTML included in message X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201008/10 X-Sequence-Number: 165 This is a multi-part message in MIME format. ------=_NextPart_000_003D_01CB354C.4FA59770 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit >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 ------=_NextPart_000_003D_01CB354C.4FA59770 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

 

>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 =3D '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 =3D = ‘hex’

-Mark<= /span>

 

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

------=_NextPart_000_003D_01CB354C.4FA59770--