From: Jeff Janes <jeff.janes@gmail.com>
Date: Tue, 4 Apr 2017 20:36:59 +0000 (-0700)
Subject: Fix syntax error in table_log_pl_init
X-Git-Url: https://git.8kb.co.uk/?p=postgresql%2Ftable_log_pl;a=commitdiff_plain;h=895372624fd87eb7f9a426a707988def1e8bc0c0

Fix syntax error in table_log_pl_init

table_log_pl_init had an unbalanced apostrophe in the dynamic SQL
it generated, in all versions tested and regardless of the value
of standard_conforming_strings.
---

diff --git a/sql/table_log_pl--0.1.sql b/sql/table_log_pl--0.1.sql
index 4d873b6..4ad8298 100644
--- a/sql/table_log_pl--0.1.sql
+++ b/sql/table_log_pl--0.1.sql
@@ -342,7 +342,7 @@ RETURNS void AS
 $BODY$
 DECLARE
     do_log_user  int = 0;
-    level_create text = E'''';
+    level_create text = E'';
     orig_qq      text;
     log_qq       text;
 BEGIN
diff --git a/sql/table_log_pl_init.sql b/sql/table_log_pl_init.sql
index 8cdfaba..ec470ba 100644
--- a/sql/table_log_pl_init.sql
+++ b/sql/table_log_pl_init.sql
@@ -5,7 +5,7 @@ RETURNS void AS
 $BODY$
 DECLARE
     do_log_user  int = 0;
-    level_create text = E'''';
+    level_create text = E'';
     orig_qq      text;
     log_qq       text;
 BEGIN