|
5 | 5 | * Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group |
6 | 6 | * Portions Copyright (c) 1994, Regents of the University of California |
7 | 7 | * |
8 | | - * $PostgreSQL: pgsql/src/bin/scripts/vacuumdb.c,v 1.15 2007/01/05 22:19:50 momjian Exp $ |
| 8 | + * $PostgreSQL: pgsql/src/bin/scripts/vacuumdb.c,v 1.16 2007/02/13 17:39:39 momjian Exp $ |
9 | 9 | * |
10 | 10 | *------------------------------------------------------------------------- |
11 | 11 | */ |
@@ -234,7 +234,7 @@ vacuum_all_databases(bool full, bool verbose, bool analyze, |
234 | 234 | inti; |
235 | 235 |
|
236 | 236 | conn=connectDatabase("postgres",host,port,username,password,progname); |
237 | | -result=executeQuery(conn,"SELECT datname FROM pg_database WHERE datallowconn;",progname,echo); |
| 237 | +result=executeQuery(conn,"SELECT datname FROM pg_database WHERE datallowconn ORDER BY 1;",progname,echo); |
238 | 238 | PQfinish(conn); |
239 | 239 |
|
240 | 240 | for (i=0;i<PQntuples(result);i++) |
|