The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Hi,

no , no troubles will come friom your extension to 256 characters.

Actullay, it's a very good point you make. it is dumb to limitate 
insclusion usage because of this fiels size.

I'l extent it in the 6.0 branch and the development trunk.

Cheers,

David

Le 22/01/2010 13:18, Øyvind Kolbu a écrit :
> 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)
>
>
>    

--
David Verdin
Comité réseau des universités