[postgis-tickets] r17293 - Include raster and sfcgal extensions in opt_out.sh

[Sandro Santilli]

Author: strk
Date: 2019-03-06 06:57:42 -0800 (Wed, 06 Mar 2019)
New Revision: 17293

Modified:
   trunk/extensions/opt_out.sh
Log:
Include raster and sfcgal extensions in opt_out.sh

Modified: trunk/extensions/opt_out.sh
===================================================================
--- trunk/extensions/opt_out.sh	2019-03-06 14:10:17 UTC (rev 17292)
+++ trunk/extensions/opt_out.sh	2019-03-06 14:57:42 UTC (rev 17293)
@@ -9,7 +9,40 @@
 
 psql -XtA ${db} <<'EOF' | psql -XtA ${db}
 
+-----------------
+-- for sfcgal
+-----------------
+
+SELECT 'ALTER EXTENSION ' || extname || ' DROP ' || regexp_replace(
+    regexp_replace(pg_catalog.pg_describe_object(d.classid, d.objid, 0), E'cast from (.*) to (.*)', E'cast\(\\1 as \\2\)'),
+    E'(.*) for access method (.*)', E'\\1 using \\2') || ';' AS sqladd
+FROM pg_catalog.pg_depend AS d
+INNER JOIN pg_extension AS e ON (d.refobjid = e.oid)
+WHERE d.refclassid = 'pg_catalog.pg_extension'::pg_catalog.regclass
+AND deptype = 'e' AND e.extname = 'postgis_sfcgal'
+ORDER BY sqladd;
+
+SELECT 'DROP EXTENSION postgis_sfcgal;';
+
+-----------------
+-- for raster
+-----------------
+
+SELECT 'ALTER EXTENSION ' || extname || ' DROP ' || regexp_replace(
+    regexp_replace(pg_catalog.pg_describe_object(d.classid, d.objid, 0), E'cast from (.*) to (.*)', E'cast\(\\1 as \\2\)'),
+    E'(.*) for access method (.*)', E'\\1 using \\2') || ';' AS sqladd
+FROM pg_catalog.pg_depend AS d
+INNER JOIN pg_extension AS e ON (d.refobjid = e.oid)
+WHERE d.refclassid = 'pg_catalog.pg_extension'::pg_catalog.regclass
+AND deptype = 'e' AND e.extname = 'postgis_raster'
+ORDER BY sqladd;
+
+SELECT 'DROP EXTENSION postgis_raster;';
+
+-----------------
 -- for topology
+-----------------
+
 SELECT 'ALTER EXTENSION ' || extname || ' DROP ' || regexp_replace(
     regexp_replace(pg_catalog.pg_describe_object(d.classid, d.objid, 0), E'cast from (.*) to (.*)', E'cast\(\\1 as \\2\)'),
     E'(.*) for access method (.*)', E'\\1 using \\2') || ';' AS sqladd
@@ -21,7 +54,10 @@
 
 SELECT 'DROP EXTENSION postgis_topology;';
 
--- for postgis
+--------------------
+-- for postgis core
+--------------------
+
 SELECT 'ALTER EXTENSION ' || extname || ' DROP ' || regexp_replace(
     regexp_replace(pg_catalog.pg_describe_object(d.classid, d.objid, 0), E'cast from (.*) to (.*)', E'cast\(\\1 as \\2\)'),
     E'(.*) for access method (.*)', E'\\1 using \\2') || ';' AS sqladd