From bd72f9dc786e2aa20508177ce095cc91f196c96f Mon Sep 17 00:00:00 2001
From: Greg Sabino Mullane <greg@endoint.com>
Date: Wed, 10 Feb 2010 08:48:19 -0500
Subject: [PATCH] Make search_path declaration LOCAL

---
 bucardo.schema | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/bucardo.schema b/bucardo.schema
index ee7c2d8f4..db54eaedd 100644
--- a/bucardo.schema
+++ b/bucardo.schema
@@ -2131,7 +2131,7 @@ LANGUAGE plpgsql
 VOLATILE
 AS $clone$
 DECLARE
-  fmsg TEXT = $clone2$SET search_path = 'bucardo';$clone2$;
+  fmsg TEXT = $clone2$SET LOCAL search_path = 'bucardo';$clone2$;
   myst TEXT;
   myrec RECORD;
   myrec2 RECORD;
-- 
2.39.5