Alan,
> I have tried this delete clause but it generates an error my system:
>
> mysql> DELETE FROM maddr
> -> WHERE NOT EXISTS (SELECT sid FROM msgs WHERE sid=id)
> -> AND NOT EXISTS (SELECT rid FROM msgrcpt WHERE rid=id);
> ERROR 1064: You have an error in your SQL syntax near 'EXI
Mark Martinec wrote the following on 20/06/2005 00:29:
Alan,
> These records are not deleted automatically, they should be removed
by some periodic maintenance script, e.g. by SQL clauses at the end
of docs file README.sql.
Specifically, the clause:
DELETE FROM maddr
WHERE NOT EXISTS (
Alan,
> I've been running with SQl enabled for a few weeks now.
>
> Looking at the maddr table it has thousands of VERP addressed mail records.
>
> I've searched for information on maintaining this table but have yet to
> find it.
>
> Is it intended that Admins delete these records manually or sho
I've been running with SQl enabled for a few weeks now.
Looking at the maddr table it has thousands of VERP addressed mail records.
I've searched for information on maintaining this table but have yet to find it.
Is it intended that Admins delete these records manually or should some other
pr