annotate schema/version.sql @ 5005:f697a398eff4 wmst-config

Amend trigger function Additional column names given as arguments to the trigger function will be tested for equality along with the geometry. This allows to implement behavior similar to a multi-column unique constraint (in preparation to store historic versions of axis segments with differing temporal validity). Using EXISTS instead of the aggregate should be more efficient.
author Tom Gottfried <tom@intevation.de>
date Wed, 11 Mar 2020 11:24:20 +0100
parents bb2123358bd8
children e8b2dc771f9e
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
5005
f697a398eff4 Amend trigger function
Tom Gottfried <tom@intevation.de>
parents: 4998
diff changeset
1 INSERT INTO gemma_schema_version(version) VALUES (1422);