diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-10-11 17:24:41 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-10-11 17:24:41 +0000 |
| commit | e5d30091e6059328877969acd099e23899b6afd3 (patch) | |
| tree | 8d2e4ffb7b9043688f8250752ff4864cf4ba0560 /doc/src | |
| parent | 5340a988c84f704a8214bff2e0c7f14da2d59130 (diff) | |
| download | postgresql-e5d30091e6059328877969acd099e23899b6afd3.tar.gz postgresql-e5d30091e6059328877969acd099e23899b6afd3.zip | |
Fix pg_indexes view so that it shows the index's tablespace not the
parent table's tablespace, as per gripe from Michael Kleiser. Choose
a more plausible column order for this view and pg_tables. Update
documentation of these views, which was missed in original patch.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 7d8040b318c..aef5a751bb6 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1,6 +1,6 @@ <!-- Documentation of the system catalogs, directed toward PostgreSQL developers - $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.89 2004/07/04 23:34:23 tgl Exp $ + $PostgreSQL: pgsql/doc/src/sgml/catalogs.sgml,v 2.90 2004/10/11 17:24:39 tgl Exp $ --> <chapter id="catalogs"> @@ -3933,6 +3933,12 @@ <entry>name of index</entry> </row> <row> + <entry><structfield>tablespace</structfield></entry> + <entry><type>name</type></entry> + <entry><literal><link linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link>.spcname</literal></entry> + <entry>name of tablespace containing index (NULL if default for database)</entry> + </row> + <row> <entry><structfield>indexdef</structfield></entry> <entry><type>text</type></entry> <entry></entry> @@ -4450,6 +4456,12 @@ <entry>name of table's owner</entry> </row> <row> + <entry><structfield>tablespace</structfield></entry> + <entry><type>name</type></entry> + <entry><literal><link linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link>.spcname</literal></entry> + <entry>name of tablespace containing table (NULL if default for database)</entry> + </row> + <row> <entry><structfield>hasindexes</structfield></entry> <entry><type>boolean</type></entry> <entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.relhasindex</literal></entry> |