Re: BUG #16279: Permissions doc incorrect for pg_buffercache - Mailing list pgsql-bugs

From Philip Semanchuk
Subject Re: BUG #16279: Permissions doc incorrect for pg_buffercache
Date
Msg-id D85A0DF0-A631-43B6-B92D-7B22433B9FA7@americanefficient.com
Whole thread Raw
In response to Re: BUG #16279: Permissions doc incorrect for pg_buffercache  (Sergei Kornilov <sk@zsrv.org>)
Responses Re: BUG #16279: Permissions doc incorrect for pg_buffercache  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs

> On Feb 26, 2020, at 12:11 PM, Sergei Kornilov <sk@zsrv.org> wrote:
>
> Hello
>
> You are right, in contrib/pg_buffercache/pg_buffercache--1.2--1.3.sql we have
>
> GRANT EXECUTE ON FUNCTION pg_buffercache_pages() TO pg_monitor;
> GRANT SELECT ON pg_buffercache TO pg_monitor;
>
> Not pg_read_all_stats. I'm not sure: we need change the extension or fix the documentation? I think pg_read_all_stats
wouldbe more appropriate, but we need bump the extension version. 


Thanks for exploring and confirming! I agree that pg_read_all_stats would be more appropriate.

Cheers
Philip


pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #15383: Join Filter cost estimation problem in 10.5
Next
From: Tom Lane
Date:
Subject: Re: BUG #16279: Permissions doc incorrect for pg_buffercache