Make compatible with pg9.6+ pg_stat_activity view. However 9.6 brings the idle_in_tra...

[postgresql/pg_log_long_xact] / pg_long_xact.plpgsql

diff --git a/pg_long_xact.plpgsql b/pg_long_xact.plpgsql
index 313a5ecbc9e2d4588661ea0fb2f8fc340b1a0ac5..612670f18e9950a013b07b27c9c916802f95eb97 100755 (executable)
--- a/pg_long_xact.plpgsql
+++ b/pg_long_xact.plpgsql
@@ -38,7 +38,7 @@ BEGIN
             
         CASE lower(in_raise_type)
             WHEN 'notice' THEN RAISE NOTICE '%', v_line; 
-            WHEN 'debug' THEN RAISE LOG '%', v_line; 
+            WHEN 'debug' THEN RAISE DEBUG '%', v_line; 
             WHEN 'log' THEN RAISE LOG '%', v_line; 
             WHEN 'info' THEN RAISE INFO '%', v_line; 
             WHEN 'warning' THEN RAISE WARNING '%', v_line;