6.0.0-beta1
8/11/25

[#2512] Table creation script for Postgres undersizes object_members
Summary Table creation script for Postgres undersizes object_members
Queue Turba
Queue Version HEAD
Type Bug
State Resolved
Priority 2. Medium
Owners
Requester iviemeister (at) nutleyschools (dot) org
Created 08/25/2005 (7291 days ago)
Due
Updated 08/25/2005 (7291 days ago)
Assigned
Resolved 08/25/2005 (7291 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
08/25/2005 07:45:15 AM Jan Schneider Comment #2
State ⇒ Resolved
Reply to this comment
Changed to TEXT.
08/25/2005 02:57:29 AM iviemeister (at) nutleyschools (dot) org Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Table creation script for Postgres undersizes object_members
Queue ⇒ Turba
Reply to this comment
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.


Saved Queries