> On Nov 19, 2021, at 1:56 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> How about allowing to change ownership only for disabled
> subscriptions? Basically, users need to first disable the subscription
> and then change its ownership.
There are some open issues about non-superuser owners that Jeff would like to address before allowing transfers of
ownershipto non-superusers. Your proposal about requiring the subscription to be disabled seems reasonable to me, but
I'dlike to see how it would interact with whatever Jeff proposes. So I think I will change the patch as you suggest,
butconsider it a WIP patch until then.
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company