diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-02-23 22:33:59 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-02-23 22:33:59 +0000 |
| commit | f87d4875e94df3cbe3407ebba95d7ba30a655363 (patch) | |
| tree | c820ac4d58c094bc5d0366749fd7ba5f1ec7be10 | |
| parent | 737651f6bebe0cefded367590bd78671af381670 (diff) | |
Fix vacuumlo to avoid unnecessary use of backslash in search pattern.
Per Michael Fuhr.
| -rw-r--r-- | contrib/vacuumlo/vacuumlo.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/contrib/vacuumlo/vacuumlo.c b/contrib/vacuumlo/vacuumlo.c index 810f9cd36ca..93da782f9a0 100644 --- 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) { |