Re: How to use set/reset role in contrib_regression test?

Поиск
Список
Период
Сортировка
От Jeremy Finzel
Тема Re: How to use set/reset role in contrib_regression test?
Дата
Msg-id CAMa1XUhTCEYeEABy18q0gTTYvJVG=7QLGctM2HjYjKFdaSSGeg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to use set/reset role in contrib_regression test?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения
Here is my version:

PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit

Indeed it is possible my extension is messing up the behavior because event triggers are firing on the CREATE events.  But there is no SET ROLE happening in the event triggers.

Perhaps one of the more interesting things happening is there is the pglogical c function pglogical.replicate_ddl_command that is being called.  I do see some interesting things happening with roles here, specifically this: https://github.com/2ndQuadrant/pglogical/blob/REL1_2_STABLE/pglogical_apply.c#L1699-L1704

Added Craig Ringer to the discussion in case he has any ideas on if that could be a factor.

On Fri, Dec 8, 2017 at 8:51 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Michael Paquier <michael.paquier@gmail.com> writes:
> Per the information you are giving, I would have seen "popo2" as user
> for the last query even after issuing a RESET ROLE. However I do not
> see any problems.

Yeah, I also failed to reproduce it (on yesterday's HEAD, though I'd be
surprised if older versions were busted like this either).  I'm wondering
if Jeremy has some extension installed that is messing with the behavior.

                        regards, tom lane

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: proposal: alternative psql commands quit and exit
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Allowing SSL connection of v11 client to v10 server with SCRAMchannel binding