view schema/updates/1004/01.optimize_index-setup.sql @ 5307:4ba3fda13c50 zpg-exception

Fixed typo in migration script.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 28 May 2021 11:17:12 +0200
parents 9ab7e1056360
children
line wrap: on
line source

ALTER TABLE waterway.gauge_measurements
    DROP CONSTRAINT gauge_measurements_location_measure_date_staging_done_key;
ALTER TABLE waterway.gauge_measurements
    ADD CONSTRAINT gauge_measurements_measure_date_location_staging_done_key
    UNIQUE (measure_date, location, staging_done);
DROP INDEX waterway.gauge_measurements_measure_date;

ALTER TABLE waterway.gauge_predictions
    DROP CONSTRAINT gauge_predictions_pkey;
ALTER TABLE waterway.gauge_predictions
    ADD CONSTRAINT gauge_predictions_pkey
    PRIMARY KEY (measure_date, location, date_issue);
DROP INDEX waterway.gauge_predictions_measure_date;

CREATE INDEX gauge_measurements_location_measure_date_desc
    ON waterway.gauge_measurements (location, measure_date DESC)