Mercurial > gemma

view schema/updates/1423/01.axis_as_multilinestring.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 e8b2dc771f9e
children
line wrap: on
line source

-- Cannot alter type of a column used in a trigger definition
DROP TRIGGER waterway_axis_wtwaxs_unique ON waterway.waterway_axis;

ALTER TABLE waterway.waterway_axis
    ALTER wtwaxs TYPE geography(MULTILINESTRING, 4326)
        USING ST_Multi(CAST(wtwaxs AS geometry));

-- Re-create trigger
CREATE CONSTRAINT TRIGGER waterway_axis_wtwaxs_unique
    AFTER INSERT OR UPDATE OF wtwaxs ON waterway.waterway_axis
    FOR EACH ROW EXECUTE FUNCTION prevent_st_equals('wtwaxs');