Re: CREATEROLE and role ownership hierarchies

Поиск
Список
Период
Сортировка
От Joshua Brindle
Тема Re: CREATEROLE and role ownership hierarchies
Дата
Msg-id CAGB+Vh5EySCfH9C4brq2es+xoH=VXXSihZJ8hArUUi-XgZdjDQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CREATEROLE and role ownership hierarchies  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: CREATEROLE and role ownership hierarchies  (Mark Dilger <mark.dilger@enterprisedb.com>)
Список pgsql-hackers
On Mon, Jan 3, 2022 at 5:08 PM Andrew Dunstan <andrew@dunslane.net> wrote:
>
>
> On 12/23/21 16:06, Joshua Brindle wrote:
> > On Tue, Dec 21, 2021 at 8:26 PM Mark Dilger
> > <mark.dilger@enterprisedb.com> wrote:
> >>
> >>
> >>> On Dec 21, 2021, at 5:11 PM, Shinya Kato <Shinya11.Kato@oss.nttdata.com> wrote:
> >>>
> >>> I fixed the patches because they cannot be applied to HEAD.
> >> Thank you.
> > I reviewed and tested these and they LGTM. FYI the rebased v3 patches
> > upthread are raw diffs so git am won't apply them.
>
>
> That's not at all unusual. I normally apply patches just using
>
>    patch -p 1 < $patchfile
>
> > I can add myself to
> > the CF as a reviewer if it is helpful.
>
>
> Please do.

I just ran across this and I don't know if it is intended behavior or
not, can you tell me why this happens?

postgres=> \du+
                                                List of roles
 Role name |  Owner   |                         Attributes
            | Member of | Description
-----------+----------+------------------------------------------------------------+-----------+-------------
 brindle   | brindle  | Password valid until 2022-01-05 00:00:00-05
            | {}        |
 joshua    | postgres | Create role
            | {}        |
 postgres  | postgres | Superuser, Create role, Create DB,
Replication, Bypass RLS | {}        |

postgres=> \password
Enter new password for user "brindle":
Enter it again:
ERROR:  role "brindle" with OID 16384 owns itself



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [PATCH] Allow multiple recursive self-references
Следующее
От: Robert Haas
Дата:
Сообщение: Re: refactoring basebackup.c