The mailing list for listmasters using Sympa

[Øyvind Kolbu <address@concealed>]

Hi,

we are having problems with lists which have many lists as data sources,
and where some subscribers are subscribed to many of the data sources.

The include_sources_subscriber field in the database, we are running
PostgreSQL, is a varchar(50). That limits the maximum subscribtions
to 5 list references, as each list is a 8 char reference, and a comma
is placed between each reference.

Any reason why this field is limited to 50 chars? All sql schemas in the
source have this limitation, except for SQLite where the field is «text».
Could this field be changed to «text» or just bumped to a much larger
value?

To resolve our problems we will alter it to 256 in our database. Are there
any fallouts we can expect from that?

Example error message:
Jan 22 12:22:47 mail-imap3 task_manager[17773]: List::add_user() Unable to
execute SQL statement "INSERT INTO subscriber_table (user_subscriber,
comment_subscriber, list_subscriber, robot_subscriber, date_subscriber,
update_subscriber, reception_subscriber, topics_subscriber,
visibility_subscriber,subscribed_subscriber,included_subscriber,include_sources_subscriber,custom_attribute_subscriber)
VALUES ('address@concealed', NULL, 'interne', 'rf.uio.no',
'epoch'::timestamp with time zone + '1264159367 sec', 'epoch'::timestamp
with time zone + '1264159367 sec', 'mail', NULL, 'noconceal', 0, 1,
'c824abc3,be8b62b0,2e9733f0,fba6fb25,5e6e1177,30654a52,f874e3fe,ef31978e,be39b71f,8f54fb52,f57c98d3,e502df31,cf2bad0c',
'<?xml version="1.0" encoding="UTF-8" 
?><custom_attributes></custom_attributes>')"
: ERROR:  value too long for type character varying(50)


-- 
Øyvind Kolbu
Postmaster
Universitetet i Oslo

Attachment: pgpksSSB249jK.pgp
Description: PGP signature