[check_postgres] [commit] Remove all tables, so other test tables don't interfere.

[check_postgres at bucardo.org]

Committed by Greg Sabino Mullane <greg at endpoint.com>

Remove all tables, so other test tables don't interfere.

---
 t/02_relation_size.t |    7 ++++++-
 1 files changed, 6 insertions(+), 1 deletions(-)

diff --git a/t/02_relation_size.t b/t/02_relation_size.t
index f1e28ce..acc3c10 100644
--- a/t/02_relation_size.t
+++ b/t/02_relation_size.t
@@ -52,9 +52,14 @@ like ($cp->run(q{-w 1 --perflimit 2}),
 $t = qq{$S detects no matching tables due to unknown user};
 like ($cp->run(q{-w 1 --includeuser foo}), qr{$label OK:.*No matching entries found due to user exclusion/inclusion options}, $t);
 
+## We need to remove all tables to make this work correctly
 local $dbh->{Warn} = 0;
-$dbh->do("DROP TABLE IF EXISTS $testtbl");
+my @info = $dbh->tables('','public','','TABLE');
+for my $tab (@info) {
+	$dbh->do("DROP TABLE $tab CASCADE");
+}
 $dbh->do(qq{CREATE TABLE $testtbl (a integer)});
+
 $dbh->commit;
 
 $t = qq{$S detects matching tables using 'testuser'};
-- 
1.6.0.5