DOC: catalog.sgml - Mailing list pgsql-patches

From Zdenek Kotala
Subject DOC: catalog.sgml
Date
Msg-id 44F832BD.6000008@sun.com
Whole thread Raw
Responses Re: DOC: catalog.sgml  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
I little bit enhanced overview catalog tables. I added two new columns.
First one is OID of catalog table and second one contains attributes
which determine if the table is bootstrap, with oid and global.

I'm not able generate doc from sgml :( and verify if changes are ok :(.

        Zdenek

Index: doc/src/sgml/catalogs.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v
retrieving revision 2.130
diff -c -r2.130 catalogs.sgml
*** doc/src/sgml/catalogs.sgml    25 Aug 2006 04:06:44 -0000    2.130
--- doc/src/sgml/catalogs.sgml    1 Sep 2006 12:42:47 -0000
***************
*** 26,32 ****

    <para>
     <xref linkend="catalog-table"> lists the system catalogs.
!    More detailed documentation of each catalog follows below.
    </para>

    <para>
--- 26,35 ----

    <para>
     <xref linkend="catalog-table"> lists the system catalogs.
!    More detailed documentation of each catalog follows below. Attributes
!    column contains information how table was created. A bootstrap tables
!    has attribut B. Table which has OID field has O. Shared/global tables
!    are mark with letter G.
    </para>

    <para>
***************
*** 39,49 ****
    <table id="catalog-table">
     <title>System Catalogs</title>

!    <tgroup cols="2">
      <thead>
       <row>
        <entry>Catalog Name</entry>
        <entry>Purpose</entry>
       </row>
      </thead>

--- 42,54 ----
    <table id="catalog-table">
     <title>System Catalogs</title>

!    <tgroup cols="4">
      <thead>
       <row>
        <entry>Catalog Name</entry>
        <entry>Purpose</entry>
+       <entry>Oid</entry>
+       <entry>Attributes</entry>
       </row>
      </thead>

***************
*** 51,216 ****
--- 56,287 ----
       <row>
        <entry><link linkend="catalog-pg-aggregate"><structname>pg_aggregate</structname></link></entry>
        <entry>aggregate functions</entry>
+       <entry>2600</entry>
+       <entry>---</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-am"><structname>pg_am</structname></link></entry>
        <entry>index access methods</entry>
+       <entry>2601</entry>
+       <entry>-O-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-amop"><structname>pg_amop</structname></link></entry>
        <entry>access method operators</entry>
+       <entry>2602</entry>
+       <entry>---</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-amproc"><structname>pg_amproc</structname></link></entry>
        <entry>access method support procedures</entry>
+       <entry>2603</entry>
+       <entry>---</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-attrdef"><structname>pg_attrdef</structname></link></entry>
        <entry>column default values</entry>
+       <entry>2604</entry>
+       <entry>-O-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-attribute"><structname>pg_attribute</structname></link></entry>
        <entry>table columns (<quote>attributes</quote>)</entry>
+       <entry>1249</entry>
+       <entry>B--</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link></entry>
        <entry>authorization identifiers (roles)</entry>
+       <entry>1260</entry>
+       <entry>-OG</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-auth-members"><structname>pg_auth_members</structname></link></entry>
        <entry>authorization identifier membership relationships</entry>
+       <entry>1261</entry>
+       <entry>--G</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-autovacuum"><structname>pg_autovacuum</structname></link></entry>
        <entry>per-relation autovacuum configuration parameters</entry>
+       <entry>1248</entry>
+       <entry>---</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-cast"><structname>pg_cast</structname></link></entry>
        <entry>casts (data type conversions)</entry>
+       <entry>2605</entry>
+       <entry>-O-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-class"><structname>pg_class</structname></link></entry>
        <entry>tables, indexes, sequences, views (<quote>relations</quote>)</entry>
+       <entry>1259</entry>
+       <entry>BO-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-constraint"><structname>pg_constraint</structname></link></entry>
        <entry>check constraints, unique constraints, primary key constraints, foreign key constraints</entry>
+       <entry>2606</entry>
+       <entry>-O-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-conversion"><structname>pg_conversion</structname></link></entry>
        <entry>encoding conversion information</entry>
+       <entry>2607</entry>
+       <entry>-O-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-database"><structname>pg_database</structname></link></entry>
        <entry>databases within this database cluster</entry>
+       <entry>1262</entry>
+       <entry>-OG</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-depend"><structname>pg_depend</structname></link></entry>
        <entry>dependencies between database objects</entry>
+       <entry>2608</entry>
+       <entry>---</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-description"><structname>pg_description</structname></link></entry>
        <entry>descriptions or comments on database objects</entry>
+       <entry>2609</entry>
+       <entry>---</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-index"><structname>pg_index</structname></link></entry>
        <entry>additional index information</entry>
+       <entry>2610</entry>
+       <entry>---</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-inherits"><structname>pg_inherits</structname></link></entry>
        <entry>table inheritance hierarchy</entry>
+       <entry>2611</entry>
+       <entry>---</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-language"><structname>pg_language</structname></link></entry>
        <entry>languages for writing functions</entry>
+       <entry>2612</entry>
+       <entry>-O-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-largeobject"><structname>pg_largeobject</structname></link></entry>
        <entry>large objects</entry>
+       <entry>2613</entry>
+       <entry>---</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-listener"><structname>pg_listener</structname></link></entry>
        <entry>asynchronous notification support</entry>
+       <entry>2614</entry>
+       <entry>---</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-namespace"><structname>pg_namespace</structname></link></entry>
        <entry>schemas</entry>
+       <entry>2615</entry>
+       <entry>-O-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-opclass"><structname>pg_opclass</structname></link></entry>
        <entry>index access method operator classes</entry>
+       <entry>2616</entry>
+       <entry>-O-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-operator"><structname>pg_operator</structname></link></entry>
        <entry>operators</entry>
+       <entry>2617</entry>
+       <entry>-0-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-pltemplate"><structname>pg_pltemplate</structname></link></entry>
        <entry>template data for procedural languages</entry>
+       <entry>1136</entry>
+       <entry>--G</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-proc"><structname>pg_proc</structname></link></entry>
        <entry>functions and procedures</entry>
+       <entry>1255</entry>
+       <entry>BO-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-rewrite"><structname>pg_rewrite</structname></link></entry>
        <entry>query rewrite rules</entry>
+       <entry>2618</entry>
+       <entry>-O-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-shdepend"><structname>pg_shdepend</structname></link></entry>
        <entry>dependencies on shared objects</entry>
+       <entry>1214</entry>
+       <entry>--G</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-shdescription"><structname>pg_shdescription</structname></link></entry>
        <entry>comments on shared objects</entry>
+       <entry>2396</entry>
+       <entry>--G</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-statistic"><structname>pg_statistic</structname></link></entry>
        <entry>planner statistics</entry>
+       <entry>2619</entry>
+       <entry>---</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link></entry>
        <entry>tablespaces within this database cluster</entry>
+       <entry>1213</entry>
+       <entry>-OG</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-trigger"><structname>pg_trigger</structname></link></entry>
        <entry>triggers</entry>
+       <entry>2620</entry>
+       <entry>-O-</entry>
       </row>

       <row>
        <entry><link linkend="catalog-pg-type"><structname>pg_type</structname></link></entry>
        <entry>data types</entry>
+       <entry>1247</entry>
+       <entry>BO-</entry>
       </row>
      </tbody>
     </tgroup>

pgsql-patches by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: [HACKERS] Interval aggregate regression failure
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Interval aggregate regression failure