
diff -r e408da1419cd -r 0ebef32c34af dbicdh/PostgreSQL/deploy/2/002-extract_crashing_functions.sql
--- a/dbicdh/PostgreSQL/deploy/2/002-extract_crashing_functions.sql	Sun Sep 27 22:45:40 2015 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,22 +0,0 @@
-
-CREATE OR REPLACE FUNCTION extract_crashing_functions (processed_json jsonb) RETURNS text AS
-$$
-    -- extract threads[crashing_idx]->frames[*]->function
-    SELECT string_agg(functions, E'\n')
-    FROM (
-        SELECT jsonb_array_elements(
-            (($1 #> ARRAY['threads', $1->'crash_info'->>'crashing_thread'])->'frames')
-        )->>'function' AS functions
-    ) AS frames
-$$
-LANGUAGE sql IMMUTABLE;
-
--- This extension is the contrib modules
-CREATE EXTENSION IF NOT EXISTS pg_trgm;
-
--- Used for searching function in the crashing thread backtrace
--- Search will be really slow if this index is not present
-CREATE INDEX crash_report_datas_idx_extract_crashing_functions ON crash_report_datas USING gist (
-    extract_crashing_functions(processed) gist_trgm_ops
-);
-




