Re: migrations (was Re: To all who wish to unsubscribe) - Mailing list pgsql-general

From Craig Ringer
Subject Re: migrations (was Re: To all who wish to unsubscribe)
Date
Msg-id CAMsr+YHE+Gjz-RYALTmwUQy=ty1DTCUcgzLTRpcw4AMvVLEqkA@mail.gmail.com
Whole thread Raw
In response to Re: migrations (was Re: To all who wish to unsubscribe)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general


On 22 November 2017 at 03:35, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Magnus Hagander <magnus@hagander.net> writes:
> On Tue, Nov 21, 2017 at 8:14 PM, David G. Johnston <
> david.g.johnston@gmail.com> wrote:
>> What would help the majority of readers is if a rule could be added that
>> keys off of the word "unsubscribe" (and maybe some other key phrases) and
>> dumps it into a non-public moderation queue where requests can be handled
>> manually and prevented from reaching the list members.

> This is already the case, but clearly this rule was a bit too restrictive
> to avoid too many false positives.

It should also be pointed out that the old system did WAY too much of
that, often causing messages to get dumped into the moderation queue
because they happened to contain words that looked like majordomo
commands.  I do not think that an aggressive filter for "unsubscribe"
is a good idea --- note, for example, that none of this thread would
be seeing the light of day in any timely fashion if the new code
did that.

Not to mention that we have publish/subscribe in logical replication now. "How do I unsubscribe my table" -> /dev/null. Ooops. 


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: On Judging the Value of Tests
Next
From: Michael Paquier
Date:
Subject: Re: On Judging the Value of Tests