Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
4131:49ec33a7f954 4132:ec8438712447
101 'new row for relation "%" violates constraint trigger "%"', 101 'new row for relation "%" violates constraint trigger "%"',
102 TG_TABLE_NAME, TG_NAME 102 TG_TABLE_NAME, TG_NAME
103 USING 103 USING
104 DETAIL = format('No matching gauge %s found.', 104 DETAIL = format('No matching gauge %s found.',
105 isrs_AsText(referenced_gauge::isrs)), 105 isrs_AsText(referenced_gauge::isrs)),
106 ERRCODE = 23505, 106 ERRCODE = 23503,
107 SCHEMA = TG_TABLE_SCHEMA, 107 SCHEMA = TG_TABLE_SCHEMA,
108 TABLE = TG_TABLE_NAME, 108 TABLE = TG_TABLE_NAME,
109 COLUMN = TG_ARGV[0], 109 COLUMN = TG_ARGV[0],
110 CONSTRAINT = TG_NAME; 110 CONSTRAINT = TG_NAME;
111 END IF; 111 END IF;
139 'new row for relation "%" violates constraint trigger "%"', 139 'new row for relation "%" violates constraint trigger "%"',
140 TG_TABLE_NAME, TG_NAME 140 TG_TABLE_NAME, TG_NAME
141 USING 141 USING
142 DETAIL = format('No matching gauge %s found.', 142 DETAIL = format('No matching gauge %s found.',
143 isrs_AsText(referenced_gauge::isrs)), 143 isrs_AsText(referenced_gauge::isrs)),
144 ERRCODE = 23505, 144 ERRCODE = 23503,
145 SCHEMA = TG_TABLE_SCHEMA, 145 SCHEMA = TG_TABLE_SCHEMA,
146 TABLE = TG_TABLE_NAME, 146 TABLE = TG_TABLE_NAME,
147 COLUMN = TG_ARGV[0], 147 COLUMN = TG_ARGV[0],
148 CONSTRAINT = TG_NAME; 148 CONSTRAINT = TG_NAME;
149 END IF; 149 END IF;
177 'new row for relation "%" violates constraint trigger "%"', 177 'new row for relation "%" violates constraint trigger "%"',
178 TG_TABLE_NAME, TG_NAME 178 TG_TABLE_NAME, TG_NAME
179 USING 179 USING
180 DETAIL = format('No matching bottleneck %s for %s found.', 180 DETAIL = format('No matching bottleneck %s for %s found.',
181 referenced_bottleneck_id, new_tstz), 181 referenced_bottleneck_id, new_tstz),
182 ERRCODE = 23505, 182 ERRCODE = 23503,
183 SCHEMA = TG_TABLE_SCHEMA, 183 SCHEMA = TG_TABLE_SCHEMA,
184 TABLE = TG_TABLE_NAME, 184 TABLE = TG_TABLE_NAME,
185 COLUMN = TG_ARGV[0], 185 COLUMN = TG_ARGV[0],
186 CONSTRAINT = TG_NAME; 186 CONSTRAINT = TG_NAME;
187 END IF; 187 END IF;