Re: SYSTEM_USER reserved word implementation

Поиск
Список
Период
Сортировка
От Drouvot, Bertrand
Тема Re: SYSTEM_USER reserved word implementation
Дата
Msg-id 8fe1752a-2e3d-4ee8-656c-0caf5d860b0e@amazon.com
обсуждение исходный текст
Ответ на Re: SYSTEM_USER reserved word implementation  (Jacob Champion <jchampion@timescale.com>)
Ответы Re: SYSTEM_USER reserved word implementation
Список pgsql-hackers
Hi,

On 8/16/22 6:52 PM, Jacob Champion wrote:
> On Fri, Aug 12, 2022 at 6:32 AM Drouvot, Bertrand <bdrouvot@amazon.com> wrote:
>> It has been agreed that the work on this patch is on hold until the
>> ClientConnectionInfo related work is finished (see the discussion in [1]).
>>
>> Having said that I'm attaching a new patch
>> "v2-0004-system_user-implementation.patch" for the SYSTEM_USER.
> (Not a full review.) Now that the implementation has increased in
> complexity, the original tests for the parallel workers have become
> underpowered. As a concrete example, I forgot to serialize auth_method
> during my most recent rewrite, and the tests still passed.
>
> I think it'd be better to check the contents of SYSTEM_USER, where we
> can, rather than only testing for existence. Something like the
> attached, maybe?

Yeah, fully agree, thanks for pointing out!

I've included your suggestion in v2-0005 attached (it's expected to see 
the CF bot failing for the same reason as mentioned up-thread).

> And it would also be good to add a similar test to
> the authentication suite, so that you don't have to have Kerberos
> enabled to fully test SYSTEM_USER.

Agree, I'll look at what can be done here.

Regards,

-- 
Bertrand Drouvot
Amazon Web Services: https://aws.amazon.com

Вложения

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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: Propose a new function - list_is_empty
Следующее
От: "Drouvot, Bertrand"
Дата:
Сообщение: Re: [PATCH] Expose port->authn_id to extensions and triggers