Horton

Re: Invalidate the subscription worker in cases where a user loses their superuser status

vignesh C <vignesh21@gmail.com>

View thread View on postgr.es
From: vignesh C <vignesh21@gmail.com>
To: Shlok Kyal <shlok.kyal.oss@gmail.com>
Cc: Peter Smith <smithpb2250@gmail.com>, Amit Kapila <amit.kapila16@gmail.com>, Jeff Davis <pgsql@j-davis.com>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-10-06T12:00:54Z
Lists: pgsql-hackers 
On Wed, 4 Oct 2023 at 17:01, Shlok Kyal <shlok.kyal.oss@gmail.com> wrote:
>
> On Wed, 4 Oct 2023 at 16:56, Peter Smith <smithpb2250@gmail.com> wrote:
> >
> > On Tue, Oct 3, 2023 at 5:42 PM vignesh C <vignesh21@gmail.com> wrote:
> > >
> > > Thanks for the comments, the attached v6 version patch has the changes
> > > for the same.
> > >
> >
> > v6 LGTM.
> >
> I have verified the patch and it is working fine for me.

I have created the commitfest entry for this at:
https://commitfest.postgresql.org/45/4595/

Regards.
Vignesh

Commits

  1. Restart the apply worker if the privileges have been revoked.