Hi, The commit ddd7b22b225ae41d16ceb218b387645cb9becfdc makes table sync workers stop when subscription relation entry is removed. It doesn't work fine inside transaction block. I think we should disallow to use the following subscription DDLs inside a transaction block. Attached patch.
* ALTER SUBSCRIPTION SET PUBLICATION WITH (refresh = true) * ALTER SUBSCRIPTION REFRESH PUBLICATION Also, even if we rollback ALTER SUBSCRIPTION REFRESH PUBLICATION, the error message "NOTICE: removed subscription for table public.t1" appears. It's not a bug but might confuse the user. Regards, -- Masahiko Sawada NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center
alter_subscription_and_transaction.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers