|
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.nspnameNOT 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 | { |
|