From cce26a639a5781f0700b9539a3f3436d8ce8a599 Mon Sep 17 00:00:00 2001
From: dakkar <dakkar@thenautilus.net>
Date: Sat, 22 Apr 2017 13:44:32 +0100
Subject: silence no-create notice from postgres

---
 lib/Dakkar/TweetArchive/Store.pm | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/lib/Dakkar/TweetArchive/Store.pm b/lib/Dakkar/TweetArchive/Store.pm
index b716166..041f506 100644
--- a/lib/Dakkar/TweetArchive/Store.pm
+++ b/lib/Dakkar/TweetArchive/Store.pm
@@ -104,12 +104,16 @@ SQL
 
 sub _ensure_schema($self,$dbh) {
     # simple-minded schema version management
-    $dbh->do(<<'SQL');
+    {
+        # silence the 'NOTICE:  relation "meta" already exists, skipping'
+        local $dbh->{PrintWarn} = 0;
+        $dbh->do(<<'SQL');
 CREATE TABLE IF NOT EXISTS meta (
   version INTEGER PRIMARY KEY,
   created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP
 )
 SQL
+    }
     my $current_version = $dbh->selectall_arrayref(
         q{SELECT max(version) FROM meta}
     )->[0][0];
-- 
cgit v1.2.3