Mercurial > gemma

changeset 4174:00279b36cffd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged
author Tom Gottfried <tom@intevation.de>
date Mon, 05 Aug 2019 16:48:11 +0200
parents d3fb2f37380b (diff) 9cbed444b8a4 (current diff)
children 1fb3a62d8ea7
files
diffstat 3 files changed, 14 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Mon Aug 05 16:47:03 2019 +0200
+++ b/schema/gemma.sql	Mon Aug 05 16:48:11 2019 +0200
@@ -228,7 +228,7 @@
 CREATE OR REPLACE FUNCTION get_schema_version() RETURNS int
     LANGUAGE sql
     AS $$
-    SELECT max(version) FROM gemma_schema_version;
+    SELECT max(version) FROM public.gemma_schema_version;
 $$;
 
 
--- a/schema/isrs.sql	Mon Aug 05 16:47:03 2019 +0200
+++ b/schema/isrs.sql	Mon Aug 05 16:48:11 2019 +0200
@@ -23,7 +23,7 @@
 
 CREATE OR REPLACE FUNCTION is_country(code char) RETURNS boolean
 AS $$
-    SELECT EXISTS(SELECT 1 FROM countries WHERE country_code = code)
+    SELECT EXISTS(SELECT 1 FROM public.countries WHERE country_code = code)
 $$
     LANGUAGE sql
     STABLE PARALLEL SAFE;
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1106/01.schemaqualify_tables.sql	Mon Aug 05 16:48:11 2019 +0200
@@ -0,0 +1,12 @@
+CREATE OR REPLACE FUNCTION get_schema_version() RETURNS int
+    LANGUAGE sql
+    AS $$
+    SELECT max(version) FROM public.gemma_schema_version;
+$$;
+
+CREATE OR REPLACE FUNCTION is_country(code char) RETURNS boolean
+AS $$
+    SELECT EXISTS(SELECT 1 FROM public.countries WHERE country_code = code)
+$$
+    LANGUAGE sql
+    STABLE PARALLEL SAFE;