Paul J Stevens wrote: > Larry Rosenman wrote: >> >> I want to basically make the whole hierarchy under the >> MAIL-ARCHIVE/yyyy/mm, I.E. MAIL-ARCHIVE/2006/11/lists/pgsql/hackers >>> From when it was ~/Mail/lists/pgsql/hackers >> >> (and, yes, this would be on PostgreSQL). > > That's even easier: > > update dbmail_mailboxes > set name= regexp_replace(name,'^','MAIL-ARCHIVE/' || > to_char(current_timestamp,'YYYY/mm/')) > where name not like 'MAIL-ARCHIVE%' > and owner_idnr=( > select user_idnr from dbmail_users where userid='testuser1' > );
Thanks, Paul. I was trying(!) to do it via the IMAP daemon, and failing. Is this "officially" supported to hack on the database? Also, this seems to mean if one of my users wanted to do similar things, they'd have to ask me to do the SQL stuff in the DB. Also, is there any particular reason the dbmail_mailboxes.name column is limited to 100 characters? Thanks! LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: [email protected] US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
