Postgres Pro
Downloads
Home   >   mailing lists

Re: Invalidate the subscription worker in cases where a user loses their superuser status - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Invalidate the subscription worker in cases where a user loses their superuser status
Date
Msg-id CA+Tgmob2mYpaUMT7aoFOukYTrpxt-WdgcitJnsjWhufnbDWEeg@mail.gmail.com
Whole thread Raw
In response to Re: Invalidate the subscription worker in cases where a user loses their superuser status  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: Invalidate the subscription worker in cases where a user loses their superuser status
List pgsql-hackers
Tree view 
On Wed, Sep 27, 2023 at 2:58 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
> But OTOH, the owner of the subscription can be changed by the Alter
> Subscription command whereas superuser status can't be changed. I
> think we should consider changing the message for this case.

The superuser status of the subscription owner is definitely *not* a
parameter of the subscription, so it doesn't seem like the same
message is appropriate.

> Adding Jeff and Robert to see what is their opinion on whether we
> should backpatch this or not.

I guess it depends on whether we think this is a bug. I think you
could argue it either way.

--
Robert Haas
EDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Eliminate redundant tuple visibility check in vacuum
Next
From: Heikki Linnakangas
Date:
Subject: Re: bug: ANALYZE progress report with inheritance tables