summaryrefslogtreecommitdiff
path: root/check_postgres.pl
diff options
context:
space:
mode:
authorRyan P. Kelly2012-05-09 14:18:59 +0000
committerRyan P. Kelly2012-05-09 14:18:59 +0000
commit700ae911b534b1e567cd887a777ba3ffd1404d7f (patch)
tree25b0de977e22284932cb07e39e13882caad03dd8 /check_postgres.pl
parent58943dff0b346bc7172d079e86282b7127607655 (diff)
Ignore sequences in the temporary namespace
Diffstat (limited to 'check_postgres.pl')
-rwxr-xr-xcheck_postgres.pl1
1 files changed, 1 insertions, 0 deletions
diff --git a/check_postgres.pl b/check_postgres.pl
index 2afb72d5d..a15ecdb7a 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -7148,6 +7148,7 @@ FROM (
JOIN pg_namespace nsp ON nsp.oid = relnamespace
WHERE relkind = 'S'
) AS seqs
+WHERE nspname !~ '^pg_temp.*'
ORDER BY nspname, seqname, typname
};
## use critic