liquid_feedback_core
diff geoindex_uninstall.sql @ 622:5b7c4082d7b3
Version 4.2.2 with geoindices uninstalled by default
author | jbe |
---|---|
date | Fri Feb 05 12:53:00 2021 +0100 (2021-02-05) |
parents | |
children |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/geoindex_uninstall.sql Fri Feb 05 12:53:00 2021 +0100 1.3 @@ -0,0 +1,13 @@ 1.4 +BEGIN; 1.5 + 1.6 +--DROP FUNCTION IF EXISTS "closed_initiatives_in_bounding_box" (EBOX, INT4); 1.7 +DROP INDEX IF EXISTS "suggestion_location_idx"; -- since v4.2.2 1.8 +DROP INDEX IF EXISTS "draft_location_idx"; -- since v4.2.2 1.9 +DROP INDEX IF EXISTS "initiative_location_idx"; -- since v4.2.2 1.10 +DROP INDEX IF EXISTS "area_location_idx"; -- since v4.2.2 1.11 +DROP INDEX IF EXISTS "unit_location_idx"; -- since v4.2.2 1.12 +DROP INDEX IF EXISTS "member_location_idx"; -- since v4.2.2 1.13 + 1.14 +DROP EXTENSION IF EXISTS latlon; -- since v4.2.2 1.15 + 1.16 +COMMIT;