Hello,
I am attaching the solution we used.
Thank you for your answers and help,
Roman
--
-- ALTER SUBSCRIPTION REFRESH TEST CASE / SOLUTION
--
-- 9. install extension dblink + create function/procedure [DESTINATION
DATABASE]
\
=?UTF-8?B?Um9tYW4gxaBpbmRlbMOhxZk=?= writes:
> - ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function in all
> PGSQL versions 14+, is it desired behavior?
It's intentional to get some other benefits, if that's what you mean.
See
https://git.postgresql.org/gitweb/?p=
Regards,
Patrick
From: Roman Šindelář
Sent: Wednesday, December 6, 2023 1:04 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function
Hello,
we prepared a test case to demonstrate our case.
TASK
Update replicated db schema (add new table
Hello,
we prepared a test case to demonstrate our case.
TASK
Update replicated db schema (add new table) without superuser privileges.
PROBLEM
Our steps work in PostgreSQL ver 12 but we get the following error in 15
---
ERROR: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function
In version 15, unfortunately, we get the following error:
ERROR: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function
I found only one discussion about this problem, where as a workaround is
suggested using of dblink (
https://postgrespro.com/list/id/CANaTPsphRF+7k+YAN
