Regression test CREATE USER/ROLE usage

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
Subject: Regression test CREATE USER/ROLE usage
Date: 2016-04-10 17:42:59
Message-ID: 20160410174259.GX10850@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Tom,

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> broken that way as rowsecurity.sql, which is (still) creating roles
> named "alice" and "bob", but it's not acceptable like this.

Attached is a patch to fix all of the role usage in rowsecurity.sql
(I believe, feel free to let me know if there's anything else). In
particular, all of the roles are changed to begin with 'regress_', and
they are all now created with NOLOGIN.

I'll plan to push this in the next day or so.

I'll also work up a patch for the rest of the CREATE USER/ROLE usage in
the core regression tests.

This will result in a bit of not-strictly-necessary code churn, but
having consistency in the code base really is valuable where we have an
agreed upon policy as to what all the tests should be doing, for new
(and even old) developers to follow.

Comments and concerns welcome, of course.

Thanks!

Stephen

Attachment Content-Type Size
prefix-rls-users.patch text/x-diff 129.8 KB

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2016-04-10 17:55:27 Re: Regression test CREATE USER/ROLE usage
Previous Message Tom Lane 2016-04-10 17:17:13 Re: [COMMITTERS] pgsql: Bloom index contrib module

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-04-10 17:55:27 Re: Regression test CREATE USER/ROLE usage
Previous Message Tom Lane 2016-04-10 17:17:13 Re: [COMMITTERS] pgsql: Bloom index contrib module