From 624361721aa786afdf7477d6a118ca10dabdbc86 Mon Sep 17 00:00:00 2001
From: Greg Sabino Mullane <greg@endpoint.com>
Date: Fri, 1 May 2015 21:23:40 -0400
Subject: [PATCH] Remove default value from sync.isolation_level, so we can
 respect the global one easier.

---
 bucardo        | 1 +
 bucardo.schema | 2 +-
 2 files changed, 2 insertions(+), 1 deletion(-)

diff --git a/bucardo b/bucardo
index 6a3858f2e..fbdb65a3f 100755
--- a/bucardo
+++ b/bucardo
@@ -7822,6 +7822,7 @@ sub upgrade {
     my @altered_columns = (
         ['bucardo', 'goat', 'rebuild_index',     'BOOL2SMALLINT1'],
         ['bucardo', 'goat', 'schemaname',        'NO DEFAULT'],
+        ['bucardo', 'sync', 'isolation_level',   'NO DEFAULT'],
         ['bucardo', 'sync', 'rebuild_index',     'BOOL2SMALLINT1'],
         ['bucardo', 'sync', 'standard_conflict', 'RENAME conflict_strategy'],
         ['bucardo', 'sync', 'ping',              'RENAME autokick'],
diff --git a/bucardo.schema b/bucardo.schema
index f1b1e9ab6..588e7d3b6 100644
--- a/bucardo.schema
+++ b/bucardo.schema
@@ -421,7 +421,7 @@ CREATE TABLE bucardo.sync (
   onetimecopy        SMALLINT    NOT NULL DEFAULT 0,
   lifetime           INTERVAL        NULL,                   -- force controller and kids to restart
   maxkicks           INTEGER     NOT NULL DEFAULT 0,         -- force controller and kids to restart
-  isolation_level    TEXT            NULL DEFAULT 'repeatable read',
+  isolation_level    TEXT            NULL,
   cdate              TIMESTAMPTZ NOT NULL DEFAULT now()
 );
 COMMENT ON TABLE bucardo.sync IS $$Defines a single replication event from a herd to one or more target databases$$;
-- 
2.39.5