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 4d873b66f25a372c6368bf183b16cfd8e073843c..4ad8298d02bf3338bb559c144d42b6124efef7a5 100644 (file)
--- 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;
 $BODY$
 DECLARE
     do_log_user  int = 0;

-    level_create text = E'''';
+    level_create text = E'';

     orig_qq      text;
     log_qq       text;
 BEGIN
     orig_qq      text;
     log_qq       text;
 BEGIN

diff --git a/sql/table_log_pl_init.sql b/sql/table_log_pl_init.sql
index 8cdfaba52ad64855fc8b4657e03b29827dcac238..ec470baae492eac2ba0c6e5d2c371cfdf3a16585 100644 (file)
--- 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;
 $BODY$
 DECLARE
     do_log_user  int = 0;

-    level_create text = E'''';
+    level_create text = E'';

     orig_qq      text;
     log_qq       text;
 BEGIN
     orig_qq      text;
     log_qq       text;
 BEGIN