diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-09-27 17:51:10 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-09-27 17:51:10 +0000 |
| commit | 3468ed586a13d3a55fe873adf99725b40b7fd0a4 (patch) | |
| tree | dde5a60a42d92a57e6ceadf7546b57e1f9a4efdb | |
| parent | d2d0f42040fec6ee4abdeb20dad35ce624ae1872 (diff) | |
| download | postgresql-3468ed586a13d3a55fe873adf99725b40b7fd0a4.tar.gz postgresql-3468ed586a13d3a55fe873adf99725b40b7fd0a4.zip | |
> Fix clusterdb to be schema-aware
Please apply the patch attached and this should be solved.
Alvaro Herrera
| -rw-r--r-- | src/bin/scripts/clusterdb | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/scripts/clusterdb b/src/bin/scripts/clusterdb index dd3021ae7b6..d948dc52069 100644 --- a/src/bin/scripts/clusterdb +++ b/src/bin/scripts/clusterdb @@ -11,7 +11,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/clusterdb,v 1.3 2002/09/12 00:18:14 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/clusterdb,v 1.4 2002/09/27 17:51:10 momjian Exp $ # #------------------------------------------------------------------------- @@ -153,7 +153,7 @@ fi for db in $dbname do [ "$alldb" ] && echo "Clustering $db" - query="SELECT nspname, pg_class.relname, pg_class_2.relname FROM pg_class, pg_class AS pg_class_2 JOIN pg_namespace ON (pg_namespace.oid=relnamespace), pg_index WHERE pg_class.oid=pg_index.indrelid AND pg_class_2.oid=pg_index.indexrelid AND pg_index.indisclustered" + query="SELECT nspname, pg_class.relname, pg_class_2.relname FROM pg_class, pg_class AS pg_class_2 JOIN pg_namespace ON (pg_namespace.oid=relnamespace), pg_index WHERE pg_class.oid=pg_index.indrelid AND pg_class_2.oid=pg_index.indexrelid AND pg_index.indisclustered AND pg_class.relowner=(SELECT usesysid FROM pg_user WHERE usename=current_user)" if [ -z "$table" ]; then tables=`${PATHNAME}psql $db $PSQLOPT -F: -P format=unaligned -t -c "$query"` else |