Re: [PATCH] Add regress test for pg_read_all_stats role

2018-09-26 Thread Michael Paquier
On Fri, Aug 24, 2018 at 03:37:17PM +0100, Alexandra Ryzhevich wrote: > CONNECT ON DATABASE privilege is granted to public by default (so > all users by default can select pg_database_size()) and > REVOKE CONNECT ... FROM command doesn't impact > user's privileges. The only way to revoke connect

Re: [PATCH] Add regress test for pg_read_all_stats role

2018-08-24 Thread Alexandra Ryzhevich
On Thu, Aug 23, 2018 at 9:12 AM Michael Paquier wrote: > On Tue, Aug 21, 2018 at 05:48:49PM +0100, Alexandra Ryzhevich wrote: > > Just to check if changes broke something. I haven't find these checks in > > other regress tests. In other way we get only positive tests. If this > > is not needed

Re: [PATCH] Add regress test for pg_read_all_stats role

2018-08-23 Thread Michael Paquier
On Tue, Aug 21, 2018 at 05:48:49PM +0100, Alexandra Ryzhevich wrote: > Just to check if changes broke something. I haven't find these checks in > other regress tests. In other way we get only positive tests. If this > is not needed then should I remove all the checks for > regress_role_nopriv role

Re: [PATCH] Add regress test for pg_read_all_stats role

2018-08-21 Thread Alexandra Ryzhevich
> > - There is no need for the initial DROP ROLE commands as those already > get dropped at the end of the tests. > Removed. - There is already rolenames.sql which has a tiny coverage for default > roles, why not just using it? > Moved changes to rolenames.sql. > +-- should fail because

Re: [PATCH] Add regress test for pg_read_all_stats role

2018-08-19 Thread Michael Paquier
On Fri, Aug 03, 2018 at 02:08:27PM +0100, Alexandra Ryzhevich wrote: > Thank you for pointing to some problems of the patch. I've attached a > modified version below. Could you avoid top-posting? This is not the style of the Postgres mailing lists. I have been looking at your latest patch, and

Re: [PATCH] Add regress test for pg_read_all_stats role

2018-08-03 Thread Alexandra Ryzhevich
Thank you for pointing to some problems of the patch. I've attached a modified version below. On Thu, Aug 2, 2018 at 8:38 PM Michael Paquier wrote: > On Thu, Aug 02, 2018 at 06:25:14PM +0100, Alexandra Ryzhevich wrote: > > I have noticed that there is no regression tests for default monitoring

Re: [PATCH] Add regress test for pg_read_all_stats role

2018-08-02 Thread Michael Paquier
On Thu, Aug 02, 2018 at 06:25:14PM +0100, Alexandra Ryzhevich wrote: > I have noticed that there is no regression tests for default monitoring > roles such as pg_read_all_stats. A bug has been recently fixed for that, see 0c8910a0, so having more coverage would be welcome, now your patch has a