Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U0dYr-00032H-Bl for pgsql-www@arkaria.postgresql.org; Wed, 30 Jan 2013 19:43:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1U0dYq-0001Uo-Eb for pgsql-www@arkaria.postgresql.org; Wed, 30 Jan 2013 19:43:08 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U0dYp-0001Ui-Mv for pgsql-www@postgresql.org; Wed, 30 Jan 2013 19:43:07 +0000 Received: from smtprelay0181.b.hostedemail.com ([64.98.42.181] helo=smtprelay.b.hostedemail.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U0dYn-0004Ez-6c for pgsql-www@postgresql.org; Wed, 30 Jan 2013 19:43:06 +0000 Received: from filter.hostedemail.com (b-bigip1 [10.5.19.254]) by smtprelay02.b.hostedemail.com (Postfix) with SMTP id AD44E2B6333; Wed, 30 Jan 2013 19:43:02 +0000 (UTC) X-Panda: scanned! X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Filterd-Recvd-Size: 2326 Received: from perhan.alvh.no-ip.org (unknown [190.95.28.201]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf12.b.hostedemail.com (Postfix) with ESMTPA; Wed, 30 Jan 2013 19:43:01 +0000 (UTC) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id F048D6E0B6; Wed, 30 Jan 2013 16:42:58 -0300 (CLST) Date: Wed, 30 Jan 2013 16:42:58 -0300 From: Alvaro Herrera To: Tom Lane Cc: pgsql-www@postgreSQL.org Subject: Re: Approval of duplicate message ids Message-ID: <20130130194258.GA3761@alvh.no-ip.org> References: <10977.1359309791@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <10977.1359309791@sss.pgh.pa.us> User-Agent: Mutt/1.5.21 (2010-09-15) Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: 0.3 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-www Precedence: bulk Sender: pgsql-www-owner@postgresql.org 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. --=20 =C1lvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services --=20 Sent via pgsql-www mailing list (pgsql-www@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-www