Re: migrations (was Re: To all who wish to unsubscribe)

On 22 November 2017 at 03:35, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Magnus Hagander <magnus(at)hagander(dot)net> writes:
> > On Tue, Nov 21, 2017 at 8:14 PM, David G. Johnston <
> > david(dot)g(dot)johnston(at)gmail(dot)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