Re: REASSIGN OWNED BY alters objects in other database. - Mailing list pgsql-hackers

From Álvaro Herrera
Subject Re: REASSIGN OWNED BY alters objects in other database.
Date
Msg-id 202512301425.wc4i4qqjauim@alvherre.pgsql
Whole thread Raw
In response to REASSIGN OWNED BY alters objects in other database.  (Kirill Reshke <reshkekirill@gmail.com>)
Responses Re: REASSIGN OWNED BY alters objects in other database.
List 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)



pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: lsyscache: free IndexAmRoutine objects returned by GetIndexAmRoutineByAmId()
Next
From: Matthias van de Meent
Date:
Subject: Re: lsyscache: free IndexAmRoutine objects returned by GetIndexAmRoutineByAmId()