Re: REASSIGN OWNED BY alters objects in other database.
Álvaro Herrera <alvherre@kurilemu.de>
From: Álvaro Herrera <alvherre@kurilemu.de>
To: Kirill Reshke <reshkekirill@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-12-30T14:30:51Z
Lists: pgsql-hackers
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)