On Fri, May 19, 2017 at 9:54 AM, Peter Eisentraut
> On 5/12/17 13:25, Masahiko Sawada wrote:
>>> postgres=# alter subscription sub set publication pub refresh;
>>> NOTICE: removed subscription for table public.t1
>>> NOTICE: removed subscription for table public.t2
>>> ALTER SUBSCRIPTION
>>> I think - in publication too ,we should provide NOTICE messages.
>> I guess one of the reason why we emit such a NOTICE message is that
>> subscriber cannot control which table the upstream server replicate.
>> So if a table got disassociated on the publisher the subscriber should
>> report that to user. On the other hand, since the publication can
>> control it and the changes are obvious, I'm not sure we really need to
>> do that.
>> BTW I think it's better for the above NOTICE message to have subscription
> Why? These come directly has a result of the ALTER SUBSCRIPTION
> command, so you see what they refer to.
Because I thought it would be helpful for DBA when the log is appeared
in server log. It doesn't appear by default though.
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: