Postgres Pro
Downloads
Home   >   mailing lists

Re: Non-superuser subscription owners - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Non-superuser subscription owners
Date
Msg-id CA+TgmoaK2VnJWE34Rp_eBwKc95Ff5fCoU_3hz9H_a6g3fQmj0w@mail.gmail.com
Whole thread Raw
In response to RE: Non-superuser subscription owners  ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>)
Responses RE: Non-superuser subscription owners  ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>)
Re: Non-superuser subscription owners  (Alexander Lakhin <exclusion@gmail.com>)
List pgsql-hackers
Tree view 
On Thu, Mar 30, 2023 at 9:49 PM houzj.fnst@fujitsu.com
<houzj.fnst@fujitsu.com> wrote:
> It looks like the super user check is out of a transaction, I haven't checked why
> it only failed on one BF animal, but it seems we can put the check into the
> transaction like the following:

That looks like a reasonable fix but I can't reproduce the problem
locally. I thought the reason why that machine sees the problem might
be that it uses -DRELCACHE_FORCE_RELEASE, but I tried that option here
and the tests still pass. Anyone ideas how to reproduce?

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

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Minimal logical decoding on standbys
Next
From: Daniel Gustafsson
Date:
Subject: Re: Making background psql nicer to use in tap tests