[HACKERS] Alter subscription..SET - NOTICE message is coming for table which isalready removed
От | tushar |
---|---|
Тема | [HACKERS] Alter subscription..SET - NOTICE message is coming for table which isalready removed |
Дата | |
Msg-id | 2b89dc87-8093-013a-0b83-2bb4b0b04d56@enterprisedb.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] Alter subscription..SET - NOTICE message is coming fortable which is already removed
[HACKERS] Re: Alter subscription..SET - NOTICE message is coming for tablewhich is already removed |
Список | 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
В списке pgsql-hackers по дате отправления: