Commitd9db80f

committed

Add code so database scans are done in an order consistent with

pg_dumpall.

1 parentfb2b088 commitd9db80fCopy full SHA for d9db80f

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -4,7 +4,7 @@`
`4`	`4`	`*`
`5`	`5`	`* Portions Copyright (c) 2002-2007, PostgreSQL Global Development Group`
`6`	`6`	`*`
`7`		`- * $PostgreSQL: pgsql/src/bin/scripts/clusterdb.c,v 1.15 2007/01/05 22:19:50 momjian Exp $`
	`7`	`+ * $PostgreSQL: pgsql/src/bin/scripts/clusterdb.c,v 1.16 2007/02/13 18:06:18 momjian Exp $`
`8`	`8`	`*`
`9`	`9`	`*-------------------------------------------------------------------------`
`10`	`10`	`*/`
`@@ -208,7 +208,7 @@ cluster_all_databases(const char host, const char port,`
`208`	`208`	`inti;`
`209`	`209`
`210`	`210`	`conn=connectDatabase("postgres",host,port,username,password,progname);`
`211`		`-result=executeQuery(conn,"SELECT datname FROM pg_database WHERE datallowconn;",progname,echo);`
	`211`	`+result=executeQuery(conn,"SELECT datname FROM pg_database WHERE datallowconn ORDER BY 1;",progname,echo);`
`212`	`212`	`PQfinish(conn);`
`213`	`213`
`214`	`214`	`for (i=0;i<PQntuples(result);i++)`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -4,7 +4,7 @@`
`4`	`4`	`*`
`5`	`5`	`* Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group`
`6`	`6`	`*`
`7`		`- * $PostgreSQL: pgsql/src/bin/scripts/reindexdb.c,v 1.8 2007/01/05 22:19:50 momjian Exp $`
	`7`	`+ * $PostgreSQL: pgsql/src/bin/scripts/reindexdb.c,v 1.9 2007/02/13 18:06:18 momjian Exp $`
`8`	`8`	`*`
`9`	`9`	`*-------------------------------------------------------------------------`
`10`	`10`	`*/`
`@@ -269,7 +269,7 @@ reindex_all_databases(const char host, const char port,`
`269`	`269`	`inti;`
`270`	`270`
`271`	`271`	`conn=connectDatabase("postgres",host,port,username,password,progname);`
`272`		`-result=executeQuery(conn,"SELECT datname FROM pg_database WHERE datallowconn;",progname,echo);`
	`272`	`+result=executeQuery(conn,"SELECT datname FROM pg_database WHERE datallowconn ORDER BY 1;",progname,echo);`
`273`	`273`	`PQfinish(conn);`
`274`	`274`
`275`	`275`	`for (i=0;i<PQntuples(result);i++)`

Comments

(0)