Re: Re: "pg_xxx" role name restriction not applied to bootstrap superuser?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, glyn(at)8kb(dot)co(dot)uk
Subject: Re: Re: "pg_xxx" role name restriction not applied to bootstrap superuser?
Date: 2016-05-08 12:37:12
Message-ID: 20160508123712.GX10850@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> Stephen Frost <sfrost(at)snowman(dot)net> writes:
> > * Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> >> ... but I'm left with a policy question: should initdb disallow
> >> bootstrap superuser names like "pg_xxx"?
>
> > On the whole, I'd vote to treat the bootstrap user as a normal role and
> > therefore have the same restriction in place for that user also.
>
> If we're going to enforce such a restriction, I think it would be
> a good thing for it to be in place in beta1.

Makes sense.

Patch attached. I'll push this in a bit, barring objections.

Thanks!

Stephen

Attachment Content-Type Size
disallow_reserved_name_initdb.patch text/x-diff 1.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2016-05-08 14:20:17 Re: [COMMITTERS] pgsql: Disable BLOB test in pg_dump TAP tests
Previous Message Simon Riggs 2016-05-08 10:48:20 Re: minor message improvement