Tom Lane wrote: > Dave Page <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings