Alter subscription..SET - NOTICE message is coming for table which is already removed

From: tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Alter subscription..SET - NOTICE message is coming for table which is already removed
Date: 2017-05-25 10:08:00
Message-ID: 2b89dc87-8093-013a-0b83-2bb4b0b04d56@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

While performing - Alter subscription..SET , I found that NOTICE
message is coming duplicate next time , which is not needed anymore.

X cluster=
create 100 tables
create publication ( create publication pub for all tables;)

Y cluster=
create 100 tables
create subscription ( create subscription sub connection
'dbname=postgres user=centos host=localhost ) publication pub;

X cluster =
create 1 more table (create table r(n int));
create publication for this above table only (create publication pub1
for table r;)

Y cluster=
create table r - create table r(n int);
alter publication -alter subscription sub set publication pub1 refresh;

in the notice message -> table 'r' added / 100 tables removed from the
subscription

postgres=# alter subscription sub set publication pub1 refresh;
NOTICE: added subscription for table public.r
NOTICE: removed subscription for table public.t1
NOTICE: removed subscription for table public.t2
NOTICE: removed subscription for table public.t3
NOTICE: removed subscription for table public.t4
NOTICE: removed subscription for table public.t5
NOTICE: removed subscription for table public.t6
--
--
--
ALTER SUBSCRIPTION

now again fire the same sql query

postgres=# alter subscription sub set publication pub1 refresh;
NOTICE: removed subscription for table public.t78
ALTER SUBSCRIPTION

This notice message should not come as t.78 is already removed from
earlier same command.

--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2017-05-25 11:06:18 Re: TPC-H Q20 from 1 hour to 19 hours!
Previous Message Jeevan Ladhe 2017-05-25 09:33:05 Re: Adding support for Default partition in partitioning