Re: logical replication syntax (was DROP SUBSCRIPTION, query cancellations and slot handling)

From: Noah Misch <noah(at)leadboat(dot)com>
To: peter(dot)eisentraut(at)2ndquadrant(dot)com
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: logical replication syntax (was DROP SUBSCRIPTION, query cancellations and slot handling)
Date: 2017-05-07 08:23:10
Message-ID: 20170507082310.GL843225@rfd.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, May 02, 2017 at 01:42:37PM -0400, Robert Haas wrote:
> On Tue, May 2, 2017 at 8:45 AM, Petr Jelinek
> <petr(dot)jelinek(at)2ndquadrant(dot)com> wrote:
> > I am happy to implement something different, it's quite trivial to
> > change. But I am not going to propose anything different as I can't
> > think of better syntax (if I could I would have done it). I don't like
> > the OFF or FALSE (ie DROP SLOT OFF) any more than what is there now and
> > it also seems to not map very well to action (as opposed to output
> > option as it is in EXPLAIN). It might not be very close to SQL way but
> > that's because SQL way would be do not do any of those default actions
> > unless they are actually asked for (ie NODROP SLOT would be default and
> > DROP SLOT would be the option) but that's IMHO less user friendly.
>
> So the cases where this "NO" prefixing comes up are:
>
> 1. CREATE SUBSCRIPTION
...
> 2. ALTER SUBSCRIPTION
...
> 3. DROP SUBSCRIPTION
...
> 4. CREATE PUBLICATION
...
> So it doesn't actually look hard to get rid of all of the NO prefixes.

[Action required within three days. This is a generic notification.]

The above-described topic is currently a PostgreSQL 10 open item. Peter,
since you committed the patch believed to have created it, you own this open
item. If some other commit is more relevant or if this does not belong as a
v10 open item, please let us know. Otherwise, please observe the policy on
open item ownership[1] and send a status update within three calendar days of
this message. Include a date for your subsequent status update. Testers may
discover new open items at any time, and I want to plan to get them all fixed
well in advance of shipping v10. Consequently, I will appreciate your efforts
toward speedy resolution. Thanks.

[1] https://www.postgresql.org/message-id/20170404140717.GA2675809%40tornado.leadboat.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2017-05-07 12:38:05 Re: Change GetLastImportantRecPtr's definition? (wasSkip checkpoints, archiving on idle systems.)
Previous Message Noah Misch 2017-05-07 08:21:28 Re: logical replication syntax (was DROP SUBSCRIPTION, query cancellations and slot handling)