Mercurial > gemma

changeset 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 f27fe4e9bfd9
children fe923c8ef08f
files schema/isrs.sql
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
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),