Re: Approval of duplicate message ids

Tom Lane wrote:
> Last night, somebody seems to approved a bucketload of duplicate
> messages to pgsql-general, which judging from their headers were all
> injected by the same mail-agent fart at deltacom.com a couple of days
> ago.  I know that the mail list software recognized these as duplicates,
> because back when it happened I got bounces related to the ones that had
> originally been from me.  But apparently, nonetheless they went into the
> moderation queue and somebody whose sense of deja vu wasn't strong
> enough eventually approved them.

Yeah, apparently a moderator messed up.

I removed the deltacom.com subscriber the day you reported it.  (I
forgot to reply here, sorry.)

> Why is that?  Why aren't duplicate messageids/checksums rejected out of
> hand?  Or at least clearly flagged to the moderators as something they
> should almost certainly reject not approve?

I don't think there's any reason why we don't reject duplicates.  I just
copied the setting from the older system without thinking very much
about it.

> [ looks a bit closer... ]  Also, it might be a good idea to summarily
> block mail.deltacom.com until they fix their problem, because it looks
> like there was a second batch of dups submitted yesterday.

Not sure about this.  If we see a problem again, I will look into that.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services