and, moving to amavis list, sorry.
McDonald, Dan wrote:
> On Mon, 2009-09-28 at 16:52 -0400, Michael Scheidell wrote:
>
>> I sent this to our support group, but looks like there can be some
>> issues, and maybe a better way.
>>
>
> Wrong list - this is an amavisd question....
>
>
>> while there cannot be a duplicate id:
>>
>> (maddr id = 5) can't exist in partition_tag 23 AND 24,
>>
>
> There can be, if you have your schema built properly.
>
schema examples in README.sql-mysql don't show this. (by the way, I
checked our archive gui report, and there were 3 different sid's for
same email address, in three partitions, and our gui found them.. but...
still concerned)
even with partition_tags as part of all primary or unique keys, (as is
needed for partitioning), best I can come up with still WON'T allow
duplicate maddr id's.
SHOULD it allow duplicate maddr id's?
maddr | CREATE TABLE `maddr` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`partition_tag` int(11) NOT NULL DEFAULT '0',
`email` varbinary(255) DEFAULT NULL,
`domain` varchar(255) NOT NULL,
PRIMARY KEY (`id`,`partition_tag`),
UNIQUE KEY `maddr_idx_tag_email` (`partition_tag`,`email`),
KEY `maddr_idx_domain` (`domain`)
) ENGINE=InnoDB AUTO_INCREMENT=9653502 DEFAULT CHARSET=latin1 |
>> the email address CAN exist in multiple partitions, is this the
>> intended results?
>>
>
> Yes. That way you can blithely purge an entire partition and maintain
> referential integrity.
>
>
>
--
Michael Scheidell, CTO
Phone: 561-999-5000, x 1259
> *| *SECNAP Network Security Corporation
* Certified SNORT Integrator
* 2008-9 Hot Company Award Winner, World Executive Alliance
* Five-Star Partner Program 2009, VARBusiness
* Best Anti-Spam Product 2008, Network Products Guide
* King of Spam Filters, SC Magazine 2008
_________________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r).
For Information please see http://www.spammertrap.com
_________________________________________________________________________
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
