Mercurial > gemma

diff schema/gemma.sql @ 4173:d3fb2f37380b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Schema qualify tables in function body This prevents errors or unexpected results in situations where the search_path does otherwise not allow to find the expected table.
author Tom Gottfried <tom@intevation.de>
date Mon, 05 Aug 2019 16:45:48 +0200
parents ec8438712447
children 65a5501dc13d
line wrap: on
line diff
--- a/schema/gemma.sql	Mon Aug 05 16:43:31 2019 +0200
+++ b/schema/gemma.sql	Mon Aug 05 16:45:48 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;
 $$;