[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         | Michael Slusarz <slusarz 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           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Slusarz
------------------------------------------------------------------------------


Michael Slusarz <slusarz at horde.org> (2011-11-28 22:10) wrote:

> I'm not looking at the code right now, but shouldn't this only  
> happen with BLOB fields? pref_value is a TEXT field though.

No it isn't.  Or at least it shouldn't be.  Postgresql can't handle  
PHP serialized data in a TEXT field - it requires a BLOB/BYTEA.  If  
this has been changed recently, this is a *major* regression.  See Bug  
#8130.

My prefs table is set for bytea data.