Re: pg_tablespace_size() - Mailing list pgsql-hackers

From Dave Page
Subject Re: pg_tablespace_size()
Date
Msg-id 470F8E3A.2080908@postgresql.org
Whole thread Raw
In response to Re: pg_tablespace_size()  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_tablespace_size()
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.

In the message I quoted at the end of the long discussion on the topic
you assured me it would work for superusers.

Is there any reason the superuser shouldn't see the size of pg_global?

Regards, Dave.



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_tablespace_size()
Next
From: "Florian G. Pflug"
Date:
Subject: Re: pg_restore oddity?