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
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 |