Fix vacuumlo to avoid unnecessary use of backslash in search pattern.

tglsfdc · tglsfdc · commit f87d4875e94d · 2006-02-23T22:33:59.000Z
Per Michael Fuhr.
diff --git a/contrib/vacuumlo/vacuumlo.c b/contrib/vacuumlo/vacuumlo.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/contrib/vacuumlo/vacuumlo.c,v 1.30 2005/10/15 02:49:08 momjian Exp $
+ *	  $PostgreSQL: pgsql/contrib/vacuumlo/vacuumlo.c,v 1.31 2006/02/23 22:33:59 tgl Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -167,7 +167,7 @@ vacuumlo(char *database, struct _param * param)
 	strcat(buf, "      AND c.relnamespace = s.oid ");
 	strcat(buf, "      AND t.typname in ('oid', 'lo') ");
 	strcat(buf, "      AND c.relkind = 'r'");
-	strcat(buf, "      AND s.nspname NOT LIKE 'pg\\\\_%'");
+	strcat(buf, "      AND s.nspname !~ '^pg_'");
 	res = PQexec(conn, buf);
 	if (PQresultStatus(res) != PGRES_TUPLES_OK)
 	{

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $PostgreSQL: pgsql/contrib/vacuumlo/vacuumlo.c,v 1.30 2005/10/15 02:49:08 momjian Exp $`
	`11`	`+ * $PostgreSQL: pgsql/contrib/vacuumlo/vacuumlo.c,v 1.31 2006/02/23 22:33:59 tgl Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -167,7 +167,7 @@ vacuumlo(char database, struct _param param)`
`167`	`167`	`strcat(buf, " AND c.relnamespace = s.oid ");`
`168`	`168`	`strcat(buf, " AND t.typname in ('oid', 'lo') ");`
`169`	`169`	`strcat(buf, " AND c.relkind = 'r'");`
`170`		`- strcat(buf, " AND s.nspname NOT LIKE 'pg\\\\_%'");`
	`170`	`+ strcat(buf, " AND s.nspname !~ '^pg_'");`
`171`	`171`	`res = PQexec(conn, buf);`
`172`	`172`	`if (PQresultStatus(res) != PGRES_TUPLES_OK)`
`173`	`173`	`{`