Re: pg_tablespace_size() - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg_tablespace_size()
Date
Msg-id 200710121508.l9CF8Ja23657@momjian.us
Whole thread Raw
In response to Re: pg_tablespace_size()  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Dave Page <dpage@postgresql.org> writes:
> > select pg_tablespace_size('pg_global');
> > ERROR:  permission denied for tablespace pg_global
> 
> > Can this be fixed please?
> 
> What's to be fixed?  That's exactly the result I'd expect given the
> previously-agreed-to behavior for pg_tablespace_size.

I know we said tablespace requires CREATE privs, but certainly the
super-user should be able to use the function too.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: First steps with 8.3 and autovacuum launcher
Next
From: Dave Page
Date:
Subject: Re: pg_tablespace_size()