Skip to content

Commit 6b2a144

Browse files
committed
Document permissions needed for pg_database_size and pg_tablespace_size.
Back in 8.3, we installed permissions checks in these functions (see commits 8bc225e and cc26599). But we forgot to document that anywhere in the user-facing docs; it did get mentioned in the 8.3 release notes, but nobody's looking at that any more. Per gripe from Suya Huang.
1 parent f483b15 commit 6b2a144

File tree

1 file changed

+5
-1
lines changed

1 file changed

+5
-1
lines changed

doc/src/sgml/func.sgml

Lines changed: 5 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -13519,7 +13519,11 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup());
1351913519
<para>
1352013520
<function>pg_database_size</function> and <function>pg_tablespace_size</>
1352113521
accept the OID or name of a database or tablespace, and return the total
13522-
disk space used therein.
13522+
disk space used therein. To use <function>pg_database_size</function>,
13523+
you must have <literal>CONNECT</> permission on the specified database
13524+
(which is granted by default). To use <function>pg_tablespace_size</>,
13525+
you must have <literal>CREATE</> permission on the specified tablespace,
13526+
unless it is the default tablespace for the current database.
1352313527
</para>
1352413528

1352513529
<para>

0 commit comments

Comments
 (0)