2.4.0-rc5, hopefully the last release candidate

On 3/27/06, Mark Martinec <Mark.Martinec+amavisijs.si> wrote:
> Hopefully the last release candidate before the final
release:
>
>   http://www.ijs.si/software/amavisd/amavisd-new-2.
4.0-rc5.tar.gz
>

It is probably too late to bring up, but instead of adding a
'time_num' column to 'msgrcpt' and 'quarantine'
tables, why not have
the records in these two tables reference the 'msgs' table
using the
'mail_id' as a foreign key? This will enforce the
integrity of the
relationship and will also make purging easier with 'DELETE
FROM ...
CASCADE'.

Something I am missing? Thanks.


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking
scripting language
that extends applications into web and mobile media. Attend
the live webcast
and join the prime developer group breaking into this new
coding territory!
http:
//sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$
1720&dat1642
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user

AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/

> > Hopefully the last release candidate before the
final release:

I guess not, here is the next one, sorry:

  http://www.ijs.si/software/amavisd/amavisd-new-2.
4.0-rc6.tar.gz

From Brian Wong:
> It is probably too late to bring up, but instead of
adding a
> 'time_num' column to 'msgrcpt' and 'quarantine'
tables, why not have
> the records in these two tables reference the 'msgs'
table using the
> 'mail_id' as a foreign key? This will enforce the
integrity of the
> relationship and will also make purging easier with
'DELETE FROM ...
> CASCADE'. Something I am missing? Thanks.

There is always time to teach old dog new tricks 

If using SQL logging or quarantine please see if you like
the
new FOREIGN KEY constraing and the simplifications it puts
to database purging better than the time_num filed that
was used in pre-release and RC version of 2.4.0 so far.
The change is documented in the beginning of RELEASE_NOTES
and also in README.sql.

If there will be a grand objection, I'll put the time_num
back in
tables msgrcpt and quarantine tables, although having these
two
fields indexed imposes additional burden on inserts and
deletes.

Besides the above, it fixes few per-recip macro values when
$log_recip_templ
is in use for better per-recip logging, and makes
$sa_timeout somewhat 
redundant.

  Mark




-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking
scripting language
that extends applications into web and mobile media. Attend
the live webcast
and join the prime developer group breaking into this new
coding territory!
http:
//sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$
1720&dat1642
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user

AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/