ALTER TABLE waterway.bottlenecks
    DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_key,
    DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_excl,
    DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_staging_done_key,
    DROP CONSTRAINT IF EXISTS bottlenecks_bottleneck_id_validity_staging_done_excl;

ALTER TABLE waterway.bottlenecks
    ADD CONSTRAINT bottlenecks_bottleneck_id_validity_staging_done_key
        UNIQUE (bottleneck_id, validity, staging_done),
    ADD CONSTRAINT bottlenecks_bottleneck_id_validity_staging_done_excl
        EXCLUDE USING GiST (bottleneck_id WITH =,
                            validity WITH &&,
                            CAST(staging_done AS int) WITH =)
        DEFERRABLE INITIALLY DEFERRED;