Re: Only owners can ANALYZE tables...seems overly restrictive

On 02/29/2016 03:15 PM, Guillaume Lelarge wrote:
> 2016-02-29 14:31 GMT+01:00 Stephen Frost <sfrost@snowman.net
> <mailto:sfrost@snowman.net>>:
>
>     Realistically, ANALYZE is a background/maintenance task that autovacuum
>     should be handling for you.
>
> Realistically, that can't happen every time. Think of temporary tables
> for example...

Hmm.  How are you not the owner of a temporary table?
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support