Thread

Re: REASSIGN OWNED BY alters objects in other database.

Álvaro Herrera <alvherre@kurilemu.de> — 2025-12-30T14:30:51Z

On 2025-Dec-30, Kirill Reshke wrote:

> So, REASSIGN OWNER executed in database postgres alters subscription
> owner, which is created in another database. I am not myself confident
> that this is actually wrong... Is this a bug?

Subscriptions are shared objects (like tablespaces, roles etc), so I
think this is working as intended.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"I love the Postgres community. It's all about doing things _properly_. :-)"
(David Garamond)