Mercurial > gemma

diff schema/isrs.sql @ 937:72430f050d90

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improve error message for isrs_fromText
author Tom Gottfried <tom@intevation.de>
date Mon, 08 Oct 2018 19:48:51 +0200
parents 642df1164aca
children d0a5bb018fc9
line wrap: on
line diff
--- a/schema/isrs.sql	Mon Oct 08 18:09:28 2018 +0200
+++ b/schema/isrs.sql	Mon Oct 08 19:48:51 2018 +0200
@@ -39,7 +39,8 @@
     IF char_length(isrs_text) <> isrs_len
     THEN
         RAISE 'ISRS location code must be % characters long', isrs_len
-            USING ERRCODE = 'invalid_parameter_value';
+            USING ERRCODE = 'invalid_parameter_value',
+                DETAIL = 'Failing value: ' || isrs_text;
     ELSE
         RETURN CAST((
             substring(isrs_text from 1 for 2),