diff options
| author | Bruce Momjian | 2002-06-23 03:37:12 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2002-06-23 03:37:12 +0000 |
| commit | 30be6c23c123d367542f1cc7e1b11cd11e898366 (patch) | |
| tree | dca4de313b6d69190d3608fc09ae2c6a321521db /contrib | |
| parent | a8a1f158775cb0f83707aa4211c02f4780eed07f (diff) | |
Handle mixed-case names in reindex script.
Document need for reindex in SGML docs.
Diffstat (limited to 'contrib')
| -rw-r--r-- | contrib/reindex/reindex | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/contrib/reindex/reindex b/contrib/reindex/reindex index 756771af76..463ec4ffcf 100644 --- a/contrib/reindex/reindex +++ b/contrib/reindex/reindex @@ -1,6 +1,6 @@ #!/bin/sh # -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- # -# Package : reindexdb Version : $Revision: 1.2 $ +# Package : reindexdb Version : $Revision: 1.3 $ # Date : 05/08/2002 Author : Shaun Thomas # Req : psql, sh, perl, sed Type : Utility # @@ -188,7 +188,7 @@ if [ "$index" ]; then # Ok, no index. Is there a specific table to reindex? elif [ "$table" ]; then - $PSQL $PSQLOPT $ECHOOPT -c "REINDEX TABLE $table" -d $dbname + $PSQL $PSQLOPT $ECHOOPT -c "REINDEX TABLE \"$table\"" -d $dbname # No specific table, no specific index, either we have a specific database, # or were told to do all databases. Do it! @@ -206,7 +206,7 @@ else # database that we may reindex. tables=`$PSQL $PSQLOPT -q -t -A -d $db -c "$sql"` for tab in $tables; do - $PSQL $PSQLOPT $ECHOOPT -c "REINDEX TABLE $tab" -d $db + $PSQL $PSQLOPT $ECHOOPT -c "REINDEX TABLE \"$tab\"" -d $db done done |