Mercurial > gemma

view schema/updates/1438/01.remove_duplicate_fairway_areas.sql @ 5560:f2204f91d286

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +0100
parents 20f338cb4d48
children
line wrap: on
line source

-- Remove entries that do not suffice the requirements set out by the
-- constraint trigger on fairway_dimensions, but that could be left over
-- from an import run before the constraint trigger was in place
DELETE FROM waterway.fairway_dimensions fd
    USING waterway.fairway_dimensions fd_self
    WHERE ST_Equals(CAST(fd.area AS geometry), CAST(fd_self.area AS geometry))
        AND fd.validity && fd_self.validity
        AND fd.staging_done = fd_self.staging_done
        AND fd.id < fd_self.id