DOC: catalog.sgml

Поиск
Список
Период
Сортировка
От Zdenek Kotala
Тема DOC: catalog.sgml
Дата
Msg-id 44F832BD.6000008@sun.com
обсуждение исходный текст
Ответы Re: DOC: catalog.sgml  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: [HACKERS] Interval aggregate regression failure
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Interval aggregate regression failure