[Tickets #2512] NEW: Table creation script for Postgres undersizes object_members

[bugs@bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=2512
-----------------------------------------------------------------------
 Ticket             | 2512
 Created By         | iviemeister at nutleyschools.org
 Summary            | Table creation script for Postgres undersizes object_members
 Queue              | Turba
 Version            | HEAD
 State              | Unconfirmed
 Priority           | 2. Medium
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


iviemeister at nutleyschools.org (2005-08-24 19:57) wrote:

turba_objects.pgsql.sql adds object_members using:

object_members VARCHAR(4096)

Thus limiting the maximum number of addresses in a list to 90, due to each
contact on the list using 32 bytes for the object_id, plus the serialize
overhead.

I'd suggest either using TEXT as a much closer match to the BLOB types used
by the other sql scripts, or making the default much higher than 4k.