Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER
Дата
Msg-id
CA+TgmoYBTVZzchPhwmfgNhMMvVvon4EFA0e+p-7hdkMO4jKQdw@mail.gmail.com
Ответ на
Список
Дерево обсуждения
let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER Robert Haas <robertmhaas@gmail.com>
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER Tom Lane <tgl@sss.pgh.pa.us>
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER Robert Haas <robertmhaas@gmail.com>
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER Tom Lane <tgl@sss.pgh.pa.us>
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER Nathan Bossart <nathandbossart@gmail.com>
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER Robert Haas <robertmhaas@gmail.com>
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER Tom Lane <tgl@sss.pgh.pa.us>
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER Robert Haas <robertmhaas@gmail.com>
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER "David G. Johnston" <david.g.johnston@gmail.com>
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER Tom Lane <tgl@sss.pgh.pa.us>
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER Joe Conway <mail@joeconway.com>
Re: let's disallow ALTER ROLE bootstrap_superuser NOSUPERUSER Robert Haas <robertmhaas@gmail.com>
On Tue, Jul 26, 2022 at 2:59 PM Tom Lane  wrote:
> I had not actually read the patch, but now that I have, it's got
> a basic typing error:
>
> +       bool    should_be_super = BoolGetDatum(boolVal(dissuper->arg));
> +
> +       if (!should_be_super && roleid == BOOTSTRAP_SUPERUSERID)
> +           ereport(ERROR,
>
> The result of BoolGetDatum is not bool, it's Datum.  This is
> probably harmless, but it's still a typing violation.
> You want something like
>
>         bool    should_be_super = boolVal(dissuper->arg);
>         ...
>         new_record[Anum_pg_authid_rolsuper - 1] = BoolGetDatum(should_be_super);

Oops. Will fix.

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


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Robert Haas
Дата:
FAQ