Mercurial > gemma

diff schema/gemma.sql @ 4132:ec8438712447

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Enable better error handling for referenced gauges/bottlenecks constraints.
author Sascha Wilde <wilde@intevation.de>
date Thu, 01 Aug 2019 19:12:47 +0200
parents 8c62809ea87e
children d3fb2f37380b
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Aug 01 18:53:51 2019 +0200
+++ b/schema/gemma.sql	Thu Aug 01 19:12:47 2019 +0200
@@ -103,7 +103,7 @@
             USING
                 DETAIL = format('No matching gauge %s found.',
                     isrs_AsText(referenced_gauge::isrs)),
-                ERRCODE = 23505,
+                ERRCODE = 23503,
                 SCHEMA = TG_TABLE_SCHEMA,
                 TABLE = TG_TABLE_NAME,
                 COLUMN = TG_ARGV[0],
@@ -141,7 +141,7 @@
             USING
                 DETAIL = format('No matching gauge %s found.',
                     isrs_AsText(referenced_gauge::isrs)),
-                ERRCODE = 23505,
+                ERRCODE = 23503,
                 SCHEMA = TG_TABLE_SCHEMA,
                 TABLE = TG_TABLE_NAME,
                 COLUMN = TG_ARGV[0],
@@ -179,7 +179,7 @@
             USING
                 DETAIL = format('No matching bottleneck %s for %s found.',
                     referenced_bottleneck_id, new_tstz),
-                ERRCODE = 23505,
+                ERRCODE = 23503,
                 SCHEMA = TG_TABLE_SCHEMA,
                 TABLE = TG_TABLE_NAME,
                 COLUMN = TG_ARGV[0],