-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathengineUninstall.sql
More file actions
85 lines (85 loc) · 4.92 KB
/
Copy pathengineUninstall.sql
File metadata and controls
85 lines (85 loc) · 4.92 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
------------------------------------------------------------------------------
-- PostgreSQL Table Tranlation Engine - Uninstallation file
-- Version 0.1 for PostgreSQL 9.x
-- https://github.com/CASFRI/postTranslationEngine
--
-- This is free software; you can redistribute and/or modify it under
-- the terms of the GNU General Public Licence. See the COPYING file.
--
-- Copyright (C) 2018-2020 Pierre Racine <pierre.racine@sbf.ulaval.ca>,
-- Marc Edwards <medwards219@gmail.com>,
-- Pierre Vernier <pierre.vernier@gmail.com>
-------------------------------------------------------------------------------
SELECT TT_DropAllTranslateFct();
DROP FUNCTION IF EXISTS TT_DropAllTTFct();
DROP FUNCTION IF EXISTS _TT_Translate(name, text, text, name, name, name, name);
DROP FUNCTION IF EXISTS TT_Prepare_old(name, name, text, name, name);
DROP FUNCTION IF EXISTS TT_Prepare_old(name, name, text, name);
DROP FUNCTION IF EXISTS TT_Prepare_old(name, name, text);
DROP FUNCTION IF EXISTS TT_Prepare_old(name, name);
DROP FUNCTION IF EXISTS TT_Prepare_old(name);
DROP FUNCTION IF EXISTS TT_Prepare(name, name, text, name, name, boolean, boolean);
DROP FUNCTION IF EXISTS TT_Prepare(name, name, text, name, boolean);
DROP FUNCTION IF EXISTS TT_Prepare(name, name, text, name);
DROP FUNCTION IF EXISTS TT_Prepare(name, name, text, boolean, boolean);
DROP FUNCTION IF EXISTS TT_Prepare(name, name, text, boolean);
DROP FUNCTION IF EXISTS TT_Prepare(name, name, text);
DROP FUNCTION IF EXISTS TT_Prepare(name, name);
DROP FUNCTION IF EXISTS TT_Prepare(name);
DROP FUNCTION IF EXISTS TT_ValidateTTable_old(name, name, boolean);
DROP FUNCTION IF EXISTS TT_ValidateTTable_old(name, boolean);
DROP FUNCTION IF EXISTS TT_ValidateTTable(name, name, boolean);
DROP FUNCTION IF EXISTS TT_ValidateTTable(name, boolean);
DROP FUNCTION IF EXISTS TT_ParseRules_old(text, text, boolean);
DROP FUNCTION IF EXISTS TT_ParseRules(text, text, boolean);
DROP FUNCTION IF EXISTS TT_ParseArgs(text);
DROP FUNCTION IF EXISTS TT_ParseStringList(text, boolean);
DROP FUNCTION IF EXISTS TT_TextFctEval(text, text[], jsonb, anyelement, boolean);
DROP FUNCTION IF EXISTS TT_LowerArr(text[]);
DROP FUNCTION IF EXISTS TT_FctExists(name, text[]);
DROP FUNCTION IF EXISTS TT_FctExists(name, name, text[]);
DROP FUNCTION IF EXISTS TT_TextFctExists(name, int);
DROP FUNCTION IF EXISTS TT_TextFctExists(name, name, int);
DROP FUNCTION IF EXISTS TT_TextFctReturnType(name, name, int);
DROP FUNCTION IF EXISTS TT_TextFctReturnType(name, int);
DROP FUNCTION IF EXISTS TT_FullTableName(name, name);
DROP FUNCTION IF EXISTS TT_FullFunctionName(name, name);
DROP FUNCTION IF EXISTS TT_Debug(int);
DROP FUNCTION IF EXISTS TT_IsError(text);
DROP FUNCTION IF EXISTS TT_RepackStringList(text[], boolean);
DROP FUNCTION IF EXISTS TT_IsCastableTo(text, text);
DROP FUNCTION IF EXISTS TT_EscapeDoubleQuotesAndBackslash(text);
DROP FUNCTION IF EXISTS TT_EscapeSingleQuotes(text);
DROP FUNCTION IF EXISTS TT_IsSingleQuoted(text);
DROP FUNCTION IF EXISTS TT_UnsingleQuote(text);
DROP FUNCTION IF EXISTS TT_TableExists(text, text);
DROP FUNCTION IF EXISTS TT_LogInit(text, text, text, boolean, text);
DROP FUNCTION IF EXISTS TT_ShowLastLog(text, text, text, int);
DROP FUNCTION IF EXISTS TT_DeleteAllLogs(text, text);
DROP FUNCTION IF EXISTS TT_Log(text, text, text, text, text, text, int, int);
DROP FUNCTION IF EXISTS TT_TextFctQuery(text, text[], jsonb, boolean, boolean);
DROP FUNCTION IF EXISTS TT_RuleToSQL(text, text[]);
DROP FUNCTION IF EXISTS TT_ReportError(text, name, name, text, text, text[], jsonb, text, text, int, text, boolean, boolean);
DROP FUNCTION IF EXISTS TT_DefaultProjectErrorCode(text, text);
DROP FUNCTION IF EXISTS TT_GetGeomColName(text, text);
DROP FUNCTION IF EXISTS TT_PrettyDuration(double precision, int);
DROP FUNCTION IF EXISTS TT_ShowProgress(name, text, text, name, name, boolean);
DROP FUNCTION IF EXISTS TT_LastJoinAdded(text[][]);
DROP FUNCTION IF EXISTS TT_AppendParsedJoinToArr(text[][], text[], boolean);
DROP FUNCTION IF EXISTS TT_ParseJoinFctCall(text);
DROP FUNCTION IF EXISTS TT_BuildJoinExpr(text, text[][], text, text, boolean, text);
DROP FUNCTION IF EXISTS TT_PrepareFctCalls(text);
DROP FUNCTION IF EXISTS TT_ReplaceAroundChars(text, text[], text, text, boolean);
DROP FUNCTION IF EXISTS TT_ReplaceAroundChars(text, text, text[], text[], boolean);
DROP FUNCTION IF EXISTS TT_ReplaceAroundChars(text, text, text, text, boolean);
DROP FUNCTION IF EXISTS TT_ReplaceAroundChars(text, text[], text[], text[], boolean);
DROP FUNCTION IF EXISTS TT_IsSurroundedByChars(text, text);
DROP FUNCTION IF EXISTS TT_IsSurroundedByChars(text, text[]);
DROP FUNCTION IF EXISTS TT_OneLevelFctCallRegex();
DROP FUNCTION IF EXISTS TT_NumberRegex();
DROP FUNCTION IF EXISTS TT_AnythingBetweenSingleQuotesRegex();
DROP FUNCTION IF EXISTS TT_AllSpecialCharsRegex();
DROP FUNCTION IF EXISTS TT_NameRegex();
DROP FUNCTION IF EXISTS TT_DropAllTranslateFct();
DROP TYPE IF EXISTS TT_RuleDef_old;
DROP TYPE IF EXISTS TT_RuleDef;