Joe Conway wrote:

If there are no objections, I'll review and apply this tonight (west coast USA time).

Andreas, please provide a corresponding documentation patch.

Here we are.
Since I don't have a SGML build environment, syntax is not checked.


Index: func.sgml
RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/func.sgml,v
retrieving revision 1.211
diff -u -r1.211 func.sgml
--- func.sgml   25 Jun 2004 17:20:21 -0000      1.211
+++ func.sgml   1 Jul 2004 18:38:34 -0000
@@ -7232,6 +7232,10 @@
+   <indexterm zone="functions-misc">
+    <primary>pg_tablespace_databases</primary>
+   </indexterm>
    <xref linkend="functions-misc-catalog-table"> lists functions that
    extract information from the system catalogs.
@@ -7325,6 +7329,11 @@
        <entry>get name of the sequence that a serial or bigserial column
+      <row>
+       <entry><type>setof oid</type></entry>
+       <entry>get set of database oids that have objects in the namespace</entry>
+      </row>
@@ -7360,6 +7369,16 @@
    for passing to the sequence functions (see <xref
    NULL is returned if the column does not have a sequence attached.
+  </para>
+  <para>
+  <function>pg_tablespace_databases</function> allows usage examination of a
+  tablespace. It will return a set of database oids, that have objects
+  stored in the tablespace. If this function returns any row, the
+  tablespace is assumed not to be empty and cannot be dropped. To
+  display the actual objects  populating the tablespace, you will need
+  to connect to the databases returned by 
+  <function>pg_tablespace_databases</function> to query pg_class.
    <indexterm zone="functions-misc">
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to