Changeset:
c6cd951e0a44
https://sourceforge.net/p/mrbs/hg-code/ci/c6cd951e0a44ca53312771a5ad732404610aec64
Author:
John Beranek <[email protected]>
Date:
Tue Jun 06 19:37:45 2017 +0100
Log message:
Split the "CREATE LANGUAGE" section of the Postgresql db schema
52 upgrade into 3 SQL commands.
diffstat:
web/upgrade/52/post.inc | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diffs (30 lines):
diff -r 372d2538aa69 -r c6cd951e0a44 web/upgrade/52/post.inc
--- a/web/upgrade/52/post.inc Sat Jun 03 06:01:25 2017 +0100
+++ b/web/upgrade/52/post.inc Tue Jun 06 19:37:45 2017 +0100
@@ -16,7 +16,11 @@
CREATE LANGUAGE plpgsql;
SELECT TRUE;
\$\$ LANGUAGE SQL;
+END_OF_SQL;
+ $admin_handle->command($sql);
+
+ $sql = <<<END_OF_SQL
SELECT CASE WHEN NOT
(
SELECT TRUE AS exists
@@ -32,9 +36,14 @@
ELSE
FALSE
END AS plpgsql_created;
+END_OF_SQL;
+ $admin_handle->command($sql);
+
+ $sql = <<<END_OF_SQL
DROP FUNCTION create_language_plpgsql();
END_OF_SQL;
+
$admin_handle->command($sql);
// Add function to update timestamp column
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
