Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION

Поиск
Список
Период
Сортировка
Искать
От
houzj.fnst@fujitsu.com
Тема
Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION
Дата
Msg-id
OS0PR01MB57160AD0E7386547BA978EB394299@OS0PR01MB5716.jpnprd01.prod.outlook.com
Список
Дерево обсуждения
Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION Peter Smith <smithpb2250@gmail.com>
Re: Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION Amit Kapila <amit.kapila16@gmail.com>
RE: Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION Japin Li <japinli@hotmail.com>
Re: Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION Alvaro Herrera <alvherre@alvh.no-ip.org>
RE: Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Improve errhint for ALTER SUBSCRIPTION ADD/DROP PUBLICATION Amit Kapila <amit.kapila16@gmail.com> 
Hi,

While working on some logical replication related features.
I found the HINT message could be improved when I tried to add a publication to
a subscription which was disabled.

alter subscription sub add publication pub2;
--
ERROR: ALTER SUBSCRIPTION with refresh is not allowed for disabled subscriptions
HINT: Use ALTER SUBSCRIPTION ... SET PUBLICATION ... WITH (refresh = false).
--

Because I was executing the ADD PUBLICATION command, I feel the hint should
also mention it instead of SET PUBLICATION.

Best regards,
Hou zj
В списке pgsql-hackers по дате отправления
Предыдущее
От: osumi.takamichi@fujitsu.com
Дата:
Следующее
От: Julien Rouhaud
Дата:
FAQ