[Tickets #10919] Re: Postgresql 9.0 bytea output is hex and should be escape

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/10919
------------------------------------------------------------------------------
  Ticket             | 10919
  Updated By         | Michael Slusarz <slusarz at horde.org>
  Summary            | Postgresql 9.0 bytea output is hex and should be escape
  Queue              | Horde Base
  Version            | 4.0.13
  Type               | Bug
-State              | Assigned
+State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Slusarz
------------------------------------------------------------------------------


Michael Slusarz <slusarz at horde.org> (2012-01-27 01:26) wrote:

> In PostgreSQL 9.xx bytea values have hex as default output, but  
> horde expects escape.  
> (http://www.postgresql.org/docs/9.0/static/release-9-0.html)

No.  We don't expect anything.  PDO handles result parsing.

We have unit tests that test exactly this and they work fine.

> With "ALTER DATABASE horde SET bytea_output = 'escape'; " you can  
> change the output postgresql uses.

No.  We don't care what the output is - that is for PDO to worry  
about.  The only thing we care about is how to insert data into the  
DB.  And as is clearly discussed from that above page:

The bytea type always accepts both formats on input, regardless of  
this setting.

You are going to have to come up with a failing unit test to prove otherwise.