Doug,

Perhaps the maintenance script could also be modified to allow user-modifiable SQL statements. For example,

DELETE FROM sometable WHERE deleted='1' AND TIMESTAMP<"%s"

That way, it'd only delete mail that was older than a certain date AND deleted...

(excuse my SQL, it's a second language..)

Doug Stanley wrote:

Are any of you using the dbmail system at a larger university? Or even a small university? I suggested using it here for our computer science deptartment, but the big thing stopping us was that professors often "accidentally" delete mail they didn't want to so we have to go in and get their mail file from tape backups...

I think dbmail would actually be better in this case cause we could just
change the mail deleted flag in the db...as long as we only run the
maintanence script pretty rarely...anyways...I'm just curious if anyone
out there is actually using this at a university setting where people
do stupid things to their mail...

Doug

_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail



Reply via email to