The is_header patch hasn't been committed to the 2_0 codebase, but the patch has
been in the debian packages since last summer.
Aaron Stone wrote:
I thought some more about the is_header thing, and realized two issues:
1) My complaint against not being able to downgrade and upgrade freely is
10% valid and 90% ridiculous.
2) We should add a check to dbmail-util that can repair incorrect
is_header markings.
This is essentially a one-shot deal, but omni-potent. Meaning: you only have to
run it once, but running more than once won't do you any harm.
I wrote a little shell script that did the trick using bash/awk. It updated my
100k messageblk database in just a couple of minutes.
The idea is to generate *efficient* update queries, in stead of doing a single
query per messageblk_idnr.
mysql --skip-column-names -B -e "select dbmail_messageblk_idnr from messageblks
group by physmessage_id" dbmail |\
awk 'BEGIN { printf("\nupdate dbmail_messageblks set is_header=1 where
messageblk_idnr in ("); } { if(NR % 200 == 0) { printf("\nupdate
dbmail_messageblks set is_header=1 where messageblk_idnr in ("); i=0; } else {
printf("%s,",$1); }}' |\
sed 's/,$/);/'
1+2) The 10% validity of my complaint is alleviated by an attentive mail
administrator who runs dbmail-util on a regular basis. So the worst case
is that a few pieces of mail are inaccessible until the next run of
dbmail-util.
So do a stepped phase-in:
2.0.2: Apply the is_header patch so new messageblks always get flagged
correctly, and provide a dbmail-util switch to convert the old messageblks.
2.0.3: Start using the field in the retrieval chain.
Was I the only objector to rolling in is_header support? If so, let's do
this thing for 2.0.2 or 2.0.3!
Aaron
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
