summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/reindex.sgml
diff options
context:
space:
mode:
authorNeil Conway <neilc@samurai.com>2006-10-31 01:52:31 +0000
committerNeil Conway <neilc@samurai.com>2006-10-31 01:52:31 +0000
commitbc4b856e7b04cd076dbcaa914a1e84bd1f07e10d (patch)
tree5032a3f0260bea8d2c1a6115698d5a6f29f8079d /doc/src/sgml/ref/reindex.sgml
parent0b9f93e6b04d941d3428d6e709ab8c4b03554f2f (diff)
downloadpostgresql-bc4b856e7b04cd076dbcaa914a1e84bd1f07e10d.tar.gz
Add text to the VACUUM, REINDEX, DROP TABLESPACE and CREATE TABLESPACE
reference pages documenting that these commands cannot be used within a transaction block. Also make some minor improvements to the psql reference page. Patch from Simon Riggs, minor editorialization by myself.
Diffstat (limited to 'doc/src/sgml/ref/reindex.sgml')
-rw-r--r--doc/src/sgml/ref/reindex.sgml7
1 files changed, 5 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml
index 574b8effd1..661a219adc 100644
--- a/doc/src/sgml/ref/reindex.sgml
+++ b/doc/src/sgml/ref/reindex.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/reindex.sgml,v 1.33 2006/09/16 00:30:19 momjian Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/reindex.sgml,v 1.34 2006/10/31 01:52:31 neilc Exp $
PostgreSQL documentation
-->
@@ -106,7 +106,8 @@ REINDEX { INDEX | TABLE | DATABASE | SYSTEM } <replaceable class="PARAMETER">nam
<para>
Recreate all indexes within the current database.
Indexes on shared system catalogs are skipped except in stand-alone mode
- (see below).
+ (see below). This form of <command>REINDEX</command> cannot be executed
+ inside a transaction block.
</para>
</listitem>
</varlistentry>
@@ -118,6 +119,8 @@ REINDEX { INDEX | TABLE | DATABASE | SYSTEM } <replaceable class="PARAMETER">nam
Recreate all indexes on system catalogs within the current database.
Indexes on user tables are not processed. Also, indexes on shared
system catalogs are skipped except in stand-alone mode (see below).
+ This form of <command>REINDEX</command> cannot be executed inside a
+ transaction block.
</para>
</listitem>
</varlistentry>