Mercurial > gemma
view .hgtags @ 3402:c04b1409a596
Fix adaptation of gauge temporal validity
The necessity to update validity implies the new value has to cascade
through to referencing columns.
Because measurements falling into the validity of a new version might
have been already imported, a deadlock situation might occur with
the CHECK constraint on gauge_measurements preventing an update
of validity and the exclusion constraint on gauges preventing the
insertion of a new version before the update. Thus, the exclusion
constraint is now deferred and cannot longer be used with ON CONFLICT
in the INSERT statement. Gauge measurements matching the validity of
a new gauge version are now 'moved' to that new version before the
validity of the old version is adapted.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 23 May 2019 12:27:14 +0200 |
parents | 28f1652cfb4d |
children | fc7b24f89164 |
line wrap: on
line source
532c8392048fe720bf31b7efb475591ab95a74ec v1-uat1 136aaa7f00af0b500c5c75f9fd9aabfc7fa526ee v1.1.0 724758455a4e44d25b096f00bcb353ceda0e0d57 v2-preview20190111 0059aa870a396e2112efae43f822c0c133454d7a v2 83f9a131dfb69f3ea1f430728a0831ccf96316d7 v2.1.0 83f9a131dfb69f3ea1f430728a0831ccf96316d7 v2.1.0 4d69b79e9df6e2b646ac60f75f6655bb3c64f6c6 v2.1.0