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.

FROM ubuntu:bionic
LABEL authors="tom.gottfried@intevation.de"
LABEL description="Contains software from gemma, for right holders and\
 licensing infos, see https://hg.intevation.de/gemma ."

RUN sed -i 's/\(deb.*\)$/\1 universe/' /etc/apt/sources.list

RUN apt-get update &&\
    apt-get -y install --no-install-recommends libxml2-utils\
            make git golang-go \
            ca-certificates

WORKDIR /opt/gemma

# Copy only backend stuff
COPY 3rdpartylibs.sh ./
COPY pkg ./pkg/
COPY cmd ./cmd/
COPY Makefile ./
COPY example_conf.toml ./

RUN make install

EXPOSE 8000

CMD ["/usr/local/bin/gemma", "-c", "/opt/gemma/example_conf.toml"]