[Tickets #10803] Re: Errors in various variables with horde_db 1.1.2 & postgresql 9.1.1

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/10803
------------------------------------------------------------------------------
  Ticket             | 10803
  Updated By         | Jan Schneider <jan at horde.org>
  Summary            | Errors in various variables with horde_db 1.1.2 &
                     | postgresql 9.1.1
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | Feedback
  Priority           | 3. High
  Milestone          | Horde 4.0.13
  Patch              |
-Owners             |
+Owners             | Horde Developers, Chuck Hagenbuch, Jan Schneider,
                     | Michael Slusarz
------------------------------------------------------------------------------


Jan Schneider <jan at horde.org> (2011-12-06 20:12) wrote:

It was probably overlooked during the change to migrations, that at  
some minor release the pref_value field was changed to BYTEA for  
Postrgres only. This left our databases a bit inconsistent, because  
the other DBs continued to use TEXT fields.
Theoretically this could be solved by migrating pref_value to  
"binary", though I'm not sure how well this handled by the databases  
and out drivers. I'm going to create a unit test and we need to see  
how that works across databases and versions.